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_CANCEL_PVT dependencies on STANDARD

Line 83: -- Start standard API initialization

79:
80: l_drop_ship_row l_drop_ship_csr%ROWTYPE;
81:
82: BEGIN
83: -- Start standard API initialization
84: IF FND_API.to_boolean(p_init_msg_list) THEN
85: FND_MSG_PUB.initialize;
86: END IF;
87:

Line 197: -- Start standard API initialization

193: l_partial_rcv_bld NUMBER;
194: l_return_status BOOLEAN;
195:
196: BEGIN
197: -- Start standard API initialization
198: IF FND_API.to_boolean(p_init_msg_list) THEN
199: FND_MSG_PUB.initialize;
200: END IF;
201:

Line 360: -- Start standard API initialization

356:
357: l_progress VARCHAR2(3) := '000' ;
358:
359: BEGIN
360: -- Start standard API initialization
361: IF FND_API.to_boolean(p_init_msg_list) THEN
362: FND_MSG_PUB.initialize;
363: END IF;
364:

Line 512: -- standard PO case.

508:
509: --Function:
510: -- Updates the Qty Recvd and Qty billed of schedule releases to Planned Po
511: -- shipemnts/Distributions.This way we can treat the cancellation as a regular
512: -- standard PO case.
513: --
514: --
515: --Parameters:
516: --IN:

Line 547: -- Start standard API initialization

543: d_module CONSTANT VARCHAR2(100) := g_module_prefix||d_api_name;
544: l_progress VARCHAR2(3) := '000' ;
545:
546: BEGIN
547: -- Start standard API initialization
548: IF FND_API.to_boolean(p_init_msg_list) THEN
549: FND_MSG_PUB.initialize;
550: END IF;
551:

Line 726: -- Start standard API initialization

722:
723: l_progress VARCHAR2(3) := '000' ;
724:
725: BEGIN
726: -- Start standard API initialization
727: IF FND_API.to_boolean(p_init_msg_list) THEN
728: FND_MSG_PUB.initialize;
729: END IF;
730:

Line 933: -- Start standard API initialization

929: l_emp_id NUMBER := FND_GLOBAL.employee_id;
930: l_request_id PO_HEADERS.request_id%TYPE := fnd_global.conc_request_id;
931:
932: BEGIN
933: -- Start standard API initialization
934: IF FND_API.to_boolean(p_init_msg_list) THEN
935: FND_MSG_PUB.initialize;
936: END IF;
937:

Line 1110: -- Start standard API initialization

1106: l_progress VARCHAR2(3) := '000' ;
1107: l_emp_id NUMBER := FND_GLOBAL.employee_id;
1108:
1109: BEGIN
1110: -- Start standard API initialization
1111: IF FND_API.to_boolean(p_init_msg_list) THEN
1112: FND_MSG_PUB.initialize;
1113: END IF;
1114:

Line 1134: AND poll.shipment_type IN ('STANDARD','PLANNED'))

1130: NVL(poll.quantity,0)
1131: - NVL(poll.quantity_cancelled, 0))
1132: FROM po_line_locations POLL
1133: WHERE poll.po_line_id = pol.po_line_id
1134: AND poll.shipment_type IN ('STANDARD','PLANNED'))
1135:
1136: WHERE pol.po_line_id=(SELECT po_line_id
1137: FROM po_line_locations
1138: WHERE line_location_id = p_ship_id)

Line 1162: AND poll.shipment_type = 'STANDARD'

1158: SET pol.unit_price =
1159: (SELECT SUM(poll.price_override)
1160: FROM po_line_locations POLL
1161: WHERE poll.po_line_id = pol.po_line_id
1162: AND poll.shipment_type = 'STANDARD'
1163: AND nvl(poll.cancel_flag, 'N') = 'N'
1164: AND nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
1165:
1166: WHERE pol.po_line_id=(SELECT po_line_id

Line 1204: AND poll.shipment_type IN ('STANDARD','PLANNED'))

1200: (NVL(poll.amount, 0) - NVL(poll.amount_cancelled,0))
1201: ))
1202: FROM po_line_locations POLL
1203: WHERE poll.po_line_id = pol.po_line_id
1204: AND poll.shipment_type IN ('STANDARD','PLANNED'))
1205:
1206: WHERE pol.po_line_id =(SELECT po_line_id
1207: FROM po_line_locations
1208: WHERE line_location_id= p_ship_id)

Line 1303: -- Start standard API initialization

