eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_RENEW_CONTRACT_PVT dependencies on FND_MESSAGE

Line 96: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NEW_START_MORE_FINAL_END');

92:
93: --first check that the ultimate end date should not be before the start date
94: IF(trunc(p_renewal_end_date) < p_new_start_date) THEN
95:
96: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NEW_START_MORE_FINAL_END');
97: FND_MESSAGE.set_token('START_DATE', to_char(trunc(p_new_start_date), 'DD-MON-YYYY'));
98: FND_MESSAGE.set_token('REN_UP_TO_DATE', to_char(trunc(p_renewal_end_date), 'DD-MON-YYYY'));
99:
100: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

Line 97: FND_MESSAGE.set_token('START_DATE', to_char(trunc(p_new_start_date), 'DD-MON-YYYY'));

93: --first check that the ultimate end date should not be before the start date
94: IF(trunc(p_renewal_end_date) < p_new_start_date) THEN
95:
96: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NEW_START_MORE_FINAL_END');
97: FND_MESSAGE.set_token('START_DATE', to_char(trunc(p_new_start_date), 'DD-MON-YYYY'));
98: FND_MESSAGE.set_token('REN_UP_TO_DATE', to_char(trunc(p_renewal_end_date), 'DD-MON-YYYY'));
99:
100: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
101: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.derive_end_date', FALSE);

Line 98: FND_MESSAGE.set_token('REN_UP_TO_DATE', to_char(trunc(p_renewal_end_date), 'DD-MON-YYYY'));

94: IF(trunc(p_renewal_end_date) < p_new_start_date) THEN
95:
96: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NEW_START_MORE_FINAL_END');
97: FND_MESSAGE.set_token('START_DATE', to_char(trunc(p_new_start_date), 'DD-MON-YYYY'));
98: FND_MESSAGE.set_token('REN_UP_TO_DATE', to_char(trunc(p_renewal_end_date), 'DD-MON-YYYY'));
99:
100: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
101: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.derive_end_date', FALSE);
102: END IF;

Line 1249: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_JTF_RESOURCE');

1245:
1246: END Commented for bug 5493685 */
1247:
1248: IF l_count = 0 THEN
1249: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_JTF_RESOURCE');
1250: FND_MESSAGE.set_token('PARTY', l_party_name);
1251: FND_MESSAGE.set_token('COUNTRY', l_country_code);
1252: FND_MESSAGE.set_token('STATE', l_state_code);
1253: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

Line 1250: FND_MESSAGE.set_token('PARTY', l_party_name);

1246: END Commented for bug 5493685 */
1247:
1248: IF l_count = 0 THEN
1249: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_JTF_RESOURCE');
1250: FND_MESSAGE.set_token('PARTY', l_party_name);
1251: FND_MESSAGE.set_token('COUNTRY', l_country_code);
1252: FND_MESSAGE.set_token('STATE', l_state_code);
1253: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1254: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_winners_error', FALSE);

Line 1251: FND_MESSAGE.set_token('COUNTRY', l_country_code);

1247:
1248: IF l_count = 0 THEN
1249: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_JTF_RESOURCE');
1250: FND_MESSAGE.set_token('PARTY', l_party_name);
1251: FND_MESSAGE.set_token('COUNTRY', l_country_code);
1252: FND_MESSAGE.set_token('STATE', l_state_code);
1253: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1254: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_winners_error', FALSE);
1255: END IF;

Line 1252: FND_MESSAGE.set_token('STATE', l_state_code);

1248: IF l_count = 0 THEN
1249: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_JTF_RESOURCE');
1250: FND_MESSAGE.set_token('PARTY', l_party_name);
1251: FND_MESSAGE.set_token('COUNTRY', l_country_code);
1252: FND_MESSAGE.set_token('STATE', l_state_code);
1253: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1254: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_winners_error', FALSE);
1255: END IF;
1256: FND_MSG_PUB.add;

Line 1444: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVD_PROFILE_VALUE');

1440: ELSIF(l_prof_enable_sc = 'YES') THEN
1441: --for YES:Derive, delete all existing sales credits and derive specified type of sales credit
1442: IF (l_prof_rev_type IS NULL) THEN
1443: --without the profile setup we cannot recreate the sales credit
1444: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVD_PROFILE_VALUE');
1445: FND_MESSAGE.set_token('PROFILE', 'OKS_REVENUE_TYPE');
1446: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1447: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.rev_type_chk', FALSE);
1448: END IF;

Line 1445: FND_MESSAGE.set_token('PROFILE', 'OKS_REVENUE_TYPE');

1441: --for YES:Derive, delete all existing sales credits and derive specified type of sales credit
1442: IF (l_prof_rev_type IS NULL) THEN
1443: --without the profile setup we cannot recreate the sales credit
1444: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVD_PROFILE_VALUE');
1445: FND_MESSAGE.set_token('PROFILE', 'OKS_REVENUE_TYPE');
1446: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1447: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.rev_type_chk', FALSE);
1448: END IF;
1449: FND_MSG_PUB.add;

Line 1458: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVD_PROFILE_VALUE');

