DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_MESSAGE_S

Line 10998: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES1),1,240)

10994: CASE
10995: WHEN pll.start_date < ph.start_date
10996: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
10997: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
10998: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES1),1,240)
10999: WHEN pll.end_date > ph.end_date
11000: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
11001: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
11002: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES),1,240)

Line 11002: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES),1,240)

10998: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES1),1,240)
10999: WHEN pll.end_date > ph.end_date
11000: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
11001: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
11002: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES),1,240)
11003: WHEN pll.start_date > ph.end_date
11004: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
11005: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
11006: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES4),1,240)

Line 11006: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES4),1,240)

11002: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES),1,240)
11003: WHEN pll.start_date > ph.end_date
11004: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
11005: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
11006: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES4),1,240)
11007: WHEN pll.end_date < ph.start_date
11008: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
11009: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
11010: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES5),1,240)

Line 11010: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES5),1,240)

11006: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES4),1,240)
11007: WHEN pll.end_date < ph.start_date
11008: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
11009: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
11010: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES5),1,240)
11011: WHEN pll.start_date > pl.expiration_date
11012: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
11013: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
11014: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES6),1,240)

Line 11014: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES6),1,240)

11010: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES5),1,240)
11011: WHEN pll.start_date > pl.expiration_date
11012: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
11013: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
11014: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES6),1,240)
11015: WHEN pll.end_date > pl.expiration_date
11016: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
11017: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
11018: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES2),1,240)

Line 11018: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES2),1,240)

11014: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES6),1,240)
11015: WHEN pll.end_date > pl.expiration_date
11016: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
11017: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
11018: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES2),1,240)
11019: END
11020: ,
11021: CASE
11022: WHEN pll.start_date < ph.start_date

Line 11023: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES1

11019: END
11020: ,
11021: CASE
11022: WHEN pll.start_date < ph.start_date
11023: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES1
11024: WHEN pll.end_date > ph.end_date
11025: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES
11026: WHEN pll.start_date > ph.end_date
11027: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES4

Line 11025: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES

11021: CASE
11022: WHEN pll.start_date < ph.start_date
11023: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES1
11024: WHEN pll.end_date > ph.end_date
11025: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES
11026: WHEN pll.start_date > ph.end_date
11027: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES4
11028: WHEN pll.end_date < ph.start_date
11029: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES5

Line 11027: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES4

11023: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES1
11024: WHEN pll.end_date > ph.end_date
11025: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES
11026: WHEN pll.start_date > ph.end_date
11027: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES4
11028: WHEN pll.end_date < ph.start_date
11029: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES5
11030: WHEN pll.start_date > pl.expiration_date
11031: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES6

Line 11029: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES5

11025: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES
11026: WHEN pll.start_date > ph.end_date
11027: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES4
11028: WHEN pll.end_date < ph.start_date
11029: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES5
11030: WHEN pll.start_date > pl.expiration_date
11031: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES6
11032: WHEN pll.end_date > pl.expiration_date
11033: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES2

Line 11031: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES6

11027: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES4
11028: WHEN pll.end_date < ph.start_date
11029: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES5
11030: WHEN pll.start_date > pl.expiration_date
11031: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES6
11032: WHEN pll.end_date > pl.expiration_date
11033: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES2
11034: END
11035: FROM po_headers_gt ph, po_lines_gt pl, po_line_locations_gt pll

Line 11033: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES2

11029: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES5
11030: WHEN pll.start_date > pl.expiration_date
11031: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES6
11032: WHEN pll.end_date > pl.expiration_date
11033: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES2
11034: END
11035: FROM po_headers_gt ph, po_lines_gt pl, po_line_locations_gt pll
11036: WHERE ph.po_header_id = p_document_id
11037: AND pl.po_header_id = ph.po_header_id

Line 11063: l_textline := FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EXPIRATION_DATES);

11059: END IF;
11060:
11061: -- Bug 9816849 : Added condition to avoid checking expiration date for lines
11062: -- having canceled_flag=Y
11063: l_textline := FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EXPIRATION_DATES);
11064: INSERT INTO po_online_report_text_gt(online_report_id,
11065: last_update_login,
11066: last_updated_by,
11067: last_update_date,

Line 11087: PO_MESSAGE_S.POX_EXPIRATION_DATES

11083: 0,
11084: 0,
11085: p_sequence + ROWNUM,
11086: substr(g_linemsg||g_delim||pl.line_num||g_delim||l_textline,1,240),
11087: PO_MESSAGE_S.POX_EXPIRATION_DATES
11088: FROM po_headers_gt ph, po_lines_gt pl
11089: WHERE ph.po_header_id = p_document_id
11090: AND pl.po_header_id = ph.po_header_id
11091: AND (pl.expiration_date < ph.start_date

Line 21327: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',

21323: return(x_chk_unv_invoices);
21324:
21325: EXCEPTION
21326: WHEN OTHERS THEN
21327: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
21328: token1 => 'FILE',
21329: value1 => 'PO_CONTROL_CHECKS',
21330: token2 => 'ERR_NUMBER',
21331: value2 => '360',

Line 22634: l_textline := 'Minimum Guarantee Award Amount Percentage: '|| FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.PO_ALL_ENTER_PERCENT);

22630: l_progress VARCHAR2(3) := '000';
22631: l_textline po_online_report_text.text_line%TYPE := NULL;
22632:
22633: BEGIN
22634: l_textline := 'Minimum Guarantee Award Amount Percentage: '|| FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.PO_ALL_ENTER_PERCENT);
22635: --FND_MESSAGE.SET_NAME('PO',PO_MESSAGE_S.PO_ALL_ENTER_PERCENT);
22636: --FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_line_loc_token_value);
22637:
22638: --l_textline := FND_MESSAGE.GET;

Line 22635: --FND_MESSAGE.SET_NAME('PO',PO_MESSAGE_S.PO_ALL_ENTER_PERCENT);

22631: l_textline po_online_report_text.text_line%TYPE := NULL;
22632:
22633: BEGIN
22634: l_textline := 'Minimum Guarantee Award Amount Percentage: '|| FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.PO_ALL_ENTER_PERCENT);
22635: --FND_MESSAGE.SET_NAME('PO',PO_MESSAGE_S.PO_ALL_ENTER_PERCENT);
22636: --FND_MESSAGE.SET_TOKEN('LINE_LOCATION_TYPE', l_line_loc_token_value);
22637:
22638: --l_textline := FND_MESSAGE.GET;
22639: -- Percentage should be between 0 and 100

Line 22661: , PO_MESSAGE_S.PO_ALL_ENTER_PERCENT

22657: , p_user_id
22658: , SYSDATE
22659: , p_sequence + ROWNUM
22660: , substr(l_textline,1,240)
22661: , PO_MESSAGE_S.PO_ALL_ENTER_PERCENT
22662: , 'E'
22663: FROM PO_HEADERS_GT POH
22664: WHERE POH.po_header_id = p_header_id
22665: AND (POH.clm_min_guar_award_amt_percent > 100