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_API

Line 180: IF (p_chr_id IS NULL OR p_chr_id = FND_API.G_MISS_NUM ) AND

176: AND jtot_object_code IS NULL;
177:
178: BEGIN
179:
180: IF (p_chr_id IS NULL OR p_chr_id = FND_API.G_MISS_NUM ) AND
181: (
182: (p_party_id IS NULL OR p_party_id = FND_API.G_MISS_NUM ) OR
183: (p_org_id IS NULL OR p_org_id = FND_API.G_MISS_NUM)
184: ) THEN

Line 182: (p_party_id IS NULL OR p_party_id = FND_API.G_MISS_NUM ) OR

178: BEGIN
179:
180: IF (p_chr_id IS NULL OR p_chr_id = FND_API.G_MISS_NUM ) AND
181: (
182: (p_party_id IS NULL OR p_party_id = FND_API.G_MISS_NUM ) OR
183: (p_org_id IS NULL OR p_org_id = FND_API.G_MISS_NUM)
184: ) THEN
185:
186: IF p_chr_id IS NULL OR p_chr_id = FND_API.G_MISS_NUM THEN

Line 183: (p_org_id IS NULL OR p_org_id = FND_API.G_MISS_NUM)

179:
180: IF (p_chr_id IS NULL OR p_chr_id = FND_API.G_MISS_NUM ) AND
181: (
182: (p_party_id IS NULL OR p_party_id = FND_API.G_MISS_NUM ) OR
183: (p_org_id IS NULL OR p_org_id = FND_API.G_MISS_NUM)
184: ) THEN
185:
186: IF p_chr_id IS NULL OR p_chr_id = FND_API.G_MISS_NUM THEN
187: OKC_API.SET_MESSAGE(G_APP_NAME, G_REQUIRED_PARAM,

Line 186: IF p_chr_id IS NULL OR p_chr_id = FND_API.G_MISS_NUM THEN

182: (p_party_id IS NULL OR p_party_id = FND_API.G_MISS_NUM ) OR
183: (p_org_id IS NULL OR p_org_id = FND_API.G_MISS_NUM)
184: ) THEN
185:
186: IF p_chr_id IS NULL OR p_chr_id = FND_API.G_MISS_NUM THEN
187: OKC_API.SET_MESSAGE(G_APP_NAME, G_REQUIRED_PARAM,
188: 'TOKEN1', 'CHR_ID',
189: 'TOKEN2', 'GET_PAYMENT_TERMS');
190: END IF;

Line 192: IF p_party_id IS NULL OR p_party_id = FND_API.G_MISS_NUM THEN

188: 'TOKEN1', 'CHR_ID',
189: 'TOKEN2', 'GET_PAYMENT_TERMS');
190: END IF;
191:
192: IF p_party_id IS NULL OR p_party_id = FND_API.G_MISS_NUM THEN
193: OKC_API.SET_MESSAGE(G_APP_NAME, G_REQUIRED_PARAM,
194: 'TOKEN1', 'PARTY_ID',
195: 'TOKEN2', 'GET_PAYMENT_TERMS');
196: END IF;

Line 198: IF p_org_id IS NULL OR p_org_id = FND_API.G_MISS_NUM THEN

194: 'TOKEN1', 'PARTY_ID',
195: 'TOKEN2', 'GET_PAYMENT_TERMS');
196: END IF;
197:
198: IF p_org_id IS NULL OR p_org_id = FND_API.G_MISS_NUM THEN
199: OKC_API.SET_MESSAGE(G_APP_NAME, G_REQUIRED_PARAM,
200: 'TOKEN1', 'ORG_ID',
201: 'TOKEN2', 'GET_PAYMENT_TERMS');
202: END IF;

Line 210: IF p_party_id IS NULL OR p_party_id = FND_API.G_MISS_NUM THEN

