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_UTIL_PVT dependencies on FND_MSG_PUB

Line 768: FND_MSG_PUB.initialize;

764: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: END IF;
767: IF FND_API.to_boolean(p_init_msg_list ) THEN
768: FND_MSG_PUB.initialize;
769: END IF;
770: x_return_status := FND_API.G_RET_STS_SUCCESS;
771:
772: --basic parameter validation

Line 781: FND_MSG_PUB.ADD;

777: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_REN_RUL_INV_ARG');
778: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
779: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation', FALSE);
780: END IF;
781: FND_MSG_PUB.ADD;
782:
783: RAISE FND_API.g_exc_error;
784: END IF;
785:

Line 831: FND_MSG_PUB.ADD;

827: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
828: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
829: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_k_rules', FALSE);
830: END IF;
831: FND_MSG_PUB.ADD;
832: CLOSE c_k_rules;
833: RAISE FND_API.g_exc_error;
834: END IF;
835: CLOSE c_k_rules;

Line 911: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

907: log_rules(l_mod_name || '.effective_rules', x_rnrl_rec);
908: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.end', 'x_return_status=' || x_return_status);
909: END IF;
910: END IF;
911: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
912:
913: EXCEPTION
914: WHEN FND_API.g_exc_error THEN
915: x_return_status := FND_API.g_ret_sts_error ;

Line 920: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

916:
917: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
918: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
919: END IF;
920: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
921:
922: IF (c_k_party%isopen) THEN
923: CLOSE c_k_party;
924: END IF;

Line 938: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

934:
935: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
936: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
937: END IF;
938: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
939:
940: IF (c_k_party%isopen) THEN
941: CLOSE c_k_party;
942: END IF;

Line 958: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

954: --first log the sqlerrm
955: l_error_text := substr (SQLERRM, 1, 240);
956: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text );
957: --then add it to the message api list
958: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
959: END IF;
960: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
961:
962: IF (c_k_party%isopen) THEN

Line 960: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

956: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text );
957: --then add it to the message api list
958: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
959: END IF;
960: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
961:
962: IF (c_k_party%isopen) THEN
963: CLOSE c_k_party;
964: END IF;

Line 1074: FND_MSG_PUB.initialize;

1070: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1072: END IF;
1073: IF FND_API.to_boolean(p_init_msg_list ) THEN
1074: FND_MSG_PUB.initialize;
1075: END IF;
1076: x_return_status := FND_API.G_RET_STS_SUCCESS;
1077: x_template_set_id := NULL;
1078: x_template_lang := NULL;

Line 1088: FND_MSG_PUB.ADD;

1084: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
1085: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1086: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_k_org', FALSE);
1087: END IF;
1088: FND_MSG_PUB.ADD;
1089: CLOSE c_k_party_org;
1090: RAISE FND_API.g_exc_error;
1091: END IF;
1092: CLOSE c_k_party_org;

Line 1143: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

1139: IF (FND_LOG.test(FND_LOG.level_procedure, l_mod_name)) THEN
1140: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end','x_template_set_id ='|| x_template_set_id ||', x_return_status='|| x_return_status);
1141: END IF;
1142: END IF;
1143: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
1144:
1145: EXCEPTION
1146:
1147: WHEN FND_API.g_exc_error THEN

Line 1153: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

1149:
1150: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1151: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
1152: END IF;
1153: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
1154:
1155: IF (c_k_party_org%isopen) THEN
1156: CLOSE c_k_party_org;
1157: END IF;

Line 1168: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

1164:
1165: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1166: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
1167: END IF;
1168: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
1169:
1170: IF (c_k_party_org%isopen) THEN
1171: CLOSE c_k_party_org;
1172: END IF;

Line 1185: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

1181: --first log the sqlerrm
1182: l_error_text := substr (SQLERRM, 1, 240);
1183: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1184: --then add it to the message api list
1185: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1186: END IF;
1187: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
1188:
1189: IF (c_k_party_org%isopen) THEN

Line 1187: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

1183: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1184: --then add it to the message api list
1185: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1186: END IF;
1187: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
1188:
1189: IF (c_k_party_org%isopen) THEN
1190: CLOSE c_k_party_org;
1191: END IF;

Line 1320: FND_MSG_PUB.initialize;

1316: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN
1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1318: END IF;
1319: IF FND_API.to_boolean(p_init_msg_list ) THEN
1320: FND_MSG_PUB.initialize;
1321: END IF;
1322: x_return_status := FND_API.G_RET_STS_SUCCESS;
1323:
1324: --basic input validation