1454: END IF;
1455: ELSIF (l_prof_enable_sc = 'DRT') THEN
1456: --for DRT:Derive for Revenue Type and Retain Other, delete and derive specified type of sales credit
1457: IF (l_prof_rev_type IS NULL) THEN
1458: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVD_PROFILE_VALUE');
1459: FND_MESSAGE.set_token('PROFILE', 'OKS_REVENUE_TYPE');
1460: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1461: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.rev_type_chk', FALSE);
1462: END IF;

Line 1459: FND_MESSAGE.set_token('PROFILE', 'OKS_REVENUE_TYPE');

1455: ELSIF (l_prof_enable_sc = 'DRT') THEN
1456: --for DRT:Derive for Revenue Type and Retain Other, delete and derive specified type of sales credit
1457: IF (l_prof_rev_type IS NULL) THEN
1458: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVD_PROFILE_VALUE');
1459: FND_MESSAGE.set_token('PROFILE', 'OKS_REVENUE_TYPE');
1460: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1461: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.rev_type_chk', FALSE);
1462: END IF;
1463: FND_MSG_PUB.add;

Line 1483: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_CONTRACT');

1479: OPEN c_k_hdr(p_chr_id);
1480: FETCH c_k_hdr INTO l_org_id, l_party_id;
1481: CLOSE c_k_hdr;
1482: IF (l_org_id IS NULL) THEN
1483: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_CONTRACT');
1484: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
1485: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1486: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_k_org_party', FALSE);
1487: END IF;

Line 1484: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);

1480: FETCH c_k_hdr INTO l_org_id, l_party_id;
1481: CLOSE c_k_hdr;
1482: IF (l_org_id IS NULL) THEN
1483: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_CONTRACT');
1484: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
1485: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1486: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_k_org_party', FALSE);
1487: END IF;
1488: FND_MSG_PUB.ADD;

Line 1525: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_SREP_FOR_RES');

1521: FETCH c_res_salesrep INTO l_salesrep_id;
1522: CLOSE c_res_salesrep;
1523:
1524: IF l_salesrep_id IS NULL THEN
1525: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_SREP_FOR_RES');
1526: FND_MESSAGE.set_token('RESOURCE_ID', l_resource_id);
1527: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1528: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_jtf_salesrep', FALSE);
1529: END IF;

Line 1526: FND_MESSAGE.set_token('RESOURCE_ID', l_resource_id);

1522: CLOSE c_res_salesrep;
1523:
1524: IF l_salesrep_id IS NULL THEN
1525: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_SREP_FOR_RES');
1526: FND_MESSAGE.set_token('RESOURCE_ID', l_resource_id);
1527: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1528: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_jtf_salesrep', FALSE);
1529: END IF;
1530: FND_MSG_PUB.ADD;

Line 1543: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVD_PROFILE_VALUE');

1539: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_salesrep', 'salesrep from profile option OKS_SALESPERSON_ID='||l_salesrep_id);
1540: END IF;
1541:
1542: IF l_salesrep_id IS NULL THEN
1543: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVD_PROFILE_VALUE');
1544: FND_MESSAGE.set_token('PROFILE', 'OKS_SALESPERSON_ID');
1545: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1546: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_prof_salesrep', FALSE);
1547: END IF;

Line 1544: FND_MESSAGE.set_token('PROFILE', 'OKS_SALESPERSON_ID');

1540: END IF;
1541:
1542: IF l_salesrep_id IS NULL THEN
1543: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVD_PROFILE_VALUE');
1544: FND_MESSAGE.set_token('PROFILE', 'OKS_SALESPERSON_ID');
1545: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1546: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_prof_salesrep', FALSE);
1547: END IF;
1548: FND_MSG_PUB.add;

Line 1571: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_SALESREP_ORG_MATCH');

1567: OPEN c_get_org_name(l_org_id);
1568: FETCH c_get_org_name INTO l_org_name;
1569: CLOSE c_get_org_name;
1570:
1571: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_SALESREP_ORG_MATCH');
1572: FND_MESSAGE.set_token('SALESREP_NAME', l_salesrep_name);
1573: FND_MESSAGE.set_token('ORG_NAME', l_org_name);
1574: IF (FND_LOG.level_event >= FND_LOG.g_current_runtime_level) THEN
1575: FND_LOG.message(FND_LOG.level_event, l_mod_name || '.org_id_match', FALSE);

Line 1572: FND_MESSAGE.set_token('SALESREP_NAME', l_salesrep_name);

1568: FETCH c_get_org_name INTO l_org_name;
1569: CLOSE c_get_org_name;
1570:
1571: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_SALESREP_ORG_MATCH');
1572: FND_MESSAGE.set_token('SALESREP_NAME', l_salesrep_name);
1573: FND_MESSAGE.set_token('ORG_NAME', l_org_name);
1574: IF (FND_LOG.level_event >= FND_LOG.g_current_runtime_level) THEN
1575: FND_LOG.message(FND_LOG.level_event, l_mod_name || '.org_id_match', FALSE);
1576: END IF;

Line 1573: FND_MESSAGE.set_token('ORG_NAME', l_org_name);

1569: CLOSE c_get_org_name;
1570:
1571: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_SALESREP_ORG_MATCH');
1572: FND_MESSAGE.set_token('SALESREP_NAME', l_salesrep_name);
1573: FND_MESSAGE.set_token('ORG_NAME', l_org_name);
1574: IF (FND_LOG.level_event >= FND_LOG.g_current_runtime_level) THEN
1575: FND_LOG.message(FND_LOG.level_event, l_mod_name || '.org_id_match', FALSE);
1576: END IF;
1577: FND_MSG_PUB.add;