206:
207: END IF;
208:
209: -- Check for party_id, if not present get party_id
210: IF p_party_id IS NULL OR p_party_id = FND_API.G_MISS_NUM THEN
211: OPEN l_party_cur;
212: FETCH l_party_cur INTO l_party;
213: CLOSE l_party_cur;
214: ELSE

Line 233: IF p_org_id IS NULL OR p_org_id = FND_API.G_MISS_NUM THEN

229:
230: IF l_payment_term_flag = 'N' THEN
231:
232: -- Check for org_id, if not present get Org_id
233: IF p_org_id IS NULL OR p_org_id = FND_API.G_MISS_NUM THEN
234: OPEN l_org_cur;
235: FETCH l_org_cur INTO l_org;
236: CLOSE l_org_cur;
237: ELSE

Line 403: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false,

399: -------------------------------------------------------------------------
400: */
401: PROCEDURE get_renew_rules(x_return_status OUT NOCOPY VARCHAR2,
402: p_api_version IN NUMBER DEFAULT 1,
403: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false,
404: p_chr_id IN NUMBER,
405: p_party_id IN NUMBER,
406: p_org_id IN NUMBER,
407: p_date IN DATE DEFAULT SYSDATE,

Line 764: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN

760: END IF;
761: END IF;
762:
763: --standard api initilization and checks
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;

Line 765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

761: END IF;
762:
763: --standard api initilization and checks
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;

Line 767: IF FND_API.to_boolean(p_init_msg_list ) THEN

763: --standard api initilization and checks
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:

Line 770: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
773: IF ((p_chr_id IS NULL OR p_chr_id = FND_API.G_MISS_NUM) AND
774: (p_party_id IS NULL OR p_party_id = FND_API.G_MISS_NUM) AND

Line 773: IF ((p_chr_id IS NULL OR p_chr_id = FND_API.G_MISS_NUM) AND

769: END IF;
770: x_return_status := FND_API.G_RET_STS_SUCCESS;
771:
772: --basic parameter validation
773: IF ((p_chr_id IS NULL OR p_chr_id = FND_API.G_MISS_NUM) AND
774: (p_party_id IS NULL OR p_party_id = FND_API.G_MISS_NUM) AND
775: (p_org_id IS NULL OR p_org_id = FND_API.G_MISS_NUM)) THEN
776:
777: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_REN_RUL_INV_ARG');

Line 774: (p_party_id IS NULL OR p_party_id = FND_API.G_MISS_NUM) AND

770: x_return_status := FND_API.G_RET_STS_SUCCESS;
771:
772: --basic parameter validation
773: IF ((p_chr_id IS NULL OR p_chr_id = FND_API.G_MISS_NUM) AND
774: (p_party_id IS NULL OR p_party_id = FND_API.G_MISS_NUM) AND
775: (p_org_id IS NULL OR p_org_id = FND_API.G_MISS_NUM)) THEN
776:
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

Line 775: (p_org_id IS NULL OR p_org_id = FND_API.G_MISS_NUM)) THEN

771:
772: --basic parameter validation
773: IF ((p_chr_id IS NULL OR p_chr_id = FND_API.G_MISS_NUM) AND
774: (p_party_id IS NULL OR p_party_id = FND_API.G_MISS_NUM) AND
775: (p_org_id IS NULL OR p_org_id = FND_API.G_MISS_NUM)) THEN
776:
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);

Line 783: RAISE FND_API.g_exc_error;

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:
786: --initialize the rules table
787: l_rules_tbl(G_INPUT_LEVEL) := p_rnrl_rec;

Line 833: RAISE FND_API.g_exc_error;

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;
836:
837: --if p_org_id is not passed use the contract org id

Line 914: WHEN FND_API.g_exc_error THEN

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 ;
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);

Line 915: x_return_status := FND_API.g_ret_sts_error ;

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 ;
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;

Line 932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

928: IF (c_cgd_rules%isopen) THEN
929: CLOSE c_cgd_rules;
930: END IF;
931:
932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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);

Line 933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

929: CLOSE c_cgd_rules;
930: END IF;
931:
932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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;

