DBA Data[Home] [Help]

APPS.PO_CONTROL_ACTION_VALIDATIONS dependencies on PO_CORE_S

Line 190: PO_CORE_S.get_translated_text

186: POL.LINE_NUM,
187: poll.SHIPMENT_NUM,
188: 0,
189: p_sequence + ROWNUM,
190: PO_CORE_S.get_translated_text
191: ('PO_CAN_SHIP_REC_GRT_ORD',
192: 'LINE_SHIP_DIST_NUM', l_line_token||pol.LINE_NUM||','||l_ship_token||poll.SHIPMENT_NUM,
193: 'AMT_QTY_TOKEN', DECODE(poll.matching_basis, 'AMOUNT',l_amt_token,l_qty_token),
194: 'QTY1', DECODE(poll.matching_basis, 'AMOUNT', Nvl(poll.amount_received, 0), Nvl(poll.quantity_received, 0)),

Line 352: PO_CORE_S.get_translated_text(

348: POL.LINE_NUM,
349: 0,
350: 0,
351: p_sequence + ROWNUM,
352: PO_CORE_S.get_translated_text(
353: 'PO_CAN_PRICE_LIMIT_LT_PRICE',
354: 'LINE_SHIP_DIST_NUM',
355: l_line_token||pol.LINE_NUM,
356: 'AMT_PRICE_TOKEN',

Line 511: PO_CORE_S.get_translated_text(

507: POL.LINE_NUM,
508: 0,
509: 0,
510: p_sequence + ROWNUM,
511: PO_CORE_S.get_translated_text(
512: 'PO_CAN_PO_LINE_NE_SHIP_AMT',
513: 'LINE_SHIP_DIST_NUM',
514: l_line_token||pol.LINE_NUM,
515: 'AMT_QTY_TOKEN',

Line 717: PO_CORE_S.get_translated_text(

713: POL.LINE_NUM,
714: poll.SHIPMENT_NUM,
715: 0,
716: p_sequence + ROWNUM,
717: PO_CORE_S.get_translated_text(
718: 'PO_CAN_SHIP_PRICE_NE_LINE',
719: 'LINE_SHIP_DIST_NUM',
720: l_line_token||pol.LINE_NUM||','||l_ship_token||poll.SHIPMENT_NUM,
721: 'PRICE1',

Line 886: PO_CORE_S.get_translated_text(

882: POL.LINE_NUM,
883: poll.SHIPMENT_NUM,
884: 0,
885: p_sequence + ROWNUM,
886: PO_CORE_S.get_translated_text(
887: 'PO_CAN_PO_SHIP_NE_DIST_AMT',
888: 'LINE_SHIP_DIST_NUM',
889: l_line_token||pol.LINE_NUM||','||l_ship_token||poll.SHIPMENT_NUM,
890: 'AMT_QTY_TOKEN',

Line 1076: PO_CORE_S.get_translated_text(

1072: POL.LINE_NUM,
1073: poll.SHIPMENT_NUM,
1074: 0,
1075: p_sequence + ROWNUM,
1076: PO_CORE_S.get_translated_text(
1077: 'PO_CAN_SHIP_INV_MATCH_NE_R',
1078: 'LINE_SHIP_DIST_NUM',
1079: l_line_token||pol.LINE_NUM||','||l_ship_token||poll.SHIPMENT_NUM,
1080: 'DOC_NUM',

Line 1244: PO_CORE_S.get_translated_text(

1240: POL.LINE_NUM,
1241: poll.SHIPMENT_NUM,
1242: pod.distribution_num,
1243: p_sequence + ROWNUM,
1244: PO_CORE_S.get_translated_text(
1245: 'PO_CAN_DIST_DEST_TYPE_NE_I',
1246: 'LINE_SHIP_DIST_NUM',
1247: l_line_token||pol.LINE_NUM||','||l_ship_token||poll.SHIPMENT_NUM||','||l_dist_token||pod.distribution_num,
1248: 'DOC_NUM',

Line 1418: PO_CORE_S.get_translated_text

1414: POL.LINE_NUM,
1415: poll.SHIPMENT_NUM,
1416: pod.DISTRIBUTION_NUM,
1417: p_sequence + ROWNUM,
1418: PO_CORE_S.get_translated_text
1419: ('PO_CAN_DIST_DEL_GRT_ORD'
1420: , 'LINE_SHIP_DIST_NUM', l_line_token||pol.LINE_NUM||','||l_ship_token||poll.SHIPMENT_NUM||','||l_dist_token||pod.DISTRIBUTION_NUM
1421: , 'AMT_QTY_TOKEN', DECODE(poll.matching_basis, 'AMOUNT',l_amt_token,l_qty_token)
1422: , 'QTY1', DECODE(poll.matching_basis, 'AMOUNT',Round(Nvl(pod.amount_delivered, 0), 5), Round(Nvl(pod.quantity_delivered, 0), 5))

Line 1596: PO_CORE_S.get_translated_text

1592: POL.LINE_NUM,
1593: poll.SHIPMENT_NUM,
1594: pod.DISTRIBUTION_NUM,
1595: p_sequence + ROWNUM,
1596: PO_CORE_S.get_translated_text
1597: ('PO_CAN_DIST_BILL_GRT_ORD'
1598: , 'LINE_SHIP_DIST_NUM', l_line_token||pol.LINE_NUM||','||l_ship_token||poll.SHIPMENT_NUM||','||l_dist_token||pod.DISTRIBUTION_NUM
1599: , 'AMT_QTY_TOKEN', DECODE(poll.matching_basis, 'AMOUNT',l_amt_token,l_qty_token)
1600: , 'QTY1', DECODE(poll.matching_basis, 'AMOUNT',

Line 1798: PO_CORE_S.get_translated_text

1794: POL.LINE_NUM,
1795: poll.SHIPMENT_NUM,
1796: 0,
1797: p_sequence + ROWNUM,
1798: PO_CORE_S.get_translated_text
1799: ('PO_CAN_SHIP_BILL_GRT_REC'
1800: , 'LINE_SHIP_DIST_NUM', l_line_token||pol.LINE_NUM||','||l_ship_token||poll.SHIPMENT_NUM
1801: , 'AMT_QTY_TOKEN', DECODE(poll.matching_basis, 'AMOUNT',l_amt_token,l_qty_token)
1802: , 'QTY1', DECODE(poll.matching_basis, 'AMOUNT',

Line 1993: PO_CORE_S.get_translated_text

1989: POL.LINE_NUM,
1990: poll.SHIPMENT_NUM,
1991: pod.DISTRIBUTION_NUM,
1992: p_sequence + ROWNUM,
1993: PO_CORE_S.get_translated_text
1994: ('PO_CAN_DIST_BILL_GRT_DEL'
1995: ,'LINE_SHIP_DIST_NUM',l_line_token||pol.LINE_NUM||','||l_ship_token||poll.SHIPMENT_NUM||','||l_dist_token||pod.DISTRIBUTION_NUM
1996: ,'AMT_QTY_TOKEN',DECODE(poll.matching_basis, 'AMOUNT',l_amt_token,l_qty_token)
1997: ,'QTY1',DECODE(poll.matching_basis, 'AMOUNT',

Line 2193: PO_CORE_S.get_translated_text(

2189: POL.LINE_NUM,
2190: poll.SHIPMENT_NUM,
2191: null,
2192: p_sequence + ROWNUM,
2193: PO_CORE_S.get_translated_text(
2194: 'PO_CAN_SHIP_REC_NOT_DEL'
2195: , 'LINE_SHIP_DIST_NUM', l_line_token||pol.LINE_NUM||','||l_ship_token||poll.SHIPMENT_NUM
2196: , 'AMT_QTY_TOKEN', DECODE(poll.matching_basis, 'AMOUNT',l_amt_token,l_qty_token)
2197: , 'QTY1', DECODE(poll.matching_basis, 'AMOUNT',

Line 2362: PO_CORE_S.get_translated_text

2358: POL.LINE_NUM,
2359: poll.SHIPMENT_NUM,
2360: 0,
2361: p_sequence + ROWNUM,
2362: PO_CORE_S.get_translated_text
2363: ('PO_CAN_SHIP_WITH_RCV_TRX'
2364: , 'LINE_NUM', pol.LINE_NUM
2365: , 'SHIP_NUM', poll.SHIPMENT_NUM
2366: , 'DOC_NUM', gt.char6

Line 2518: PO_CORE_S.get_translated_text

2514: POL.LINE_NUM,
2515: poll.SHIPMENT_NUM,
2516: 0,
2517: p_sequence + ROWNUM,
2518: PO_CORE_S.get_translated_text
2519: ('PO_CAN_SHIP_WITH_ASN'
2520: , 'LINE_NUM', pol.LINE_NUM
2521: , 'SHIP_NUM', poll.SHIPMENT_NUM
2522: , 'DOC_NUM', gt.char6

Line 2683: PO_CORE_S.get_translated_text

2679: POL.LINE_NUM,
2680: poll.SHIPMENT_NUM,
2681: pod.distribution_num,
2682: p_sequence + ROWNUM,
2683: PO_CORE_S.get_translated_text
2684: ('PO_CAN_DIST_INV_BUDGET_ACCT'
2685: , 'LINE_NUM', pol.LINE_NUM
2686: , 'SHIP_NUM', poll.SHIPMENT_NUM
2687: , 'DIST_NUM', pod.distribution_num

Line 2851: PO_CORE_S.get_translated_text

2847: POL.LINE_NUM,
2848: poll.SHIPMENT_NUM,
2849: pod.distribution_num,
2850: p_sequence + ROWNUM,
2851: PO_CORE_S.get_translated_text
2852: ('PO_CAN_DIST_INV_CHARGE_ACCT'
2853: , 'LINE_NUM', pol.LINE_NUM
2854: , 'SHIP_NUM', poll.SHIPMENT_NUM
2855: , 'DIST_NUM', pod.distribution_num

Line 3013: PO_CORE_S.get_translated_text

3009: POL.LINE_NUM,
3010: 0,
3011: 0,
3012: p_sequence + ROWNUM,
3013: PO_CORE_S.get_translated_text
3014: ('PO_CAN_GA_WITH_OPEN_STD_REF'
3015: , 'LINE_NUM', pol.LINE_NUM
3016: , 'DOC_NUM', gt.char6),
3017:

Line 3171: PO_CORE_S.get_translated_text

3167: POL.LINE_NUM,
3168: 0,
3169: 0,
3170: p_sequence + ROWNUM,
3171: PO_CORE_S.get_translated_text
3172: ('PO_CAN_PA_WITH_OPEN_REL'
3173: , 'LINE_NUM', pol.LINE_NUM
3174: , 'DOC_NUM',gt.char6),
3175:

Line 3228: PO_CORE_S.get_translated_text

3224: POLL.SHIPMENT_NUM,
3225: 0,
3226: p_sequence + ROWNUM,
3227: -- bug 16525950 : Constructing the token value to display shipment number also
3228: PO_CORE_S.get_translated_text
3229: ('PO_CAN_PA_WITH_OPEN_REL'
3230: , 'LINE_NUM', pol.LINE_NUM || l_ship_token || poll.SHIPMENT_NUM
3231: , 'DOC_NUM',gt.char6),
3232:

Line 3389: PO_CORE_S.get_translated_text

3385: gt.num1,
3386: 0,
3387: 0,
3388: p_sequence + ROWNUM,
3389: PO_CORE_S.get_translated_text
3390: ('PO_CAN_CGA_WITH_OPEN_STD_REF'
3391: , 'DOC_NUM',gt.char6),
3392:
3393: gt.num1,

Line 3602: l_new_key := PO_CORE_S.get_session_gt_nextval;

3598: PO_DEBUG.debug_var(d_module,l_progress,'p_key',p_key);
3599: END IF;
3600:
3601:
3602: l_new_key := PO_CORE_S.get_session_gt_nextval;
3603: l_old_key := p_key;
3604: l_progress :='002';
3605:
3606: IF g_debug_stmt THEN

Line 4480: PO_CORE_S.get_translated_text('PO_CAN_CONTROL_SECURITY_FAILED',

4476: 0,
4477: 0,
4478: 0,
4479: p_sequence + ROWNUM,
4480: PO_CORE_S.get_translated_text('PO_CAN_CONTROL_SECURITY_FAILED',
4481: 'DOC_NUM', gt.char6),
4482: gt.num1,
4483: gt.char3
4484: FROM po_headers poh,

Line 4533: PO_CORE_S.get_translated_text('PO_CAN_CONTROL_SECURITY_FAILED',

4529: 0,
4530: 0,
4531: 0,
4532: p_sequence + ROWNUM,
4533: PO_CORE_S.get_translated_text('PO_CAN_CONTROL_SECURITY_FAILED',
4534: 'DOC_NUM',gt.char6),
4535: gt.num1,
4536: gt.char3
4537: FROM

Line 4832: PO_CORE_S.get_translated_text(

4828: 0,
4829: 0,
4830: 0,
4831: p_sequence + 1,
4832: PO_CORE_S.get_translated_text(
4833: 'PO_CAN_CONTROL_INVALID_ACTION',
4834: 'DOC_NUM',
4835: Decode(p_entity_rec_tbl(i).document_type,
4836: po_document_cancel_pvt.c_doc_type_RELEASE,

Line 5158: PO_CORE_S.get_translated_text(

5154: POL.LINE_NUM,
5155: poll.SHIPMENT_NUM,
5156: 0,
5157: l_sequence + ROWNUM,
5158: PO_CORE_S.get_translated_text(
5159: 'PO_CHANGED_CANT_CANCEL_INFO',
5160: 'DOC_LINE_SHIP_DIST_NUM',l_doc_token||gt.char6||','|| l_line_token||pol.LINE_NUM||','||l_ship_token||poll.SHIPMENT_NUM,
5161: 'PRICE_TOKEN',poll.price_override||l_to_token || (SELECT price_override
5162: FROM po_line_locations_archive_all

Line 5350: PO_CORE_S.get_translated_text(

5346: POL.LINE_NUM,
5347: poll.SHIPMENT_NUM,
5348: 0,
5349: p_sequence + ROWNUM,
5350: PO_CORE_S.get_translated_text(
5351: 'PO_CANT_REVERT_PENDING_CHG',
5352: 'DOC_LINE_SHIP_DIST_NUM',l_doc_token||gt.char6||','|| l_line_token||pol.LINE_NUM||','||l_ship_token||poll.SHIPMENT_NUM
5353: ),
5354: 'E',

Line 5450: PO_CORE_S.get_translated_text(

5446: POL.LINE_NUM,
5447: poll.SHIPMENT_NUM,
5448: 0,
5449: p_sequence + ROWNUM,
5450: PO_CORE_S.get_translated_text(
5451: 'PO_CHANGED_CANT_CANCEL_ERR',
5452: 'DOC_LINE_SHIP_DIST_NUM',l_doc_token||gt.char6||','|| l_line_token||pol.LINE_NUM||','||l_ship_token||poll.SHIPMENT_NUM,
5453: 'PRICE_TOKEN', (SELECT price_override
5454: FROM po_line_locations_archive_all

Line 5682: PO_CORE_S.get_translated_text('PO_INVALID_CANCEL_REQS_FLAG',

5678: 0,
5679: 0,
5680: 0,
5681: p_sequence + 1,
5682: PO_CORE_S.get_translated_text('PO_INVALID_CANCEL_REQS_FLAG',
5683: 'USER_VALUE',l_cancel_reqs_flag,
5684: 'SYSTEM_VALUE',l_cancel_reqs_sys_val),
5685:
5686: 0,

Line 5841: PO_CORE_S.get_translated_text

5837: 0,
5838: 0,
5839: 0,
5840: p_sequence + ROWNUM,
5841: PO_CORE_S.get_translated_text
5842: ('PO_INVALID_DOC_TYPE_SUBTYPE'
5843: , 'TYPE', gt.char1
5844: , 'SUBTYPE', gt.char2
5845: ),

Line 5897: PO_CORE_S.get_translated_text

5893: 0,
5894: 0,
5895: 0,
5896: p_sequence + ROWNUM,
5897: PO_CORE_S.get_translated_text
5898: ('PO_INVALID_DOC_IDS',
5899: 'DOC_ID',
5900: gt.num1),
5901: gt.num1,

Line 5943: PO_CORE_S.get_translated_text

5939: 0,
5940: 0,
5941: 0,
5942: p_sequence + ROWNUM,
5943: PO_CORE_S.get_translated_text
5944: ('PO_INVALID_DOC_IDS',
5945: 'DOC_ID',
5946: gt.num1),
5947: gt.num1,

Line 5989: PO_CORE_S.get_translated_text

5985: 0,
5986: 0,
5987: 0,
5988: p_sequence + ROWNUM,
5989: PO_CORE_S.get_translated_text
5990: ('PO_INVALID_DOC_IDS',
5991: 'DOC_ID',
5992: gt.num1),
5993: gt.num1,

Line 6035: PO_CORE_S.get_translated_text

6031: 0,
6032: 0,
6033: 0,
6034: p_sequence + ROWNUM,
6035: PO_CORE_S.get_translated_text
6036: ('PO_INVALID_DOC_IDS',
6037: 'DOC_ID',
6038: gt.num1),
6039: gt.num1,

Line 6083: PO_CORE_S.get_translated_text

6079: 0,
6080: 0,
6081: 0,
6082: p_sequence + ROWNUM,
6083: PO_CORE_S.get_translated_text
6084: ('PO_INVALID_DOC_IDS',
6085: 'DOC_ID',
6086: gt.char4),
6087: gt.num1,

Line 6160: PO_CORE_S.get_translated_text('PO_CAN_DIFF_OU_DOCS'),

6156: 0,
6157: 0,
6158: 0,
6159: p_sequence + 1,
6160: PO_CORE_S.get_translated_text('PO_CAN_DIFF_OU_DOCS'),
6161: 0,
6162: 0
6163: );
6164:

Line 6411: PO_CORE_S.get_translated_text('PO_ACTION_DATE_INVALID',

6407: 0,
6408: 0,
6409: 0,
6410: p_sequence + ROWNUM,
6411: PO_CORE_S.get_translated_text('PO_ACTION_DATE_INVALID',
6412: 'DOC_NUM',
6413: gt.char6,
6414: 'ACTION_DATE',
6415: l_action_date),