Line 1592: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_VENDOR_MERCHANT');

1588: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_ven_mer_id', 'vendor/merhant details, l_cpl_id='||l_cpl_id||' ,l_rle_code='||l_rle_code);
1589: END IF;
1590:
1591: IF (l_cpl_id IS NULL) THEN
1592: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_VENDOR_MERCHANT');
1593: FND_MESSAGE.set_token('CONTRACT_ID', to_char(p_chr_id));
1594: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1595: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_ven_mer_id', FALSE);
1596: END IF;

Line 1593: FND_MESSAGE.set_token('CONTRACT_ID', to_char(p_chr_id));

1589: END IF;
1590:
1591: IF (l_cpl_id IS NULL) THEN
1592: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_VENDOR_MERCHANT');
1593: FND_MESSAGE.set_token('CONTRACT_ID', to_char(p_chr_id));
1594: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1595: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_ven_mer_id', FALSE);
1596: END IF;
1597: FND_MSG_PUB.add;

Line 1613: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_K_SRC_FOR_SREP');

1609: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_cro_code', 'cro_code for role '||l_rle_code||' ,l_cro_code='||l_cro_code);
1610: END IF;
1611:
1612: IF (l_cro_code IS NULL) THEN
1613: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_K_SRC_FOR_SREP');
1614: FND_MESSAGE.set_token('RLE_CODE', l_rle_code);
1615: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1616: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_cro_code', FALSE);
1617: END IF;

Line 1614: FND_MESSAGE.set_token('RLE_CODE', l_rle_code);

1610: END IF;
1611:
1612: IF (l_cro_code IS NULL) THEN
1613: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_K_SRC_FOR_SREP');
1614: FND_MESSAGE.set_token('RLE_CODE', l_rle_code);
1615: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1616: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_cro_code', FALSE);
1617: END IF;
1618: FND_MSG_PUB.add;

Line 1640: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_SALES_GROUP');

1636:
1637: --just log the fact that no salesgroup was found, no error thrown
1638: IF (l_sales_group_id = -1) THEN
1639: IF (FND_LOG.level_event >= FND_LOG.g_current_runtime_level) THEN
1640: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_SALES_GROUP');
1641: FND_MESSAGE.set_token('SALESREP_ID', to_char(l_salesrep_id));
1642: FND_LOG.message(FND_LOG.level_event, l_mod_name || '.get_sales_group', TRUE);
1643: END IF;
1644: END IF;

Line 1641: FND_MESSAGE.set_token('SALESREP_ID', to_char(l_salesrep_id));

1637: --just log the fact that no salesgroup was found, no error thrown
1638: IF (l_sales_group_id = -1) THEN
1639: IF (FND_LOG.level_event >= FND_LOG.g_current_runtime_level) THEN
1640: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_SALES_GROUP');
1641: FND_MESSAGE.set_token('SALESREP_ID', to_char(l_salesrep_id));
1642: FND_LOG.message(FND_LOG.level_event, l_mod_name || '.get_sales_group', TRUE);
1643: END IF;
1644: END IF;
1645:

Line 1699: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVD_PROFILE_VALUE');

1695: l_prof_rev_type_dist := nvl(FND_PROFILE.VALUE('OKS_REVENUE_TYPE_DIST'), '0');
1696: l_percent := to_number(l_prof_rev_type_dist);
1697:
1698: IF (l_percent < 0 OR l_percent > 100) THEN
1699: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVD_PROFILE_VALUE');
1700: FND_MESSAGE.set_token('PROFILE', 'OKS_REVENUE_TYPE_DIST');
1701: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1702: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_rev_type_dist', FALSE);
1703: END IF;

Line 1700: FND_MESSAGE.set_token('PROFILE', 'OKS_REVENUE_TYPE_DIST');

1696: l_percent := to_number(l_prof_rev_type_dist);
1697:
1698: IF (l_percent < 0 OR l_percent > 100) THEN
1699: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVD_PROFILE_VALUE');
1700: FND_MESSAGE.set_token('PROFILE', 'OKS_REVENUE_TYPE_DIST');
1701: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1702: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_rev_type_dist', FALSE);
1703: END IF;
1704: FND_MSG_PUB.add;

Line 2785: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_INVOICE_RULE');

2781: FETCH c_chk_invoice_rule INTO l_rule_id;
2782: CLOSE c_chk_invoice_rule;
2783:
2784: IF(l_rule_id IS NULL) THEN
2785: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_INVOICE_RULE');
2786: FND_MESSAGE.set_token('INVOICE_RULE_ID', l_invoice_rule_id);
2787: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
2788: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.validate_invoice_rule', FALSE);
2789: END IF;

Line 2786: FND_MESSAGE.set_token('INVOICE_RULE_ID', l_invoice_rule_id);

2782: CLOSE c_chk_invoice_rule;
2783:
2784: IF(l_rule_id IS NULL) THEN
2785: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_INVOICE_RULE');
2786: FND_MESSAGE.set_token('INVOICE_RULE_ID', l_invoice_rule_id);
2787: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
2788: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.validate_invoice_rule', FALSE);
2789: END IF;
2790: FND_MSG_PUB.ADD;

