[Home] [Help]
1905: IS
1906: d_mod CONSTANT VARCHAR2(100) := D_check_agreement_dates;
1907:
1908: c_delim CONSTANT VARCHAR2(1) := ' ';
1909: l_linemsg VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_LINE'), 1,25);
1910:
1911: l_message_name VARCHAR2(30);
1912: l_text VARCHAR2(4000);
1913: BEGIN
1924: -- Effective From and To dates of the agreement.
1925:
1926: l_message_name := PO_MESSAGE_S.POX_EXPIRATION_DATES;
1927:
1928: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
1929:
1930: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
1931: ( online_report_id
1932: , last_update_login
1970: -- is before the Effective To date of the agreement.
1971:
1972: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES4;
1973:
1974: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
1975:
1976: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
1977: ( online_report_id
1978: , last_update_login
2018: -- is after the Effective From date of the agreement.
2019:
2020: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES1;
2021:
2022: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
2023:
2024: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
2025: ( online_report_id
2026: , last_update_login
2066: -- is before the Effective To date of the agreement.
2067:
2068: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES;
2069:
2070: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
2071:
2072: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
2073: ( online_report_id
2074: , last_update_login
2114: -- is after the Effective From date of the agreement.
2115:
2116: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES5;
2117:
2118: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
2119:
2120: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
2121: ( online_report_id
2122: , last_update_login