[Home] [Help]
1272: IS
1273: d_mod CONSTANT VARCHAR2(100) := D_check_agreement_dates;
1274:
1275: c_delim CONSTANT VARCHAR2(1) := ' ';
1276: l_linemsg VARCHAR2(75) := substr(FND_MESSAGE.GET_STRING('PO', 'PO_ZMVOR_LINE'), 1,25);
1277:
1278: l_message_name VARCHAR2(30);
1279: l_text VARCHAR2(4000);
1280: BEGIN
1291: -- Effective From and To dates of the agreement.
1292:
1293: l_message_name := PO_MESSAGE_S.POX_EXPIRATION_DATES;
1294:
1295: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
1296:
1297: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
1298: ( online_report_id
1299: , last_update_login
1337: -- is before the Effective To date of the agreement.
1338:
1339: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES4;
1340:
1341: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
1342:
1343: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
1344: ( online_report_id
1345: , last_update_login
1385: -- is after the Effective From date of the agreement.
1386:
1387: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES1;
1388:
1389: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
1390:
1391: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
1392: ( online_report_id
1393: , last_update_login
1433: -- is before the Effective To date of the agreement.
1434:
1435: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES;
1436:
1437: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
1438:
1439: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
1440: ( online_report_id
1441: , last_update_login
1481: -- is after the Effective From date of the agreement.
1482:
1483: l_message_name := PO_MESSAGE_S.POX_EFFECTIVE_DATES5;
1484:
1485: l_text := FND_MESSAGE.get_string(c_PO,l_message_name);
1486:
1487: INSERT INTO PO_ONLINE_REPORT_TEXT_GT
1488: ( online_report_id
1489: , last_update_login