Line 2804: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_ACCTG_RULE');

2800: FETCH c_chk_accounting_rule INTO l_rule_id;
2801: CLOSE c_chk_accounting_rule;
2802:
2803: IF(l_rule_id IS NULL) THEN
2804: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_ACCTG_RULE');
2805: FND_MESSAGE.set_token('ACCTG_RULE_ID', l_account_rule_id);
2806: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
2807: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.validate_accounting_rule', FALSE);
2808: END IF;

Line 2805: FND_MESSAGE.set_token('ACCTG_RULE_ID', l_account_rule_id);

2801: CLOSE c_chk_accounting_rule;
2802:
2803: IF(l_rule_id IS NULL) THEN
2804: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_ACCTG_RULE');
2805: FND_MESSAGE.set_token('ACCTG_RULE_ID', l_account_rule_id);
2806: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
2807: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.validate_accounting_rule', FALSE);
2808: END IF;
2809: FND_MSG_PUB.ADD;

Line 4045: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_CONTRACT');

4041: FETCH c_k_hdr INTO l_k_app_id, l_k_num, l_k_mod, l_k_ste_code, l_k_ste_meaning,
4042: l_k_scs_code, l_k_template_yn, l_k_date_terminated, l_k_date_renewed, l_k_end_date;
4043:
4044: IF (c_k_hdr%notfound) THEN
4045: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_CONTRACT');
4046: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
4047: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4048: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_k_values', FALSE);
4049: END IF;

Line 4046: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);

4042: l_k_scs_code, l_k_template_yn, l_k_date_terminated, l_k_date_renewed, l_k_end_date;
4043:
4044: IF (c_k_hdr%notfound) THEN
4045: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_CONTRACT');
4046: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
4047: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4048: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_k_values', FALSE);
4049: END IF;
4050: FND_MSG_PUB.ADD;

Line 4080: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_WARRANTY_DNR');

4076: FETCH c_check_line_warr INTO l_k_line_id;
4077: CLOSE c_check_line_warr;
4078:
4079: IF (l_k_line_id IS NOT NULL) THEN
4080: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_WARRANTY_DNR');
4081: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);
4082: l_msg_count := l_msg_count + 1;
4083: x_validation_tbl(l_msg_count).code := 'OKS_WARRANTY_DNR';
4084: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

Line 4081: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);

4077: CLOSE c_check_line_warr;
4078:
4079: IF (l_k_line_id IS NOT NULL) THEN
4080: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_WARRANTY_DNR');
4081: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);
4082: l_msg_count := l_msg_count + 1;
4083: x_validation_tbl(l_msg_count).code := 'OKS_WARRANTY_DNR';
4084: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4085: x_validation_status := G_VALID_STS_ERROR;

Line 4084: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

4080: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_WARRANTY_DNR');
4081: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);
4082: l_msg_count := l_msg_count + 1;
4083: x_validation_tbl(l_msg_count).code := 'OKS_WARRANTY_DNR';
4084: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4085: x_validation_status := G_VALID_STS_ERROR;
4086: --we don't need to do any more checks if this is a warranty contract
4087: RETURN;
4088: END IF;

Line 4092: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_K_TEMPLATE');

4088: END IF;
4089:
4090: --error if contract is template
4091: IF (nvl(l_k_template_yn, 'X') = 'Y') THEN
4092: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_K_TEMPLATE');
4093: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);
4094: l_msg_count := l_msg_count + 1;
4095: x_validation_tbl(l_msg_count).code := 'OKS_K_TEMPLATE';
4096: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

Line 4093: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);

4089:
4090: --error if contract is template
4091: IF (nvl(l_k_template_yn, 'X') = 'Y') THEN
4092: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_K_TEMPLATE');
4093: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);
4094: l_msg_count := l_msg_count + 1;
4095: x_validation_tbl(l_msg_count).code := 'OKS_K_TEMPLATE';
4096: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4097: x_validation_status := G_VALID_STS_ERROR;

Line 4096: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

4092: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_K_TEMPLATE');
4093: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);
4094: l_msg_count := l_msg_count + 1;
4095: x_validation_tbl(l_msg_count).code := 'OKS_K_TEMPLATE';
4096: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4097: x_validation_status := G_VALID_STS_ERROR;
4098: END IF;
4099:
4100: --error if contract end date is not null

Line 4102: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_PERPETUAL');

4098: END IF;
4099:
4100: --error if contract end date is not null
4101: IF (l_k_end_date IS NULL) THEN
4102: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_PERPETUAL');
4103: FND_MESSAGE.set_token('COMPONENT', l_k_num_mod);
4104: l_msg_count := l_msg_count + 1;
4105: x_validation_tbl(l_msg_count).code := 'OKS_NO_PERPETUAL';
4106: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

Line 4103: FND_MESSAGE.set_token('COMPONENT', l_k_num_mod);

4099:
4100: --error if contract end date is not null
4101: IF (l_k_end_date IS NULL) THEN
4102: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_PERPETUAL');
4103: FND_MESSAGE.set_token('COMPONENT', l_k_num_mod);
4104: l_msg_count := l_msg_count + 1;
4105: x_validation_tbl(l_msg_count).code := 'OKS_NO_PERPETUAL';
4106: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4107: x_validation_status := G_VALID_STS_ERROR;