Line 1332: FND_MSG_PUB.ADD;

1328: FND_MESSAGE.set_token('PROG_NAME', G_PKG_NAME || '.' || l_api_name);
1329: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1330: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.input_validation', FALSE);
1331: END IF;
1332: FND_MSG_PUB.ADD;
1333: RAISE FND_API.g_exc_error;
1334: END IF;
1335:
1336: --get contract details if they are not passed

Line 1350: FND_MSG_PUB.ADD;

1346: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
1347: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1348: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.get_k_details', FALSE);
1349: END IF;
1350: FND_MSG_PUB.ADD;
1351: RAISE FND_API.g_exc_error;
1352: END IF;
1353:
1354: --means the renewal rules are not passed, get them

Line 1459: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

1455: IF (FND_LOG.test(FND_LOG.level_procedure, l_mod_name)) THEN
1456: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', ' x_return_status='|| x_return_status||', x_renewal_type='||x_renewal_type||' ,x_approval_type='||x_approval_type||' ,x_threshold_used='||x_threshold_used);
1457: END IF;
1458: END IF;
1459: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
1460:
1461: EXCEPTION
1462: WHEN FND_API.g_exc_error THEN
1463: x_return_status := FND_API.g_ret_sts_error ;

Line 1468: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

1464:
1465: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1466: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
1467: END IF;
1468: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
1469:
1470: IF (c_k_hdr%isopen) THEN
1471: CLOSE c_k_hdr;
1472: END IF;

Line 1480: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

1476:
1477: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1478: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
1479: END IF;
1480: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
1481:
1482: IF (c_k_hdr%isopen) THEN
1483: CLOSE c_k_hdr;
1484: END IF;

Line 1494: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);

1490: --first log the sqlerrm
1491: l_error_text := substr (SQLERRM, 1, 240);
1492: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1493: --then add it to the message api list
1494: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1495: END IF;
1496: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
1497:
1498: IF (c_k_hdr%isopen) THEN

Line 1496: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

1492: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1493: --then add it to the message api list
1494: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1495: END IF;
1496: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
1497:
1498: IF (c_k_hdr%isopen) THEN
1499: CLOSE c_k_hdr;
1500: END IF;

Line 1627: FND_MSG_PUB.initialize;

1623: END IF;
1624:
1625: -- Initialize message list if p_init_msg_list is set to TRUE.
1626: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1627: FND_MSG_PUB.initialize;
1628: END IF;
1629:
1630: -- Initialize API return status to success
1631: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1636: FND_MSG_PUB.add;

1632:
1633: IF p_contract_id IS NULL THEN
1634: FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_INVD_CONTRACT_ID');
1635: FND_MESSAGE.SET_TOKEN('HDR_ID',p_contract_id);
1636: FND_MSG_PUB.add;
1637: RAISE FND_API.G_EXC_ERROR;
1638: END IF;
1639:
1640: -- If language is known already, use it to get iso_language and territory

Line 1707: -- FND_MSG_PUB.add;

1703: x_fnd_iso_language := NULL;
1704: x_fnd_iso_territory := NULL;
1705: -- skip raising an error instead return null values
1706: -- FND_MESSAGE.SET_NAME(G_APP_NAME,'OKS_NOLAYOUT_TEMPLATE');
1707: -- FND_MSG_PUB.add;
1708: -- RAISE FND_API.G_EXC_ERROR;
1709: END IF;
1710: END IF;
1711:

Line 1719: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);

1715: ' x_fnd_iso_language '||x_fnd_iso_language||
1716: ' x_fnd_iso_territory ' ||x_fnd_iso_territory);
1717: END IF;
1718: -- Standard call to get message count and if count is 1, get message info.
1719: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count=>x_msg_count, p_data=>x_msg_data);
1720:
1721: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1722: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
1723: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);

Line 1729: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1725:
1726: EXCEPTION
1727: WHEN FND_API.G_EXC_ERROR THEN
1728: x_return_status := FND_API.G_RET_STS_ERROR;
1729: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1730: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1731: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
1732: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ERROR');
1733: END IF;

Line 1741: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1737: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
1738: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
1739: ||SQLCODE||', sqlerrm = '||SQLERRM);
1740: END IF;
1741: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1742: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1743: END get_language_info;
1744:
1745: END OKS_RENEW_UTIL_PVT;

Line 1742: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1738: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
1739: ||SQLCODE||', sqlerrm = '||SQLERRM);
1740: END IF;
1741: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1742: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1743: END get_language_info;
1744:
1745: END OKS_RENEW_UTIL_PVT;