1299: l_emp_id NUMBER := FND_GLOBAL.employee_id;
1300: l_request_id PO_HEADERS.request_id%TYPE := fnd_global.conc_request_id;
1301:
1302: BEGIN
1303: -- Start standard API initialization
1304: IF FND_API.to_boolean(p_init_msg_list) THEN
1305: FND_MSG_PUB.initialize;
1306: END IF;
1307:

Line 1359: AND poll.shipment_type IN('STANDARD','PLANNED'))

1355: pol.quantity,
1356: (SELECT SUM(NVL(poll.quantity,0) -NVL(poll.quantity_cancelled,0))
1357: FROM po_line_locations POLL
1358: WHERE poll.po_line_id = pol.po_line_id
1359: AND poll.shipment_type IN('STANDARD','PLANNED'))
1360: ),
1361: pol.amount =
1362: DECODE(pol.amount,
1363: NULL,

Line 1374: AND poll.shipment_type IN ('STANDARD','PLANNED')) )

1370: )
1371: )
1372: FROM po_line_locations POLL
1373: WHERE poll.po_line_id = pol.po_line_id
1374: AND poll.shipment_type IN ('STANDARD','PLANNED')) )
1375: WHERE nvl(pol.cancel_flag,'N') = 'N'
1376: AND nvl(pol.closed_code,'OPEN') <> 'FINALLY CLOSED'
1377: AND pol.po_line_id IN (
1378: SELECT po_line_id

Line 1493: -- Start standard API initialization

1489: l_emp_id NUMBER := FND_GLOBAL.employee_id;
1490: l_request_id PO_HEADERS.request_id%TYPE := fnd_global.conc_request_id;
1491:
1492: BEGIN
1493: -- Start standard API initialization
1494: IF FND_API.to_boolean(p_init_msg_list) THEN
1495: FND_MSG_PUB.initialize;
1496: END IF;
1497:

Line 1639: -- Start standard API initialization

1635: l_emp_id NUMBER := FND_GLOBAL.employee_id;
1636: l_request_id PO_HEADERS.request_id%TYPE := fnd_global.conc_request_id;
1637:
1638: BEGIN
1639: -- Start standard API initialization
1640: IF FND_API.to_boolean(p_init_msg_list) THEN
1641: FND_MSG_PUB.initialize;
1642: END IF;
1643:

Line 1800: -- Start standard API initialization

1796:
1797: l_progress VARCHAR2(3) := '000' ;
1798:
1799: BEGIN
1800: -- Start standard API initialization
1801: IF FND_API.to_boolean(p_init_msg_list) THEN
1802: FND_MSG_PUB.initialize;
1803: END IF;
1804:

Line 1832: -- Standard/Planned PO or Release, the corresponding distributions

1828: x_msg_data := NULL;
1829:
1830: -- This block is applicable to level: Header/Line/Shipment
1831: -- If the Entity being Canceld belongs to a
1832: -- Standard/Planned PO or Release, the corresponding distributions
1833: -- and shipments have to be canceled
1834: -- So cancelling the distributions and shipments in all cases if the
1835: -- document type is not 'Purchase Agreement(PA)'
1836:

Line 1889: -- Standard/Planned PO or Blanket Agreement, the line details need to

1885: l_progress := '005';
1886:
1887: -- This block is applicable to level: Header/Line/Shipment
1888: -- If the Entity being Canceld belongs to a
1889: -- Standard/Planned PO or Blanket Agreement, the line details need to
1890: -- be updated
1891: -- If the PO Shipment is canceled, update(rollup) the qty/amount on line
1892: -- If the Line/Header is canceled, cancel the corresponding line itself
1893: -- So Updating the line details in case if the

Line 2083: -- Start standard API initialization

2079: l_recreate_flag BOOLEAN;
2080:
2081:
2082: BEGIN
2083: -- Start standard API initialization
2084: IF FND_API.to_boolean(p_init_msg_list) THEN
2085: FND_MSG_PUB.initialize;
2086: END IF;
2087:

Line 2285: -- Start standard API initialization

2281: l_ship_id NUMBER := 0;
2282:
2283:
2284: BEGIN
2285: -- Start standard API initialization
2286: IF FND_API.to_boolean(p_init_msg_list) THEN
2287: FND_MSG_PUB.initialize;
2288: END IF;
2289:

Line 2432: -- Start standard API initialization

2428: l_ship_id NUMBER ;
2429:
2430:
2431: BEGIN
2432: -- Start standard API initialization
2433: IF FND_API.to_boolean(p_init_msg_list) THEN
2434: FND_MSG_PUB.initialize;
2435: END IF;
2436:

Line 2655: 'STANDARD',

2651: AND pod.req_distribution_id = prd.distribution_id
2652: AND NVL(poll.cancel_flag, 'N') = 'I'
2653: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2654: AND poll.shipment_type IN(
2655: 'STANDARD',
2656: 'PLANNED' ,
2657: 'BLANKET' ,
2658: 'PREPAYMENT')
2659: AND ((p_entity_level = c_entity_level_HEADER

Line 2679: 'STANDARD',

2675: WHERE prl.line_location_id= (-1 * poll.line_location_id)
2676: AND NVL(poll.cancel_flag, 'N') = 'Y'
2677: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2678: AND poll.shipment_type IN(
2679: 'STANDARD',
2680: 'PLANNED' ,
2681: 'BLANKET' ,
2682: 'PREPAYMENT')
2683: AND ((p_entity_level = c_entity_level_HEADER

Line 2698: -- Start standard API initialization

2694:
2695:
2696:
2697: BEGIN
2698: -- Start standard API initialization
2699: IF FND_API.to_boolean(p_init_msg_list) THEN
2700: FND_MSG_PUB.initialize;
2701: END IF;
2702:

Line 2826: -- Start standard API initialization

2822:
2823:
2824:
2825: BEGIN
2826: -- Start standard API initialization
2827: IF FND_API.to_boolean(p_init_msg_list) THEN
2828: FND_MSG_PUB.initialize;
2829: END IF;
2830:

Line 2926: -- Start standard API initialization

2922: l_progress VARCHAR2(3) := '000' ;
2923:
2924:
2925: BEGIN
2926: -- Start standard API initialization
2927: IF FND_API.to_boolean(p_init_msg_list) THEN
2928: FND_MSG_PUB.initialize;
2929: END IF;
2930:

Line 2966: 'STANDARD',

2962: WHERE pord.requisition_line_id = p_req_line_id
2963: AND pord.distribution_id = pod.req_distribution_id
2964: AND POLL.line_location_id = POD.line_location_id
2965: AND POLL.shipment_type IN(
2966: 'STANDARD',
2967: 'PLANNED' ,
2968: 'BLANKET');
2969:
2970: IF g_debug_stmt THEN

Line 3046: -- Start standard API initialization

3042: l_auth_status VARCHAR2(30);
3043:
3044:
3045: BEGIN
3046: -- Start standard API initialization
3047: IF FND_API.to_boolean(p_init_msg_list) THEN
3048: FND_MSG_PUB.initialize;
3049: END IF;
3050:

Line 3126: AND POLL.shipment_type IN ('STANDARD',

3122: FROM po_line_locations POLL,
3123: PO_DISTRIBUTIONS_ALL POD
3124: WHERE POD.req_distribution_id = PORD.distribution_id
3125: AND POLL.line_location_id = POD.line_location_id
3126: AND POLL.shipment_type IN ('STANDARD',
3127: 'PLANNED' ,
3128: 'BLANKET') )
3129: WHERE PORD.requisition_line_id = p_req_line_id ;
3130:

Line 3187: AND POLL.shipment_type IN ('STANDARD' ,

3183: FROM po_line_locations POLL,
3184: PO_DISTRIBUTIONS_ALL POD
3185: WHERE POD.req_distribution_id = PORD.distribution_id
3186: AND POLL.line_location_id = POD.line_location_id
3187: AND POLL.shipment_type IN ('STANDARD' ,
3188: 'PLANNED' ,
3189: 'BLANKET') ),
3190:
3191: PORD.last_update_date = SYSDATE ,

Line 3420: -- Start standard API initialization

3416: l_is_qty_zero BOOLEAN := FALSE;
3417: l_qzero NUMBER := 0;
3418:
3419: BEGIN
3420: -- Start standard API initialization
3421: IF FND_API.to_boolean(p_init_msg_list) THEN
3422: FND_MSG_PUB.initialize;
3423: END IF;
3424:

Line 3528: -- Start standard API initialization

3524: l_next_line_num NUMBER;
3525: l_progress VARCHAR2(3) := '000' ;
3526:
3527: BEGIN
3528: -- Start standard API initialization
3529: IF FND_API.to_boolean(p_init_msg_list) THEN
3530: FND_MSG_PUB.initialize;
3531: END IF;
3532:

Line 3880: -- Start standard API initialization

3876: l_progress VARCHAR2(3) := '000' ;
3877: l_uom_conv NUMBER := 0;
3878:
3879: BEGIN
3880: -- Start standard API initialization
3881: IF FND_API.to_boolean(p_init_msg_list) THEN
3882: FND_MSG_PUB.initialize;
3883: END IF;
3884:

Line 4055: 'STANDARD',

4051: AND PORD.requisition_line_id = PORL_OLD.requisition_line_id
4052: AND POD.req_distribution_id = PORD.distribution_id
4053: AND POD.line_location_id = PLL.line_location_id
4054: AND PLL.shipment_type IN (
4055: 'STANDARD',
4056: 'PLANNED' ,
4057: 'BLANKET')
4058: AND NVL(POD.quantity_cancelled, 0) >= 0
4059: AND PORL_NEW.blanket_po_header_id = BLANKET.po_header_id(+)

Line 4193: -- Start standard API initialization

4189: l_new_req_line_id NUMBER;
4190:
4191:
4192: BEGIN
4193: -- Start standard API initialization
4194: IF FND_API.to_boolean(p_init_msg_list) THEN
4195: FND_MSG_PUB.initialize;
4196: END IF;
4197:

Line 4363: 'STANDARD',

4359: WHERE PORL.requisition_line_id = PORD.requisition_line_id
4360: AND POD.req_distribution_id = PORD.distribution_id
4361: AND POD.line_location_id = PLL.line_location_id
4362: AND PLL.shipment_type IN (
4363: 'STANDARD',
4364: 'PLANNED' ,
4365: 'BLANKET')
4366: AND PORL.blanket_po_header_id = BLANKET.po_header_id)
4367: WHERE PORD.requisition_line_id= x_req_line_id_tbl(i)

Line 4381: -- whose autocreated Standard PO/Release are backed by encumbered GBPA

4377:
4378: l_progress := '006' ;
4379:
4380: -- The below sql is to update the prevent encumbrance flag for all the req distributions
4381: -- whose autocreated Standard PO/Release are backed by encumbered GBPA
4382:
4383: -- The prevent encumbrance flag is updated to 'Y' when the main document is reserved
4384: -- and is backed by an encumbered BPA
4385: -- The prevent encumbrance flag to 'N' on all the req distributions

Line 4410: AND pod.distribution_type = c_doc_subtype_STANDARD

4406: po_distributions_all pod
4407: WHERE poda.po_header_id = pol.from_header_id
4408: AND pol.po_line_id = pod.po_line_id
4409: AND pod.req_distribution_id = pord.distribution_id
4410: AND pod.distribution_type = c_doc_subtype_STANDARD
4411: UNION
4412: SELECT 1
4413: FROM po_distributions_all poda,
4414: po_distributions_all pod

Line 4726: -- Start standard API initialization

4722: l_req_line_id_tbl PO_ReqChangeRequestWF_PVT.ReqLineID_tbl_type;
4723:
4724:
4725: BEGIN
4726: -- Start standard API initialization
4727: IF FND_API.to_boolean(p_init_msg_list) THEN
4728: FND_MSG_PUB.initialize;
4729: END IF;
4730:

Line 4971: -- Start standard API initialization

4967: l_req_line_id_tbl PO_ReqChangeRequestWF_PVT.ReqLineID_tbl_type;
4968:
4969:
4970: BEGIN
4971: -- Start standard API initialization
4972: IF FND_API.to_boolean(p_init_msg_list) THEN
4973: FND_MSG_PUB.initialize;
4974: END IF;
4975:

Line 5135: -- Start standard API initialization

5131:
5132:
5133:
5134: BEGIN
5135: -- Start standard API initialization
5136: IF FND_API.to_boolean(p_init_msg_list) THEN
5137: FND_MSG_PUB.initialize;
5138: END IF;
5139:

Line 5321: -- Start standard API initialization

5317: l_head_auth_status VARCHAR2(25);
5318:
5319:
5320: BEGIN
5321: -- Start standard API initialization
5322: IF FND_API.to_boolean(p_init_msg_list) THEN
5323: FND_MSG_PUB.initialize;
5324: END IF;
5325:

Line 5528: AND object_sub_type_code = p_doc_subtype --'STANDARD'

5524: SELECT MAX(sequence_num)
5525: INTO l_sequence_num
5526: FROM PO_ACTION_HISTORY
5527: WHERE object_type_code= p_document_type --'PO'
5528: AND object_sub_type_code = p_doc_subtype --'STANDARD'
5529: AND object_id = p_doc_id;
5530:
5531: IF g_debug_stmt THEN
5532: PO_DEBUG.debug_var(d_module, l_progress, 'l_sequence_num', l_sequence_num);

Line 5665: -- Start standard API initialization

5661: l_return_code VARCHAR2(30);
5662:
5663:
5664: BEGIN
5665: -- Start standard API initialization
5666: IF FND_API.to_boolean(p_init_msg_list) THEN
5667: FND_MSG_PUB.initialize;
5668: END IF;
5669:

Line 5808: -- Start standard API initialization

5804: l_po_return_code VARCHAR2(25);
5805: l_online_report_id NUMBER;
5806:
5807: BEGIN
5808: -- Start standard API initialization
5809: IF FND_API.to_boolean(p_init_msg_list) THEN
5810: FND_MSG_PUB.initialize;
5811: END IF;
5812:

Line 6193: -- Start standard API initialization

6189: d_module CONSTANT VARCHAR2(100) := g_module_prefix|| d_api_name;
6190: l_progress VARCHAR2(3) := '000' ;
6191:
6192: BEGIN
6193: -- Start standard API initialization
6194: IF FND_API.to_boolean(p_init_msg_list) THEN
6195: FND_MSG_PUB.initialize;
6196: END IF;
6197:

Line 6333: -- Start standard API initialization

6329: l_req_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE;
6330:
6331: BEGIN
6332:
6333: -- Start standard API initialization
6334: IF FND_API.to_boolean(p_init_msg_list) THEN
6335: FND_MSG_PUB.initialize;
6336: END IF;
6337:

Line 6487: -- then show a standard message as

6483: PO_DEBUG.debug_var(d_module,l_progress,'x_return_code',x_return_code);
6484: END IF;
6485:
6486: -- Check if the process_entity flag is "N' for any of the entities,
6487: -- then show a standard message as
6488: -- Cancel action has failed for some douments,
6489: -- Please run the error report to see the errors.
6490:
6491: EXCEPTION

Line 6620: -- Start standard API initialization

6616: IF NOT PO_Document_Cancel_PVT.is_document_cto_order
6617: (p_doc_type => p_doc_type,
6618: p_doc_id => p_doc_id)
6619: THEN
6620: -- Start standard API initialization
6621: IF FND_API.to_boolean(p_init_msg_list) THEN
6622: FND_MSG_PUB.initialize;
6623: END IF;
6624: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,

Line 6630: -- End standard API initialization

6626: THEN
6627: RAISE FND_API.g_exc_unexpected_error;
6628: END IF;
6629: x_return_status := FND_API.g_ret_sts_success;
6630: -- End standard API initialization
6631:
6632: IF (g_fnd_debug = 'Y') THEN
6633: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
6634: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

Line 6797: -- Start standard API initialization

6793:
6794:
6795:
6796: BEGIN
6797: -- Start standard API initialization
6798: IF FND_API.to_boolean(p_init_msg_list) THEN
6799: FND_MSG_PUB.initialize;
6800: END IF;
6801:

Line 6913: AND poll.shipment_type IN('STANDARD','PLANNED'))

6909: pol.quantity,
6910: (SELECT SUM(NVL(poll.quantity,0) -NVL(poll.quantity_cancelled,0))
6911: FROM po_line_locations POLL
6912: WHERE poll.po_line_id = pol.po_line_id
6913: AND poll.shipment_type IN('STANDARD','PLANNED'))
6914: ),
6915: pol.amount =
6916: DECODE(pol.amount,
6917: NULL,

Line 6928: AND poll.shipment_type IN ('STANDARD','PLANNED')) )

6924: )
6925: )
6926: FROM po_line_locations POLL
6927: WHERE poll.po_line_id = pol.po_line_id
6928: AND poll.shipment_type IN ('STANDARD','PLANNED')) )
6929:
6930: WHERE pol.po_line_id IN(SELECT DISTINCT po_line_id
6931: FROM po_line_locations
6932: WHERE line_location_id=l_line_loc_tbl(i)

Line 6933: AND shipment_type IN ('STANDARD','PLANNED'));

6929:
6930: WHERE pol.po_line_id IN(SELECT DISTINCT po_line_id
6931: FROM po_line_locations
6932: WHERE line_location_id=l_line_loc_tbl(i)
6933: AND shipment_type IN ('STANDARD','PLANNED'));
6934:
6935: IF g_debug_stmt THEN
6936: PO_DEBUG.debug_var(d_module, l_progress, 'Rows Updated in PO Lines table', SQL%ROWCOUNT);
6937: END IF;