Line 4106: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

4102: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_PERPETUAL');
4103: FND_MESSAGE.set_token('COMPONENT', l_k_num_mod);
4104: l_msg_count := l_msg_count + 1;
4105: x_validation_tbl(l_msg_count).code := 'OKS_NO_PERPETUAL';
4106: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4107: x_validation_status := G_VALID_STS_ERROR;
4108: END IF;
4109:
4110: --if p_date is null, use contract end date + 1 . If contract end date is also null use sysdate

Line 4116: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVALID_K_STATUS');

4112:
4113:
4114: --error if status not in 'ACTIVE', 'EXPIRED' and 'SIGNED'
4115: IF (l_k_ste_code NOT IN ('ACTIVE', 'EXPIRED', 'SIGNED')) THEN
4116: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVALID_K_STATUS');
4117: FND_MESSAGE.set_token('STATUS', l_k_ste_meaning);
4118: l_msg_count := l_msg_count + 1;
4119: x_validation_tbl(l_msg_count).code := 'OKS_INVALID_K_STATUS';
4120: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

Line 4117: FND_MESSAGE.set_token('STATUS', l_k_ste_meaning);

4113:
4114: --error if status not in 'ACTIVE', 'EXPIRED' and 'SIGNED'
4115: IF (l_k_ste_code NOT IN ('ACTIVE', 'EXPIRED', 'SIGNED')) THEN
4116: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVALID_K_STATUS');
4117: FND_MESSAGE.set_token('STATUS', l_k_ste_meaning);
4118: l_msg_count := l_msg_count + 1;
4119: x_validation_tbl(l_msg_count).code := 'OKS_INVALID_K_STATUS';
4120: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4121: x_validation_status := G_VALID_STS_ERROR;

Line 4120: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

4116: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVALID_K_STATUS');
4117: FND_MESSAGE.set_token('STATUS', l_k_ste_meaning);
4118: l_msg_count := l_msg_count + 1;
4119: x_validation_tbl(l_msg_count).code := 'OKS_INVALID_K_STATUS';
4120: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4121: x_validation_status := G_VALID_STS_ERROR;
4122: END IF;
4123:
4124: --error if contract has been terminated for a future date

Line 4126: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_FUTURE_TERMINATED_K');

4122: END IF;
4123:
4124: --error if contract has been terminated for a future date
4125: IF (l_k_date_terminated IS NOT NULL) THEN
4126: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_FUTURE_TERMINATED_K');
4127: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);
4128: l_msg_count := l_msg_count + 1;
4129: x_validation_tbl(l_msg_count).code := 'OKS_FUTURE_TERMINATED_K';
4130: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

Line 4127: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);

4123:
4124: --error if contract has been terminated for a future date
4125: IF (l_k_date_terminated IS NOT NULL) THEN
4126: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_FUTURE_TERMINATED_K');
4127: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);
4128: l_msg_count := l_msg_count + 1;
4129: x_validation_tbl(l_msg_count).code := 'OKS_FUTURE_TERMINATED_K';
4130: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4131: x_validation_status := G_VALID_STS_ERROR;

Line 4130: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

4126: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_FUTURE_TERMINATED_K');
4127: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);
4128: l_msg_count := l_msg_count + 1;
4129: x_validation_tbl(l_msg_count).code := 'OKS_FUTURE_TERMINATED_K';
4130: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4131: x_validation_status := G_VALID_STS_ERROR;
4132: END IF;
4133:
4134: --check if contract has been renewed

Line 4153: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_UPDATE');

4149: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_get_k_access_level', 'l_k_access_level=' || l_k_access_level);
4150: END IF;
4151:
4152: IF (nvl(l_k_access_level, 'X') <> 'U') THEN
4153: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_UPDATE');
4154: FND_MESSAGE.set_token('CHR', l_k_num_mod);
4155: l_msg_count := l_msg_count + 1;
4156: x_validation_tbl(l_msg_count).code := 'OKS_NO_UPDATE';
4157: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

Line 4154: FND_MESSAGE.set_token('CHR', l_k_num_mod);

4150: END IF;
4151:
4152: IF (nvl(l_k_access_level, 'X') <> 'U') THEN
4153: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_UPDATE');
4154: FND_MESSAGE.set_token('CHR', l_k_num_mod);
4155: l_msg_count := l_msg_count + 1;
4156: x_validation_tbl(l_msg_count).code := 'OKS_NO_UPDATE';
4157: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4158: x_validation_status := G_VALID_STS_ERROR;

Line 4157: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

4153: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_UPDATE');
4154: FND_MESSAGE.set_token('CHR', l_k_num_mod);
4155: l_msg_count := l_msg_count + 1;
4156: x_validation_tbl(l_msg_count).code := 'OKS_NO_UPDATE';
4157: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4158: x_validation_status := G_VALID_STS_ERROR;
4159: END IF;
4160:
4161: --before doing any line level validations, check if there are valid lines to begin with

Line 4185: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_K_RENEW_CONSOLIDATED');

4181: FETCH c_check_line_rencon INTO l_k_line_id;
4182: CLOSE c_check_line_rencon;
4183:
4184: IF (l_k_line_id IS NULL) THEN
4185: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_K_RENEW_CONSOLIDATED');
4186: l_msg_count := l_msg_count + 1;
4187: x_validation_tbl(l_msg_count).code := 'OKS_K_RENEW_CONSOLIDATED';
4188: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4189: x_validation_status := G_VALID_STS_ERROR;

