DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_MESSAGE_S

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

7864: CASE
7865: WHEN pll.start_date < ph.start_date
7866: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7867: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7868: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES1),1,240)
7869: WHEN pll.end_date > ph.end_date
7870: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7871: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7872: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES),1,240)

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

7868: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES1),1,240)
7869: WHEN pll.end_date > ph.end_date
7870: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7871: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7872: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES),1,240)
7873: WHEN pll.start_date > ph.end_date
7874: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7875: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7876: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES4),1,240)

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

7872: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES),1,240)
7873: WHEN pll.start_date > ph.end_date
7874: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7875: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7876: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES4),1,240)
7877: WHEN pll.end_date < ph.start_date
7878: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7879: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7880: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES5),1,240)

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

7876: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES4),1,240)
7877: WHEN pll.end_date < ph.start_date
7878: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7879: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7880: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES5),1,240)
7881: WHEN pll.start_date > pl.expiration_date
7882: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7883: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7884: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES6),1,240)

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

7880: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES5),1,240)
7881: WHEN pll.start_date > pl.expiration_date
7882: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7883: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7884: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES6),1,240)
7885: WHEN pll.end_date > pl.expiration_date
7886: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7887: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7888: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES2),1,240)

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

7884: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES6),1,240)
7885: WHEN pll.end_date > pl.expiration_date
7886: THEN substr(g_linemsg||g_delim||pl.line_num||g_delim
7887: ||g_price_breakmsg||g_delim||pll.shipment_num||g_delim
7888: ||FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EFFECTIVE_DATES2),1,240)
7889: END
7890: ,
7891: CASE
7892: WHEN pll.start_date < ph.start_date

Line 7893: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES1

7889: END
7890: ,
7891: CASE
7892: WHEN pll.start_date < ph.start_date
7893: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES1
7894: WHEN pll.end_date > ph.end_date
7895: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES
7896: WHEN pll.start_date > ph.end_date
7897: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES4

Line 7895: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES

7891: CASE
7892: WHEN pll.start_date < ph.start_date
7893: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES1
7894: WHEN pll.end_date > ph.end_date
7895: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES
7896: WHEN pll.start_date > ph.end_date
7897: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES4
7898: WHEN pll.end_date < ph.start_date
7899: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES5

Line 7897: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES4

7893: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES1
7894: WHEN pll.end_date > ph.end_date
7895: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES
7896: WHEN pll.start_date > ph.end_date
7897: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES4
7898: WHEN pll.end_date < ph.start_date
7899: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES5
7900: WHEN pll.start_date > pl.expiration_date
7901: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES6

Line 7899: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES5

7895: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES
7896: WHEN pll.start_date > ph.end_date
7897: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES4
7898: WHEN pll.end_date < ph.start_date
7899: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES5
7900: WHEN pll.start_date > pl.expiration_date
7901: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES6
7902: WHEN pll.end_date > pl.expiration_date
7903: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES2

Line 7901: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES6

7897: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES4
7898: WHEN pll.end_date < ph.start_date
7899: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES5
7900: WHEN pll.start_date > pl.expiration_date
7901: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES6
7902: WHEN pll.end_date > pl.expiration_date
7903: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES2
7904: END
7905: FROM po_headers_gt ph, po_lines_gt pl, po_line_locations_gt pll

Line 7903: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES2

7899: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES5
7900: WHEN pll.start_date > pl.expiration_date
7901: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES6
7902: WHEN pll.end_date > pl.expiration_date
7903: THEN PO_MESSAGE_S.POX_EFFECTIVE_DATES2
7904: END
7905: FROM po_headers_gt ph, po_lines_gt pl, po_line_locations_gt pll
7906: WHERE ph.po_header_id = p_document_id
7907: AND pl.po_header_id = ph.po_header_id

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

7927: 'BPA 07: Checking the lines expiration date');
7928: END IF;
7929: END IF;
7930:
7931: l_textline := FND_MESSAGE.GET_STRING('PO', PO_MESSAGE_S.POX_EXPIRATION_DATES);
7932: INSERT INTO po_online_report_text_gt(online_report_id,
7933: last_update_login,
7934: last_updated_by,
7935: last_update_date,

Line 7955: PO_MESSAGE_S.POX_EXPIRATION_DATES

7951: 0,
7952: 0,
7953: p_sequence + ROWNUM,
7954: substr(g_linemsg||g_delim||pl.line_num||g_delim||l_textline,1,240),
7955: PO_MESSAGE_S.POX_EXPIRATION_DATES
7956: FROM po_headers_gt ph, po_lines_gt pl
7957: WHERE ph.po_header_id = p_document_id
7958: AND pl.po_header_id = ph.po_header_id
7959: AND (pl.expiration_date < ph.start_date

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

17336: return(x_chk_unv_invoices);
17337:
17338: EXCEPTION
17339: WHEN OTHERS THEN
17340: PO_MESSAGE_S.APP_ERROR(error_name => 'PO_ALL_TRACE_ERROR',
17341: token1 => 'FILE',
17342: value1 => 'PO_CONTROL_CHECKS',
17343: token2 => 'ERR_NUMBER',
17344: value2 => '360',