Line 951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

947: CLOSE c_cgd_rules;
948: END IF;
949:
950: WHEN OTHERS THEN
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952:
953: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
954: --first log the sqlerrm
955: l_error_text := substr (SQLERRM, 1, 240);

Line 1005: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false,

1001:
1002:
1003: /* stripped down version of get_renew_rules, only gets the template set id and template lang */
1004: PROCEDURE get_template_set(p_api_version IN NUMBER DEFAULT 1,
1005: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false,
1006: p_chr_id IN NUMBER,
1007: x_template_set_id OUT NOCOPY NUMBER,
1008: x_template_lang OUT NOCOPY VARCHAR2,
1009: x_return_status OUT NOCOPY VARCHAR2,

Line 1070: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN

1066: END IF;
1067: END IF;
1068:
1069: --standard api initilization and checks
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;

Line 1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1067: END IF;
1068:
1069: --standard api initilization and checks
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;

Line 1073: IF FND_API.to_boolean(p_init_msg_list ) THEN

1069: --standard api initilization and checks
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;

Line 1076: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
1079:
1080: OPEN c_k_party_org(p_chr_id);

Line 1090: RAISE FND_API.g_exc_error;

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;
1093:
1094: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 1147: WHEN FND_API.g_exc_error THEN

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
1148: x_return_status := FND_API.g_ret_sts_error ;
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);

Line 1148: x_return_status := FND_API.g_ret_sts_error ;

1144:
1145: EXCEPTION
1146:
1147: WHEN FND_API.g_exc_error THEN
1148: x_return_status := FND_API.g_ret_sts_error ;
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;

Line 1162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1158: IF (c_cgd_template_set%isopen) THEN
1159: CLOSE c_cgd_template_set;
1160: END IF;
1161:
1162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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);

Line 1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1159: CLOSE c_cgd_template_set;
1160: END IF;
1161:
1162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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;

Line 1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1174: CLOSE c_cgd_template_set;
1175: END IF;
1176:
1177: WHEN OTHERS THEN
1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1179:
1180: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1181: --first log the sqlerrm
1182: l_error_text := substr (SQLERRM, 1, 240);

Line 1212: p_init_msg_list => FND_API.G_FALSE,

1208: l_msg_data VARCHAR2(4000);
1209:
1210: BEGIN
1211: get_template_set(p_api_version => 1,
1212: p_init_msg_list => FND_API.G_FALSE,
1213: p_chr_id => p_chr_id,
1214: x_template_set_id => l_template_set_id,
1215: x_template_lang => l_template_lang,
1216: x_return_status => l_return_status,

Line 1219: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1215: x_template_lang => l_template_lang,
1216: x_return_status => l_return_status,
1217: x_msg_count => l_msg_count,
1218: x_msg_data => l_msg_data);
1219: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1220: RAISE FND_API.g_exc_unexpected_error;
1221: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1222: RAISE FND_API.g_exc_error;
1223: END IF;

Line 1220: RAISE FND_API.g_exc_unexpected_error;

1216: x_return_status => l_return_status,
1217: x_msg_count => l_msg_count,
1218: x_msg_data => l_msg_data);
1219: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1220: RAISE FND_API.g_exc_unexpected_error;
1221: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1222: RAISE FND_API.g_exc_error;
1223: END IF;
1224:

Line 1221: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1217: x_msg_count => l_msg_count,
1218: x_msg_data => l_msg_data);
1219: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1220: RAISE FND_API.g_exc_unexpected_error;
1221: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1222: RAISE FND_API.g_exc_error;
1223: END IF;
1224:
1225: RETURN l_template_set_id;

Line 1222: RAISE FND_API.g_exc_error;

1218: x_msg_data => l_msg_data);
1219: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1220: RAISE FND_API.g_exc_unexpected_error;
1221: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1222: RAISE FND_API.g_exc_error;
1223: END IF;
1224:
1225: RETURN l_template_set_id;
1226:

Line 1242: p_init_msg_list => FND_API.G_FALSE,

1238: l_msg_data VARCHAR2(4000);
1239:
1240: BEGIN
1241: get_template_set(p_api_version => 1,
1242: p_init_msg_list => FND_API.G_FALSE,
1243: p_chr_id => p_chr_id,
1244: x_template_set_id => l_template_set_id,
1245: x_template_lang => l_template_lang,
1246: x_return_status => l_return_status,

Line 1250: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1246: x_return_status => l_return_status,
1247: x_msg_count => l_msg_count,
1248: x_msg_data => l_msg_data);
1249:
1250: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1251: RAISE FND_API.g_exc_unexpected_error;
1252: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1253: RAISE FND_API.g_exc_error;
1254: END IF;

Line 1251: RAISE FND_API.g_exc_unexpected_error;

1247: x_msg_count => l_msg_count,
1248: x_msg_data => l_msg_data);
1249:
1250: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1251: RAISE FND_API.g_exc_unexpected_error;
1252: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1253: RAISE FND_API.g_exc_error;
1254: END IF;
1255:

Line 1252: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1248: x_msg_data => l_msg_data);
1249:
1250: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1251: RAISE FND_API.g_exc_unexpected_error;
1252: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1253: RAISE FND_API.g_exc_error;
1254: END IF;
1255:
1256: RETURN l_template_lang;

Line 1253: RAISE FND_API.g_exc_error;

1249:
1250: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1251: RAISE FND_API.g_exc_unexpected_error;
1252: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1253: RAISE FND_API.g_exc_error;
1254: END IF;
1255:
1256: RETURN l_template_lang;
1257:

Line 1277: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1273: */
1274: PROCEDURE GET_RENEWAL_TYPE
1275: (
1276: p_api_version IN NUMBER,
1277: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1278: x_return_status OUT NOCOPY VARCHAR2,
1279: x_msg_count OUT NOCOPY NUMBER,
1280: x_msg_data OUT NOCOPY VARCHAR2,
1281: p_chr_id IN NUMBER,

Line 1316: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN

1312: END IF;
1313: END IF;
1314:
1315: --standard api initilization and checks
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;

Line 1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1313: END IF;
1314:
1315: --standard api initilization and checks
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;

Line 1319: IF FND_API.to_boolean(p_init_msg_list ) THEN

1315: --standard api initilization and checks
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:

Line 1322: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
1325: IF(p_chr_id IS NULL) THEN
1326: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_MANDATORY_ARG');

Line 1333: RAISE FND_API.g_exc_error;

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
1337: IF ((p_amount IS NULL) OR (p_currency_code IS NULL) OR (p_rnrl_rec.base_currency IS NULL)) THEN

Line 1351: RAISE FND_API.g_exc_error;

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
1355: IF (p_rnrl_rec.base_currency IS NULL) THEN

Line 1364: p_init_msg_list => FND_API.G_FALSE,

1360:
1361: OKS_RENEW_UTIL_PVT.get_renew_rules(
1362: x_return_status => x_return_status,
1363: p_api_version => 1.0,
1364: p_init_msg_list => FND_API.G_FALSE,
1365: p_chr_id => p_chr_id,
1366: p_party_id => NULL,
1367: p_org_id => NULL,
1368: p_date => l_start_date,

Line 1377: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1373:
1374: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1375: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_get_renew_rules', 'x_return_status=' || x_return_status);
1376: END IF;
1377: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1378: RAISE FND_API.g_exc_unexpected_error;
1379: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1380: RAISE FND_API.g_exc_error;
1381: END IF;

Line 1378: RAISE FND_API.g_exc_unexpected_error;

1374: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1375: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_get_renew_rules', 'x_return_status=' || x_return_status);
1376: END IF;
1377: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1378: RAISE FND_API.g_exc_unexpected_error;
1379: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1380: RAISE FND_API.g_exc_error;
1381: END IF;
1382:

Line 1379: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

1375: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_get_renew_rules', 'x_return_status=' || x_return_status);
1376: END IF;
1377: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1378: RAISE FND_API.g_exc_unexpected_error;
1379: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1380: RAISE FND_API.g_exc_error;
1381: END IF;
1382:
1383: END IF; --of IF (p_rnrl_rec.base_currency IS NULL) THEN

Line 1380: RAISE FND_API.g_exc_error;

1376: END IF;
1377: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1378: RAISE FND_API.g_exc_unexpected_error;
1379: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
1380: RAISE FND_API.g_exc_error;
1381: END IF;
1382:
1383: END IF; --of IF (p_rnrl_rec.base_currency IS NULL) THEN
1384:

Line 1462: WHEN FND_API.g_exc_error THEN

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 ;
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);

Line 1463: x_return_status := FND_API.g_ret_sts_error ;

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 ;
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;

Line 1474: WHEN FND_API.g_exc_unexpected_error THEN

1470: IF (c_k_hdr%isopen) THEN
1471: CLOSE c_k_hdr;
1472: END IF;
1473:
1474: WHEN FND_API.g_exc_unexpected_error THEN
1475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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);