Line 4188: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

4184: IF (l_k_line_id IS NULL) THEN
4185: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_K_RENEW_CONSOLIDATED');
4186: l_msg_count := l_msg_count + 1;
4187: x_validation_tbl(l_msg_count).code := 'OKS_K_RENEW_CONSOLIDATED';
4188: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4189: x_validation_status := G_VALID_STS_ERROR;
4190: END IF;
4191: END IF;
4192:

Line 4224: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_DNR_MSG');

4220: RAISE FND_API.g_exc_error;
4221: END IF;
4222:
4223: IF (nvl(l_k_ren_type, 'X') = 'DNR') THEN
4224: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_DNR_MSG');
4225: l_msg_count := l_msg_count + 1;
4226: x_validation_tbl(l_msg_count).code := 'OKS_DNR_MSG';
4227: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4228: x_validation_status := G_VALID_STS_ERROR;

Line 4227: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

4223: IF (nvl(l_k_ren_type, 'X') = 'DNR') THEN
4224: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_DNR_MSG');
4225: l_msg_count := l_msg_count + 1;
4226: x_validation_tbl(l_msg_count).code := 'OKS_DNR_MSG';
4227: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4228: x_validation_status := G_VALID_STS_ERROR;
4229: END IF;
4230:
4231:

Line 4261: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_ALREADY_NOT_RENEWED');

4257:
4258: --renewed contract is CANCELLED - warning
4259: IF(nvl(l_renk_ste_code, 'X') = 'CANCELLED' )THEN
4260:
4261: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_ALREADY_NOT_RENEWED');
4262: --FND_MESSAGE.set_token('CHR', l_k_num_mod);
4263: l_msg_count := l_msg_count + 1;
4264: x_validation_tbl(l_msg_count).code := 'OKS_ALREADY_NOT_RENEWED';
4265: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

Line 4262: --FND_MESSAGE.set_token('CHR', l_k_num_mod);

4258: --renewed contract is CANCELLED - warning
4259: IF(nvl(l_renk_ste_code, 'X') = 'CANCELLED' )THEN
4260:
4261: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_ALREADY_NOT_RENEWED');
4262: --FND_MESSAGE.set_token('CHR', l_k_num_mod);
4263: l_msg_count := l_msg_count + 1;
4264: x_validation_tbl(l_msg_count).code := 'OKS_ALREADY_NOT_RENEWED';
4265: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4266: IF (x_validation_status <> G_VALID_STS_ERROR) THEN

Line 4265: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

4261: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_ALREADY_NOT_RENEWED');
4262: --FND_MESSAGE.set_token('CHR', l_k_num_mod);
4263: l_msg_count := l_msg_count + 1;
4264: x_validation_tbl(l_msg_count).code := 'OKS_ALREADY_NOT_RENEWED';
4265: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4266: IF (x_validation_status <> G_VALID_STS_ERROR) THEN
4267: x_validation_status := G_VALID_STS_WARNING;
4268: END IF;
4269:

Line 4273: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_RENCOPY_ENTERED');

4269:
4270: --renewed contract is ENETERED - error
4271: ELSIF (nvl(l_renk_ste_code, 'X') = 'ENTERED' ) THEN
4272:
4273: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_RENCOPY_ENTERED');
4274: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);
4275: FND_MESSAGE.set_token('RENCOPY', l_renk_num);
4276: l_msg_count := l_msg_count + 1;
4277: x_validation_tbl(l_msg_count).code := 'OKS_RENCOPY_ENTERED';

Line 4274: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);

4270: --renewed contract is ENETERED - error
4271: ELSIF (nvl(l_renk_ste_code, 'X') = 'ENTERED' ) THEN
4272:
4273: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_RENCOPY_ENTERED');
4274: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);
4275: FND_MESSAGE.set_token('RENCOPY', l_renk_num);
4276: l_msg_count := l_msg_count + 1;
4277: x_validation_tbl(l_msg_count).code := 'OKS_RENCOPY_ENTERED';
4278: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

Line 4275: FND_MESSAGE.set_token('RENCOPY', l_renk_num);

4271: ELSIF (nvl(l_renk_ste_code, 'X') = 'ENTERED' ) THEN
4272:
4273: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_RENCOPY_ENTERED');
4274: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);
4275: FND_MESSAGE.set_token('RENCOPY', l_renk_num);
4276: l_msg_count := l_msg_count + 1;
4277: x_validation_tbl(l_msg_count).code := 'OKS_RENCOPY_ENTERED';
4278: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4279: x_validation_status := G_VALID_STS_ERROR;

Line 4278: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

4274: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);
4275: FND_MESSAGE.set_token('RENCOPY', l_renk_num);
4276: l_msg_count := l_msg_count + 1;
4277: x_validation_tbl(l_msg_count).code := 'OKS_RENCOPY_ENTERED';
4278: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4279: x_validation_status := G_VALID_STS_ERROR;
4280:
4281: --all other statuses treated as ACTIVE ( ACTIVE/EXPIRED/SIGNED/QA_HOLD etc) -error
4282: ELSE

