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_PVT dependencies on PO_CORE_S

Line 602: PO_CORE_S.get_document_ids(

598: END IF;
599: END IF;
600:
601:
602: PO_CORE_S.get_document_ids(
603: p_doc_type => p_document_type
604: , p_doc_level => p_document_level
605: , p_doc_level_id_tbl => po_tbl_number( p_document_level_id )
606: , x_doc_id_tbl => l_id_tbl

Line 1881: , 'RATE' , PO_CORE_S.get_translated_text

1877: NULL, --
1878: NULL, --
1879: p_sequence+l_rowCount(i),
1880: decode ( l_value_basis_tbl(i) --
1881: , 'RATE' , PO_CORE_S.get_translated_text
1882: ( 'PO_SUB_REQ_LINE_NE_DIST_AMT'
1883: , 'LINE_NUM', l_line_num(i)
1884: , 'LINE_AMT', l_line_amt_tbl(i)
1885: , 'DIST_AMT', l_dist_amt_tbl(i)

Line 1887: , 'FIXED PRICE' , PO_CORE_S.get_translated_text

1883: , 'LINE_NUM', l_line_num(i)
1884: , 'LINE_AMT', l_line_amt_tbl(i)
1885: , 'DIST_AMT', l_dist_amt_tbl(i)
1886: )
1887: , 'FIXED PRICE' , PO_CORE_S.get_translated_text
1888: ( 'PO_SUB_REQ_LINE_NE_DIST_AMT'
1889: , 'LINE_NUM', l_line_num(i)
1890: , 'LINE_AMT', l_line_amt_tbl(i)
1891: , 'DIST_AMT', l_dist_amt_tbl(i)

Line 1893: , PO_CORE_S.get_translated_text

1889: , 'LINE_NUM', l_line_num(i)
1890: , 'LINE_AMT', l_line_amt_tbl(i)
1891: , 'DIST_AMT', l_dist_amt_tbl(i)
1892: )
1893: , PO_CORE_S.get_translated_text
1894: ( 'PO_SUB_REQ_LINE_NE_DIST_QTY'
1895: , 'LINE_NUM', l_line_num(i)
1896: , 'LINE_QTY', l_line_qty_tbl(i)
1897: , 'DIST_QTY', l_dist_qty_tbl(i)

Line 2017: IF ( PO_CORE_S.is_encumbrance_on(

2013: -- PO_SUB_REQ_INVALID_GL_DATE
2014:
2015: --
2016:
2017: IF ( PO_CORE_S.is_encumbrance_on(
2018: p_doc_type => g_document_type_REQUISITION
2019: , p_org_id => NULL
2020: )
2021: )

Line 2602: substr(PO_CORE_S.get_translated_text

2598: 0,
2599: 0,
2600: 0, --
2601: p_sequence+l_rowCount(i),
2602: substr(PO_CORE_S.get_translated_text
2603: ( 'PO_SUB_REL_INVALID_SHIP_TO',
2604: 'LINE_NUM',
2605: l_line_num(i),
2606: 'SHIP_TO_LOC',

Line 2657: , 'FIXED PRICE' , PO_CORE_S.get_translated_text

2653: PLL.shipment_num,
2654: 0,
2655: p_sequence + ROWNUM,
2656: decode ( POL.order_type_lookup_code --
2657: , 'FIXED PRICE' , PO_CORE_S.get_translated_text
2658: ( 'PO_SUB_REL_PRICE_GT_LIMIT'
2659: , 'SHIP_NUM' , PLL.shipment_num
2660: , 'SHIP_PRICE' , nvl( PLL.price_override,PLL.amount)
2661: , 'LINE_PRICE' , nvl ( POL.not_to_exceed_price

Line 2664: , PO_CORE_S.get_translated_text

2660: , 'SHIP_PRICE' , nvl( PLL.price_override,PLL.amount)
2661: , 'LINE_PRICE' , nvl ( POL.not_to_exceed_price
2662: , PLL.price_override )
2663: )
2664: , PO_CORE_S.get_translated_text
2665: ( 'PO_SUB_REL_AMT_GT_LIMIT'
2666: , 'SHIP_NUM' , PLL.shipment_num
2667: , 'SHIP_AMT' , PLL.amount
2668: , 'LINE_AMT' , nvl ( POL.not_to_exceed_price

Line 2776: , NULL , PO_CORE_S.get_translated_text

2772: l_shipment_num(i),
2773: NULL, --
2774: p_sequence+l_rowCount(i),
2775: decode ( l_ship_qty_tbl(i) --
2776: , NULL , PO_CORE_S.get_translated_text
2777: ( 'PO_SUB_REL_SHIP_NE_DIST_AMT'
2778: , 'SHIP_NUM', l_shipment_num(i)
2779: , 'SHIP_AMT', l_ship_amt_tbl(i)
2780: , 'DIST_AMT', l_dist_amt_tbl(i)

Line 2782: , PO_CORE_S.get_translated_text

2778: , 'SHIP_NUM', l_shipment_num(i)
2779: , 'SHIP_AMT', l_ship_amt_tbl(i)
2780: , 'DIST_AMT', l_dist_amt_tbl(i)
2781: )
2782: , PO_CORE_S.get_translated_text
2783: ( 'PO_SUB_REL_SHIP_NE_DIST_QTY'
2784: , 'SHIP_NUM', l_shipment_num(i)
2785: , 'SHIP_QTY', l_ship_qty_tbl(i)
2786: , 'DIST_QTY', l_dist_qty_tbl(i)

Line 3169: IF ( PO_CORE_S.is_encumbrance_on(

3165: -- PO_SUB_REL_INVALID_GL_DATE
3166:
3167: --
3168:
3169: IF ( PO_CORE_S.is_encumbrance_on(
3170: p_doc_type => g_document_type_RELEASE
3171: , p_org_id => NULL
3172: )
3173: )

Line 5117: substr(PO_CORE_S.get_translated_text

5113: 0,
5114: 0,
5115: 0,
5116: p_sequence + 1,
5117: substr(PO_CORE_S.get_translated_text
5118: ( 'PO_SUB_INVALID_SHIP_TO_LOC',
5119: 'SHIP_TO_LOC',
5120: l_invalid_location),1,240),
5121: 'PO_SUB_INVALID_SHIP_TO_LOC'

Line 5208: substr(PO_CORE_S.get_translated_text('PO_SUB_INVALID_BILL_TO_LOC','BILL_TO_LOC',l_invalid_location),1,240),

5204: 0,
5205: 0,
5206: 0,
5207: p_sequence + 1,
5208: substr(PO_CORE_S.get_translated_text('PO_SUB_INVALID_BILL_TO_LOC','BILL_TO_LOC',l_invalid_location),1,240),
5209: 'PO_SUB_INVALID_BILL_TO_LOC'
5210: );
5211: p_sequence := p_sequence + 1;
5212: EXCEPTION

Line 6132: IF ( PO_CORE_S.is_encumbrance_on(

6128: -- PO_SUB_PO_INVALID_GL_DATE
6129:
6130: --
6131:
6132: IF ( PO_CORE_S.is_encumbrance_on(
6133: p_doc_type => g_document_type_PO
6134: , p_org_id => NULL
6135: )
6136: )

Line 6862: PO_CORE_S.get_translated_text

6858: l_line_num(i),
6859: l_shipment_num(i),
6860: NULL, --
6861: p_sequence+l_rowCount(i),
6862: PO_CORE_S.get_translated_text
6863: ( 'PO_SUB_SHIPTO_LOC_INVALID'
6864: , 'LINE_NUM', l_line_num(i)
6865: , 'SHIPMENT_NUM', l_shipment_num(i)
6866: , 'SHIP_TO_LOC', l_ship_to_location_tbl(i)

Line 7104: po_core_s.GET_TRANSLATED_TEXT('PO_INVALID_OKE_CONTRACT_VER_ID',

7100: pol.line_num,
7101: 0,
7102: 0,
7103: p_sequence + ROWNUM,
7104: po_core_s.GET_TRANSLATED_TEXT('PO_INVALID_OKE_CONTRACT_VER_ID',
7105: 'LINE_NUM',pol.line_num),
7106: 'PO_INVALID_OKE_CONTRACT_VER_ID'
7107: FROM po_lines_gt pol
7108: WHERE pol.oke_contract_version_id IS NOT NULL

Line 7144: po_core_s.GET_TRANSLATED_TEXT('PO_INVALID_OKE_CONTRACT_LNE_ID',

7140: pol.line_num,
7141: pos.shipment_num,
7142: pod.distribution_num,
7143: p_sequence + ROWNUM,
7144: po_core_s.GET_TRANSLATED_TEXT('PO_INVALID_OKE_CONTRACT_LNE_ID',
7145: 'LINE_NUM',pol.line_num,
7146: 'SHIP_NUM',pos.shipment_num,
7147: 'DIST_NUM',pod.distribution_num),
7148: 'PO_INVALID_OKE_CONTRACT_LNE_ID'

Line 7192: po_core_s.GET_TRANSLATED_TEXT('PO_INVALID_OKE_CONTRACT_DLV_ID',

7188: pol.line_num,
7189: pos.shipment_num,
7190: pod.distribution_num,
7191: p_sequence + ROWNUM,
7192: po_core_s.GET_TRANSLATED_TEXT('PO_INVALID_OKE_CONTRACT_DLV_ID',
7193: 'LINE_NUM',pol.line_num,
7194: 'SHIP_NUM',pos.shipment_num,
7195: 'DIST_NUM',pod.distribution_num),
7196: 'PO_INVALID_OKE_CONTRACT_DLV_ID'

Line 7744: IF ( PO_CORE_S.is_encumbrance_on(

7740:
7741: -- Check 4: The PA GL date should be within an open purchasing period
7742: -- PO_SUB_PA_INVALID_GL_DATE ?
7743:
7744: IF ( PO_CORE_S.is_encumbrance_on(
7745: p_doc_type => g_document_type_PA
7746: , p_org_id => NULL
7747: )
7748: )

Line 9207: , 'FIXED PRICE' , PO_CORE_S.get_translated_text

9203: 0,
9204: 0,
9205: p_sequence + ROWNUM,
9206: decode ( POL1.order_type_lookup_code --
9207: , 'FIXED PRICE' , PO_CORE_S.get_translated_text
9208: ( 'PO_SUB_PO_LINE_GT_GA_AMT_TOL'
9209: , 'LINE_NUM', POL1.line_num
9210: , 'LINE_AMT', POL1.amount
9211: , 'AMT_TOL' , nvl ( POL2.not_to_exceed_price

Line 9214: , PO_CORE_S.get_translated_text

9210: , 'LINE_AMT', POL1.amount
9211: , 'AMT_TOL' , nvl ( POL2.not_to_exceed_price
9212: , POL1.amount )
9213: )
9214: , PO_CORE_S.get_translated_text
9215: ( 'PO_SUB_PO_LINE_GT_GA_PRICE_TOL'
9216: , 'LINE_NUM' , POL1.line_num
9217: , 'LINE_PRICE', POL1.unit_price
9218: , 'PRICE_TOL' , nvl ( POL2.not_to_exceed_price

Line 10146: PO_CORE_S.get_document_ids(

10142: DELETE FROM po_req_distributions_gt;
10143: DELETE FROM po_online_report_text_gt;
10144:
10145:
10146: PO_CORE_S.get_document_ids(
10147: p_doc_type => p_doc_type
10148: , p_doc_level => p_doc_level
10149: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )
10150: , x_doc_id_tbl => l_id_tbl

Line 11221: PO_CORE_S.get_line_ids(

11217: END IF;
11218:
11219: l_progress := '010';
11220:
11221: PO_CORE_S.get_line_ids(
11222: p_doc_type => p_doc_type
11223: , p_doc_level => p_doc_level
11224: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )
11225: , x_line_id_tbl => l_line_id_tbl

Line 12742: l_procedure_id := PO_CORE_S.get_session_gt_nextval;

12738:
12739: -- The original approach was to do a fake UPDATE on DUAL table. However, this
12740: -- is causing locking issue. Therefore, BULK INSERT is used instead of
12741: -- BULK UPDATE
12742: l_procedure_id := PO_CORE_S.get_session_gt_nextval;
12743:
12744: FORALL i IN 1..p_count
12745: INSERT INTO PO_SESSION_GT
12746: ( key,

Line 12968: l_procedure_id := PO_CORE_S.get_session_gt_nextval;

12964:
12965: -- The original approach was to do a fake UPDATE on DUAL table. However, this
12966: -- is causing locking issue. Therefore, BULK INSERT is used instead of
12967: -- BULK UPDATE
12968: l_procedure_id := PO_CORE_S.get_session_gt_nextval;
12969:
12970: FORALL i IN 1..p_count
12971: INSERT INTO PO_SESSION_GT
12972: ( key,

Line 13141: l_procedure_id := PO_CORE_S.get_session_gt_nextval;

13137: -- SQL What: Checks if current PO Header/Line/Shipment is in unreservable status
13138: -- The original approach was to do a fake UPDATE on DUAL table. However, this
13139: -- is causing locking issue. Therefore, BULK INSERT is used instead of
13140: -- BULK UPDATE
13141: l_procedure_id := PO_CORE_S.get_session_gt_nextval;
13142:
13143: FORALL i IN 1..p_count
13144: INSERT INTO PO_SESSION_GT
13145: ( key,

Line 13715: , NULL , PO_CORE_S.get_translated_text

13711: , POLL.shipment_num
13712: , 0
13713: , p_sequence + ROWNUM
13714: , decode ( POL.quantity --
13715: , NULL , PO_CORE_S.get_translated_text
13716: ( 'PO_SUB_SHIP_BILL_GT_ORD_AMT'
13717: , 'LINE_NUM' , POL.line_num
13718: , 'SHIP_NUM' , POLL.shipment_num
13719: , 'AMT_BILLED' , nvl(POLL.amount_billed, 0)

Line 13722: , PO_CORE_S.get_translated_text

13718: , 'SHIP_NUM' , POLL.shipment_num
13719: , 'AMT_BILLED' , nvl(POLL.amount_billed, 0)
13720: , 'AMT_ORDERED' , nvl(POLL.amount, 0)
13721: )
13722: , PO_CORE_S.get_translated_text
13723: ( 'PO_SUB_SHIP_BILL_GT_ORD_QTY'
13724: , 'LINE_NUM' , POL.line_num
13725: , 'SHIP_NUM' , POLL.shipment_num
13726: , 'QTY_BILLED' , nvl(POLL.quantity_billed, 0)

Line 13801: , NULL , PO_CORE_S.get_translated_text

13797: , POLL.shipment_num
13798: , POD.distribution_num
13799: , p_sequence + ROWNUM
13800: , decode ( POL.quantity --
13801: , NULL , PO_CORE_S.get_translated_text
13802: ( 'PO_SUB_DIST_BILL_GT_ORD_AMT'
13803: , 'LINE_NUM' , POL.line_num
13804: , 'SHIP_NUM' , POLL.shipment_num
13805: , 'DIST_NUM' , POD.distribution_num

Line 13809: , PO_CORE_S.get_translated_text

13805: , 'DIST_NUM' , POD.distribution_num
13806: , 'AMT_BILLED' , nvl(POD.amount_billed, 0)
13807: , 'AMT_ORDERED' , nvl(POD.amount_ordered, 0)
13808: )
13809: , PO_CORE_S.get_translated_text
13810: ( 'PO_SUB_DIST_BILL_GT_ORD_QTY'
13811: , 'LINE_NUM' , POL.line_num
13812: , 'SHIP_NUM' , POLL.shipment_num
13813: , 'DIST_NUM' , POD.distribution_num

Line 13889: , NULL , PO_CORE_S.get_translated_text

13885: , POLL.shipment_num
13886: , POD.distribution_num
13887: , p_sequence + ROWNUM
13888: , decode ( POL.quantity --
13889: , NULL , PO_CORE_S.get_translated_text
13890: ( 'PO_SUB_DIST_DLVR_GT_ORD_AMT'
13891: , 'LINE_NUM' , POL.line_num
13892: , 'SHIP_NUM' , POLL.shipment_num
13893: , 'DIST_NUM' , POD.distribution_num

Line 13897: , PO_CORE_S.get_translated_text

13893: , 'DIST_NUM' , POD.distribution_num
13894: , 'AMT_DELIVERED' , nvl(POD.amount_delivered, 0)
13895: , 'AMT_ORDERED' , nvl(POD.amount_ordered, 0)
13896: )
13897: , PO_CORE_S.get_translated_text
13898: ( 'PO_SUB_DIST_DLVR_GT_ORD_QTY'
13899: , 'LINE_NUM' , POL.line_num
13900: , 'SHIP_NUM' , POLL.shipment_num
13901: , 'DIST_NUM' , POD.distribution_num

Line 13949: RAISE PO_CORE_S.g_early_return_exc;

13945:
13946: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
13947: --d_msg := 'check_unvalidated_invoices not successful';
13948: l_progress := 110;
13949: RAISE PO_CORE_S.g_early_return_exc;
13950: END IF;
13951:
13952:
13953: l_progress := '260';

Line 14033: PO_CORE_S.get_line_location_ids(

14029: END IF;
14030:
14031: l_progress := '010';
14032:
14033: PO_CORE_S.get_line_location_ids(
14034: p_doc_type => p_doc_type
14035: , p_doc_level => p_doc_level
14036: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )
14037: , x_line_location_id_tbl => l_line_location_id_tbl

Line 14422: PO_CORE_S.get_distribution_ids(

14418: IF g_debug_stmt THEN
14419: PO_DEBUG.debug_stmt(l_log_head,l_progress,'not requisition');
14420: END IF;
14421:
14422: PO_CORE_S.get_distribution_ids(
14423: p_doc_type => p_doc_type
14424: , p_doc_level => p_doc_level
14425: , p_doc_level_id_tbl => po_tbl_number( p_doc_level_id )
14426: , x_distribution_id_tbl => l_dist_id_tbl

Line 14742: RAISE PO_CORE_S.g_INVALID_CALL_EXC;

14738: THEN
14739: l_msg_name := 'PO_PDOI_INVALID_GL_ENC_PER';
14740: ELSE
14741: l_progress := '020';
14742: RAISE PO_CORE_S.g_INVALID_CALL_EXC;
14743: END IF;
14744:
14745: l_progress := '030';
14746: IF g_debug_stmt THEN

Line 15362: RAISE PO_CORE_S.g_early_return_exc;

15358:
15359: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15360: d_msg := 'check_rcv_trans_interface not successful';
15361: d_progress := 30;
15362: RAISE PO_CORE_S.g_early_return_exc;
15363: END IF;
15364:
15365: d_progress := 40;
15366:

Line 15379: RAISE PO_CORE_S.g_early_return_exc;

15375:
15376: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15377: d_msg := 'check_asn_not_fully_received not successful';
15378: d_progress := 50;
15379: RAISE PO_CORE_S.g_early_return_exc;
15380: END IF;
15381:
15382: d_progress := 60;
15383:

Line 15396: RAISE PO_CORE_S.g_early_return_exc;

15392:
15393: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15394: d_msg := 'check_qty_rcv_but_not_deliv not successful';
15395: d_progress := 70;
15396: RAISE PO_CORE_S.g_early_return_exc;
15397: END IF;
15398:
15399: d_progress := 80;
15400:

Line 15413: RAISE PO_CORE_S.g_early_return_exc;

15409:
15410: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15411: d_msg := 'check_amt_rcv_but_not_deliv not successful';
15412: d_progress := 90;
15413: RAISE PO_CORE_S.g_early_return_exc;
15414: END IF;
15415:
15416: d_progress := 100;
15417:

Line 15433: RAISE PO_CORE_S.g_early_return_exc;

15429:
15430: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15431: d_msg := 'check_invalid_acct_flex not successful';
15432: d_progress := 110;
15433: RAISE PO_CORE_S.g_early_return_exc;
15434: END IF;
15435:
15436: -- Bug#5462677
15437: d_progress := 100;

Line 15457: RAISE PO_CORE_S.g_early_return_exc;

15453:
15454: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15455: d_msg := 'check_unvalidated_invoices not successful';
15456: d_progress := 110;
15457: RAISE PO_CORE_S.g_early_return_exc;
15458: END IF;
15459:
15460: ELSIF ((p_document_type = g_document_type_PO) AND (p_document_subtype = 'PLANNED'))
15461: THEN

Line 15480: RAISE PO_CORE_S.g_early_return_exc;

15476:
15477: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15478: d_msg := 'check_invalid_acct_flex not successful';
15479: d_progress := 210;
15480: RAISE PO_CORE_S.g_early_return_exc;
15481: END IF;
15482:
15483: d_progress := 220;
15484:

Line 15496: RAISE PO_CORE_S.g_early_return_exc;

15492:
15493: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15494: d_msg := 'check_ppo_has_open_release not successful';
15495: d_progress := 230;
15496: RAISE PO_CORE_S.g_early_return_exc;
15497: END IF;
15498:
15499: ELSIF ((p_document_type = g_document_type_PA) AND (p_document_subtype = 'BLANKET'))
15500: THEN

Line 15515: RAISE PO_CORE_S.g_early_return_exc;

15511:
15512: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15513: d_msg := 'check_bpa_has_open_release not successful';
15514: d_progress := 310;
15515: RAISE PO_CORE_S.g_early_return_exc;
15516: END IF;
15517:
15518: d_progress := 320;
15519:

Line 15531: RAISE PO_CORE_S.g_early_return_exc;

15527:
15528: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15529: d_msg := 'check_bpa_has_open_stdref not successful';
15530: d_progress := 330;
15531: RAISE PO_CORE_S.g_early_return_exc;
15532: END IF;
15533:
15534: ELSIF ((p_document_type = g_document_type_PA) AND (p_document_subtype = 'CONTRACT'))
15535: THEN

Line 15550: RAISE PO_CORE_S.g_early_return_exc;

15546:
15547: IF (l_ret_sts <> FND_API.G_RET_STS_SUCCESS) THEN
15548: d_msg := 'check_cpa_has_open_stdref not successful';
15549: d_progress := 410;
15550: RAISE PO_CORE_S.g_early_return_exc;
15551: END IF;
15552:
15553: END IF; -- p_document_type = ...
15554:

Line 15558: WHEN PO_CORE_S.g_early_return_exc THEN

15554:
15555: l_ret_sts := FND_API.G_RET_STS_SUCCESS;
15556:
15557: EXCEPTION
15558: WHEN PO_CORE_S.g_early_return_exc THEN
15559: IF (PO_LOG.d_exc) THEN
15560: PO_LOG.exc(d_module, d_progress, d_msg);
15561: END IF;
15562: l_ret_sts := FND_API.G_RET_STS_UNEXP_ERROR;

Line 15867: RAISE PO_CORE_S.g_early_return_exc;

15863:
15864: d_progress := 70;
15865: d_msg := 'Bad document level';
15866: l_ret_sts := FND_API.G_RET_STS_UNEXP_ERROR;
15867: RAISE PO_CORE_S.g_early_return_exc;
15868:
15869: END IF; -- if p_document_level = ...
15870:
15871: p_sequence := p_sequence + SQL%ROWCOUNT;

Line 15875: WHEN PO_CORE_S.g_early_return_exc THEN

15871: p_sequence := p_sequence + SQL%ROWCOUNT;
15872: l_ret_sts := FND_API.G_RET_STS_SUCCESS;
15873:
15874: EXCEPTION
15875: WHEN PO_CORE_S.g_early_return_exc THEN
15876: IF (PO_LOG.d_exc) THEN
15877: PO_LOG.exc(d_module, d_progress, d_msg);
15878: END IF;
15879: END;

Line 16075: || PO_CORE_S.get_translated_text('PO_CAN_POLL_REC_NOT_DEL'

16071: , p_sequence + ROWNUM
16072: , substr(
16073: DECODE(p_document_type, g_document_type_RELEASE,
16074: g_shipmsg || g_delim || poll.shipment_num || g_delim
16075: || PO_CORE_S.get_translated_text('PO_CAN_POLL_REC_NOT_DEL'
16076: , 'QTY2', NVL(poll.quantity_received, 0)
16077: , 'QTY1', sum(NVL(pod.quantity_delivered, 0))
16078: ),
16079: g_linemsg || g_delim || pol.line_num || g_delim || g_shipmsg || g_delim

Line 16081: || PO_CORE_S.get_translated_text('PO_CAN_POLL_REC_NOT_DEL'

16077: , 'QTY1', sum(NVL(pod.quantity_delivered, 0))
16078: ),
16079: g_linemsg || g_delim || pol.line_num || g_delim || g_shipmsg || g_delim
16080: || poll.shipment_num || g_delim
16081: || PO_CORE_S.get_translated_text('PO_CAN_POLL_REC_NOT_DEL'
16082: , 'QTY2', NVL(poll.quantity_received, 0)
16083: , 'QTY1', sum(NVL(pod.quantity_delivered, 0))
16084: )
16085: ), 1, 240)

Line 16198: || PO_CORE_S.get_translated_text('PO_CAN_POLL_AMT_REC_NOT_DEL'

16194: , p_sequence + ROWNUM
16195: , substr(
16196: DECODE(p_document_type, g_document_type_RELEASE,
16197: g_shipmsg || g_delim || poll.shipment_num || g_delim
16198: || PO_CORE_S.get_translated_text('PO_CAN_POLL_AMT_REC_NOT_DEL'
16199: , 'QTY2', NVL(poll.amount_received, 0)
16200: , 'QTY1', sum(NVL(pod.amount_delivered, 0))
16201: ),
16202: g_linemsg || g_delim || pol.line_num || g_delim || g_shipmsg || g_delim

Line 16204: || PO_CORE_S.get_translated_text('PO_CAN_POLL_AMT_REC_NOT_DEL'

16200: , 'QTY1', sum(NVL(pod.amount_delivered, 0))
16201: ),
16202: g_linemsg || g_delim || pol.line_num || g_delim || g_shipmsg || g_delim
16203: || poll.shipment_num || g_delim
16204: || PO_CORE_S.get_translated_text('PO_CAN_POLL_AMT_REC_NOT_DEL'
16205: , 'QTY2', NVL(poll.amount_received, 0)
16206: , 'QTY1', sum(NVL(pod.amount_delivered, 0))
16207: )
16208: ), 1, 240)

Line 16916: , NULL , PO_CORE_S.get_translated_text

16912: NULL, --
16913: NULL, --
16914: x_sequence+ l_rowCount(i),
16915: decode ( l_line_qty_tbl(i) --
16916: , NULL , PO_CORE_S.get_translated_text
16917: ( 'PO_SUB_PO_LINE_NE_SHIP_AMT'
16918: , 'LINE_NUM', l_line_num(i)
16919: , 'LINE_AMT', l_line_amt_tbl(i)
16920: , 'SHIP_AMT', l_lineloc_amt_tbl(i)

Line 16922: , PO_CORE_S.get_translated_text

16918: , 'LINE_NUM', l_line_num(i)
16919: , 'LINE_AMT', l_line_amt_tbl(i)
16920: , 'SHIP_AMT', l_lineloc_amt_tbl(i)
16921: )
16922: , PO_CORE_S.get_translated_text
16923: ( 'PO_SUB_PO_LINE_NE_SHIP_QTY'
16924: , 'LINE_NUM', l_line_num(i)
16925: , 'LINE_QTY', l_line_qty_tbl(i)
16926: , 'SHIP_QTY', l_lineloc_qty_tbl(i)

Line 16953: l_is_financing_flag := PO_CORE_S.boolean_to_flag(

16949: || l_progress,'PO Pay Item Qty/Amt Rollup');
16950: END IF;
16951: END IF;
16952:
16953: l_is_financing_flag := PO_CORE_S.boolean_to_flag(
16954: PO_COMPLEX_WORK_PVT.is_financing_po(p_document_id));
16955:
16956: l_progress := '022';
16957:

Line 16964: PO_CORE_S2.get_currency_info(

16960: INTO l_currency_code
16961: FROM po_headers_all poh
16962: WHERE poh.po_header_id = p_document_id;
16963:
16964: PO_CORE_S2.get_currency_info(
16965: x_currency_code => l_currency_code
16966: , x_min_unit => l_min_acct_unit
16967: , x_precision => l_precision);
16968:

Line 17083: PO_CORE_S.get_translated_text

17079: NULL,
17080: x_sequence+ l_rowCount(i),
17081: decode ( l_fin_adv_amount(i),
17082: NULL,
17083: PO_CORE_S.get_translated_text
17084: ( 'PO_SUB_PAY_ITEM_NE_LINE_AMT'
17085: , 'LINE_NUM', l_line_num(i)
17086: , 'PAY_ITEM_AMT', l_lineloc_amt_tbl(i)
17087: , 'LINE_AMT', l_line_amt_tbl(i)

Line 17089: PO_CORE_S.get_translated_text

17085: , 'LINE_NUM', l_line_num(i)
17086: , 'PAY_ITEM_AMT', l_lineloc_amt_tbl(i)
17087: , 'LINE_AMT', l_line_amt_tbl(i)
17088: ),
17089: PO_CORE_S.get_translated_text
17090: ( 'PO_SUB_PRE_PAY_GE_LINE_AMT'
17091: , 'LINE_NUM', l_line_num(i)
17092: , 'PAY_ITEM_AMT', (l_lineloc_amt_tbl(i)-l_fin_adv_amount(i) )
17093: , 'ADV_AMT', l_fin_adv_amount(i)

Line 17189: , NULL , PO_CORE_S.get_translated_text

17185: l_shipment_num(i),
17186: NULL, --
17187: x_sequence+l_rowCount(i),
17188: decode ( l_lineloc_qty_tbl(i)
17189: , NULL , PO_CORE_S.get_translated_text
17190: ( 'PO_SUB_PO_SHIP_NE_DIST_AMT'
17191: , 'LINE_NUM', l_line_num(i)
17192: , 'SHIP_NUM', l_shipment_num(i)
17193: , 'SHIP_AMT', l_lineloc_amt_tbl(i)

Line 17196: , PO_CORE_S.get_translated_text

17192: , 'SHIP_NUM', l_shipment_num(i)
17193: , 'SHIP_AMT', l_lineloc_amt_tbl(i)
17194: , 'DIST_AMT', l_dist_amt_tbl(i)
17195: )
17196: , PO_CORE_S.get_translated_text
17197: ( 'PO_SUB_PO_SHIP_NE_DIST_QTY'
17198: , 'LINE_NUM', l_line_num(i)
17199: , 'SHIP_NUM', l_shipment_num(i)
17200: , 'SHIP_QTY', l_lineloc_qty_tbl(i)

Line 17279: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN

17275: l_is_price_updateable := FALSE;
17276:
17277: d_progress := 30;
17278:
17279: IF (p_add_reasons_to_msg_list = PO_CORE_S.G_PARAMETER_YES) THEN
17280: d_progress := 40;
17281: -- : FILL IN THE MESSAGES
17282: FND_MESSAGE.set_name('PO','CWPOTODOMESSAGE');
17283: FND_MSG_PUB.add;