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.OKL_DEAL_TERMS_PVT dependencies on FND_LOG

Line 1147: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1143: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1144: RAISE OKL_API.G_EXCEPTION_ERROR;
1145: END IF;
1146:
1147: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1148: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1149: 'OKL_DEAL_CREAT_PVT.delete_tnc_group.',
1150: 'p_tnc_id :'||p_tnc_id);
1151: END IF;

Line 1148: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1144: RAISE OKL_API.G_EXCEPTION_ERROR;
1145: END IF;
1146:
1147: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1148: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1149: 'OKL_DEAL_CREAT_PVT.delete_tnc_group.',
1150: 'p_tnc_id :'||p_tnc_id);
1151: END IF;
1152:

Line 1163: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1159: Close l_rgp_csr;
1160:
1161: If l_rgp_found = 'Y' then
1162: --delete the rule group
1163: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'Before call to delete_rule_group = '||x_return_status);
1165: END IF;
1166: l_rgpv_rec.id := p_tnc_id;
1167: okc_rule_pub.delete_rule_group(

Line 1164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'Before call to delete_rule_group = '||x_return_status);

1160:
1161: If l_rgp_found = 'Y' then
1162: --delete the rule group
1163: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'Before call to delete_rule_group = '||x_return_status);
1165: END IF;
1166: l_rgpv_rec.id := p_tnc_id;
1167: okc_rule_pub.delete_rule_group(
1168: p_api_version => p_api_version

Line 1174: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1170: ,x_return_status => x_return_status
1171: ,x_msg_count => x_msg_count
1172: ,x_msg_data => x_msg_data
1173: ,p_rgpv_rec => l_rgpv_rec);
1174: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_rule_group = '||x_return_status);
1176: END IF;
1177: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1178: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_rule_group = '||x_return_status);

1171: ,x_msg_count => x_msg_count
1172: ,x_msg_data => x_msg_data
1173: ,p_rgpv_rec => l_rgpv_rec);
1174: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_rule_group = '||x_return_status);
1176: END IF;
1177: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1178: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1179: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 1210: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1206: Fetch l_ppyl_csr into l_ppyl_id, l_cpl_id;
1207: Exit when l_ppyl_csr%NOTFOUND;
1208: If l_ppyl_id is Not Null Then
1209: --delete the party payment detail
1210: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'Before call to delete_party_payment_dtls = '||x_return_status);
1212: END IF;
1213: l_ppydv_rec.id := l_ppyl_id;
1214: OKL_PARTY_PAYMENTS_PVT.delete_party_payment_dtls(

Line 1211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'Before call to delete_party_payment_dtls = '||x_return_status);

1207: Exit when l_ppyl_csr%NOTFOUND;
1208: If l_ppyl_id is Not Null Then
1209: --delete the party payment detail
1210: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'Before call to delete_party_payment_dtls = '||x_return_status);
1212: END IF;
1213: l_ppydv_rec.id := l_ppyl_id;
1214: OKL_PARTY_PAYMENTS_PVT.delete_party_payment_dtls(
1215: p_api_version => p_api_version,

Line 1222: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1218: x_msg_count => x_msg_count,
1219: x_msg_data => x_msg_data,
1220: p_ppydv_rec => l_ppydv_rec
1221: );
1222: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1223: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_dtls = '||x_return_status);
1224: END IF;
1225: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1223: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_dtls = '||x_return_status);

1219: x_msg_data => x_msg_data,
1220: p_ppydv_rec => l_ppydv_rec
1221: );
1222: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1223: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_dtls = '||x_return_status);
1224: END IF;
1225: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1226: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1227: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 1234: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1230: End If;
1231: End Loop;
1232: Close l_ppyl_csr;
1233: --Delete the party payment header record
1234: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1235: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'Before call to delete_party_payment_hdr = '||x_return_status);
1236: END IF;
1237: l_pphv_rec.id := p_tnc_id;
1238: OKL_PARTY_PAYMENTS_PVT.delete_party_payment_hdr(

Line 1235: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'Before call to delete_party_payment_hdr = '||x_return_status);

1231: End Loop;
1232: Close l_ppyl_csr;
1233: --Delete the party payment header record
1234: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1235: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'Before call to delete_party_payment_hdr = '||x_return_status);
1236: END IF;
1237: l_pphv_rec.id := p_tnc_id;
1238: OKL_PARTY_PAYMENTS_PVT.delete_party_payment_hdr(
1239: p_api_version => p_api_version,

Line 1246: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1242: x_msg_count => x_msg_count,
1243: x_msg_data => x_msg_data,
1244: p_pphv_rec => l_pphv_rec
1245: );
1246: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_hdr = '||x_return_status);
1248: END IF;
1249: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1250: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_hdr = '||x_return_status);

1243: x_msg_data => x_msg_data,
1244: p_pphv_rec => l_pphv_rec
1245: );
1246: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_hdr = '||x_return_status);
1248: END IF;
1249: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1250: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1251: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 1258: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1254: End If;
1255: End If;
1256: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1257:
1258: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'End(-)');
1260: END IF;
1261:
1262: EXCEPTION

Line 1259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'End(-)');

1255: End If;
1256: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1257:
1258: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'End(-)');
1260: END IF;
1261:
1262: EXCEPTION
1263: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1280: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1276: 'OKL_API.G_RET_STS_ERROR',
1277: x_msg_count,
1278: x_msg_data,
1279: '_PVT');
1280: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1281: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - ERROR');
1282: END IF;
1283: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1284: IF l_rgp_csr%ISOPEN THEN

Line 1281: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - ERROR');

1277: x_msg_count,
1278: x_msg_data,
1279: '_PVT');
1280: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1281: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - ERROR');
1282: END IF;
1283: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1284: IF l_rgp_csr%ISOPEN THEN
1285: CLOSE l_rgp_csr;

Line 1300: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1296: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1297: x_msg_count,
1298: x_msg_data,
1299: '_PVT');
1300: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1301: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - UNEXCP ERROR');
1302: END IF;
1303: WHEN OTHERS THEN
1304: IF l_rgp_csr%ISOPEN THEN

Line 1301: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - UNEXCP ERROR');

1297: x_msg_count,
1298: x_msg_data,
1299: '_PVT');
1300: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1301: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - UNEXCP ERROR');
1302: END IF;
1303: WHEN OTHERS THEN
1304: IF l_rgp_csr%ISOPEN THEN
1305: CLOSE l_rgp_csr;

Line 1320: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1316: 'OTHERS',
1317: x_msg_count,
1318: x_msg_data,
1319: '_PVT');
1320: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1321: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - OTHERS');
1322: END IF;
1323: END delete_tnc_group;
1324:

Line 1321: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - OTHERS');

1317: x_msg_count,
1318: x_msg_data,
1319: '_PVT');
1320: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1321: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - OTHERS');
1322: END IF;
1323: END delete_tnc_group;
1324:
1325: End OKL_DEAL_TERMS_PVT;