Line 4283: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_RENCOPY_APPROVE');

4279: x_validation_status := G_VALID_STS_ERROR;
4280:
4281: --all other statuses treated as ACTIVE ( ACTIVE/EXPIRED/SIGNED/QA_HOLD etc) -error
4282: ELSE
4283: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_RENCOPY_APPROVE');
4284: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);
4285: FND_MESSAGE.set_token('RENCOPY', l_renk_num);
4286: l_msg_count := l_msg_count + 1;
4287: x_validation_tbl(l_msg_count).code := 'OKS_RENCOPY_APPROVE';

Line 4284: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);

4280:
4281: --all other statuses treated as ACTIVE ( ACTIVE/EXPIRED/SIGNED/QA_HOLD etc) -error
4282: ELSE
4283: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_RENCOPY_APPROVE');
4284: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);
4285: FND_MESSAGE.set_token('RENCOPY', l_renk_num);
4286: l_msg_count := l_msg_count + 1;
4287: x_validation_tbl(l_msg_count).code := 'OKS_RENCOPY_APPROVE';
4288: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

Line 4285: FND_MESSAGE.set_token('RENCOPY', l_renk_num);

4281: --all other statuses treated as ACTIVE ( ACTIVE/EXPIRED/SIGNED/QA_HOLD etc) -error
4282: ELSE
4283: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_RENCOPY_APPROVE');
4284: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);
4285: FND_MESSAGE.set_token('RENCOPY', l_renk_num);
4286: l_msg_count := l_msg_count + 1;
4287: x_validation_tbl(l_msg_count).code := 'OKS_RENCOPY_APPROVE';
4288: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4289: x_validation_status := G_VALID_STS_ERROR;

Line 4288: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

4284: FND_MESSAGE.set_token('NUMBER', l_k_num_mod);
4285: FND_MESSAGE.set_token('RENCOPY', l_renk_num);
4286: l_msg_count := l_msg_count + 1;
4287: x_validation_tbl(l_msg_count).code := 'OKS_RENCOPY_APPROVE';
4288: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4289: x_validation_status := G_VALID_STS_ERROR;
4290:
4291: END IF; --of IF( nvl(l_renk_ste_code, 'X') = 'CANCELLED' )THEN
4292:

Line 4313: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_LINES_SUBLINES_TERMINATED');

4309: FETCH c_check_line_term_canc INTO l_k_line_id;
4310: CLOSE c_check_line_term_canc;
4311:
4312: IF (l_k_line_id IS NULL) THEN
4313: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_LINES_SUBLINES_TERMINATED');
4314: l_msg_count := l_msg_count + 1;
4315: x_validation_tbl(l_msg_count).code := 'OKS_LINES_SUBLINES_TERMINATED';
4316: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4317: IF (x_validation_status <> G_VALID_STS_ERROR) THEN

Line 4316: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

4312: IF (l_k_line_id IS NULL) THEN
4313: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_LINES_SUBLINES_TERMINATED');
4314: l_msg_count := l_msg_count + 1;
4315: x_validation_tbl(l_msg_count).code := 'OKS_LINES_SUBLINES_TERMINATED';
4316: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4317: IF (x_validation_status <> G_VALID_STS_ERROR) THEN
4318: x_validation_status := G_VALID_STS_WARNING;
4319: END IF;
4320: END IF;

Line 4329: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_LINES_DNR');

4325: FETCH c_check_line_dnr INTO l_k_line_id;
4326: CLOSE c_check_line_dnr;
4327:
4328: IF (l_k_line_id IS NULL) THEN
4329: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_LINES_DNR');
4330: l_msg_count := l_msg_count + 1;
4331: x_validation_tbl(l_msg_count).code := 'OKS_LINES_DNR';
4332: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4333: IF (x_validation_status <> G_VALID_STS_ERROR) THEN

Line 4332: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;

4328: IF (l_k_line_id IS NULL) THEN
4329: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_LINES_DNR');
4330: l_msg_count := l_msg_count + 1;
4331: x_validation_tbl(l_msg_count).code := 'OKS_LINES_DNR';
4332: x_validation_tbl(l_msg_count).message := FND_MESSAGE.get;
4333: IF (x_validation_status <> G_VALID_STS_ERROR) THEN
4334: x_validation_status := G_VALID_STS_WARNING;
4335: END IF;
4336: END IF;

Line 4879: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_CONTRACT');

4875: FETCH c_k_hdr INTO l_org_id, l_cpl_id;
4876: CLOSE c_k_hdr;
4877:
4878: IF (l_org_id IS NULL) THEN
4879: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_CONTRACT');
4880: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
4881: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4882: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation', FALSE);
4883: END IF;

Line 4880: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);

4876: CLOSE c_k_hdr;
4877:
4878: IF (l_org_id IS NULL) THEN
4879: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_CONTRACT');
4880: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
4881: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4882: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation', FALSE);
4883: END IF;
4884: FND_MSG_PUB.ADD;

Line 4950: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_HELPDESK');