Line 1475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1471: CLOSE c_k_hdr;
1472: END IF;
1473:
1474: WHEN FND_API.g_exc_unexpected_error THEN
1475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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;

Line 1487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1483: CLOSE c_k_hdr;
1484: END IF;
1485:
1486: WHEN OTHERS THEN
1487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1488:
1489: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1490: --first log the sqlerrm
1491: l_error_text := substr (SQLERRM, 1, 240);

Line 1620: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1616: ',p_template_language=>'||p_template_language||');');
1617: END IF;
1618:
1619: -- Standard call to check for call compatibility.
1620: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1621: x_return_status := FND_API.G_RET_STS_ERROR;
1622: RAISE FND_API.G_EXC_ERROR;
1623: END IF;
1624:

Line 1621: x_return_status := FND_API.G_RET_STS_ERROR;

1617: END IF;
1618:
1619: -- Standard call to check for call compatibility.
1620: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1621: x_return_status := FND_API.G_RET_STS_ERROR;
1622: RAISE FND_API.G_EXC_ERROR;
1623: END IF;
1624:
1625: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1622: RAISE FND_API.G_EXC_ERROR;

1618:
1619: -- Standard call to check for call compatibility.
1620: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1621: x_return_status := FND_API.G_RET_STS_ERROR;
1622: RAISE FND_API.G_EXC_ERROR;
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

Line 1626: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1622: RAISE FND_API.G_EXC_ERROR;
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

Line 1631: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
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);

Line 1637: RAISE FND_API.G_EXC_ERROR;

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
1641: IF p_template_language IS NOT NULL THEN

Line 1691: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1687: ' x_attachment_template_id ='||l_attachment_template_id||
1688: ' x_attachment_name ='||l_attachment_name||
1689: ' x_contract_update_status ='||l_k_status);
1690: END IF;
1691: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1692: RAISE FND_API.G_EXC_ERROR;
1693: END IF;
1694: END IF;
1695: -- Get layout template's default language to get installed /

Line 1692: RAISE FND_API.G_EXC_ERROR;

1688: ' x_attachment_name ='||l_attachment_name||
1689: ' x_contract_update_status ='||l_k_status);
1690: END IF;
1691: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1692: RAISE FND_API.G_EXC_ERROR;
1693: END IF;
1694: END IF;
1695: -- Get layout template's default language to get installed /
1696: -- base language's iso language and territory

Line 1708: -- RAISE FND_API.G_EXC_ERROR;

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:
1712: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1727: WHEN FND_API.G_EXC_ERROR THEN

1723: 'Leaving '||G_PKG_NAME ||'.'||l_api_name);
1724: END IF;
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,

Line 1728: x_return_status := FND_API.G_RET_STS_ERROR;

1724: END IF;
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');

Line 1735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1734: WHEN OTHERS THEN
1735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1736: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
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);