4946: --commented out, do not throw error if no helpdesk setup
4947: --so that renewal can continue
4948: /*
4949: IF (l_user_id IS NULL) THEN
4950: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_HELPDESK');
4951: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
4952: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_helpdesk_user', FALSE);
4953: END IF;
4954: FND_MSG_PUB.ADD;

Line 5190: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_CONTRACT');

5186: l_k_renewal_end_date, l_k_currency_code;
5187:
5188: --invalid contract id or if it's not a service contract
5189: IF (c_k_hdr%notfound) THEN
5190: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_CONTRACT');
5191: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
5192: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5193: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation1', FALSE);
5194: END IF;

Line 5191: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);

5187:
5188: --invalid contract id or if it's not a service contract
5189: IF (c_k_hdr%notfound) THEN
5190: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_CONTRACT');
5191: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
5192: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5193: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation1', FALSE);
5194: END IF;
5195: FND_MSG_PUB.ADD;

Line 5203: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NEW_START_MORE_END');

5199: CLOSE c_k_hdr;
5200:
5201: --new start date < original end date
5202: IF (p_new_start_date IS NOT NULL) AND (p_new_start_date < l_k_end_date) THEN
5203: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NEW_START_MORE_END');
5204: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5205: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation2', FALSE);
5206: END IF;
5207: FND_MSG_PUB.ADD;

Line 5213: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVALID_END_DATE');

5209: END IF;
5210:
5211: --new end date < new start date, if new start date is null use old end date + 1
5212: IF (p_new_end_date IS NOT NULL) AND (p_new_end_date < nvl(p_new_start_date, l_k_end_date + 1)) THEN
5213: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVALID_END_DATE');
5214: FND_MESSAGE.set_token('START_DATE', to_char(nvl(p_new_start_date, l_k_end_date + 1)));
5215: FND_MESSAGE.set_token('END_DATE', to_char(p_new_end_date));
5216: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5217: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation3', FALSE);

Line 5214: FND_MESSAGE.set_token('START_DATE', to_char(nvl(p_new_start_date, l_k_end_date + 1)));

5210:
5211: --new end date < new start date, if new start date is null use old end date + 1
5212: IF (p_new_end_date IS NOT NULL) AND (p_new_end_date < nvl(p_new_start_date, l_k_end_date + 1)) THEN
5213: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVALID_END_DATE');
5214: FND_MESSAGE.set_token('START_DATE', to_char(nvl(p_new_start_date, l_k_end_date + 1)));
5215: FND_MESSAGE.set_token('END_DATE', to_char(p_new_end_date));
5216: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5217: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation3', FALSE);
5218: END IF;

Line 5215: FND_MESSAGE.set_token('END_DATE', to_char(p_new_end_date));

5211: --new end date < new start date, if new start date is null use old end date + 1
5212: IF (p_new_end_date IS NOT NULL) AND (p_new_end_date < nvl(p_new_start_date, l_k_end_date + 1)) THEN
5213: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INVALID_END_DATE');
5214: FND_MESSAGE.set_token('START_DATE', to_char(nvl(p_new_start_date, l_k_end_date + 1)));
5215: FND_MESSAGE.set_token('END_DATE', to_char(p_new_end_date));
5216: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
5217: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation3', FALSE);
5218: END IF;
5219: FND_MSG_PUB.ADD;

Line 5282: --using FND_MSG_PUB.add. FND_MSG_PUB.add expects messages on the message stack (FND_MESSAGE.set_name)

5278: --add all validation messages to the FND_MSG_PUB stack
5279: FOR i in l_validation_tbl.FIRST..l_validation_tbl.LAST LOOP
5280: --OKS_USER_DEFINED_MESSAGE is a special message, with the message body = MESSAGE
5281: --This is a workaround, because we can't directly add messages to the msg API list
5282: --using FND_MSG_PUB.add. FND_MSG_PUB.add expects messages on the message stack (FND_MESSAGE.set_name)
5283: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_USER_DEFINED_MESSAGE');
5284: FND_MESSAGE.set_token('MESSAGE', l_validation_tbl(i).message);
5285: FND_MSG_PUB.add;
5286: END LOOP;

Line 5283: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_USER_DEFINED_MESSAGE');

5279: FOR i in l_validation_tbl.FIRST..l_validation_tbl.LAST LOOP
5280: --OKS_USER_DEFINED_MESSAGE is a special message, with the message body = MESSAGE
5281: --This is a workaround, because we can't directly add messages to the msg API list
5282: --using FND_MSG_PUB.add. FND_MSG_PUB.add expects messages on the message stack (FND_MESSAGE.set_name)
5283: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_USER_DEFINED_MESSAGE');
5284: FND_MESSAGE.set_token('MESSAGE', l_validation_tbl(i).message);
5285: FND_MSG_PUB.add;
5286: END LOOP;
5287: RAISE FND_API.g_exc_error;

Line 5284: FND_MESSAGE.set_token('MESSAGE', l_validation_tbl(i).message);

5280: --OKS_USER_DEFINED_MESSAGE is a special message, with the message body = MESSAGE
5281: --This is a workaround, because we can't directly add messages to the msg API list
5282: --using FND_MSG_PUB.add. FND_MSG_PUB.add expects messages on the message stack (FND_MESSAGE.set_name)
5283: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_USER_DEFINED_MESSAGE');
5284: FND_MESSAGE.set_token('MESSAGE', l_validation_tbl(i).message);
5285: FND_MSG_PUB.add;
5286: END LOOP;
5287: RAISE FND_API.g_exc_error;
5288: END IF;