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 1069: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1065: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1066: RAISE OKL_API.G_EXCEPTION_ERROR;
1067: END IF;
1068:
1069: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1070: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1071: 'OKL_DEAL_CREAT_PVT.delete_tnc_group.',
1072: 'p_tnc_id :'||p_tnc_id);
1073: END IF;

Line 1070: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1066: RAISE OKL_API.G_EXCEPTION_ERROR;
1067: END IF;
1068:
1069: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1070: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1071: 'OKL_DEAL_CREAT_PVT.delete_tnc_group.',
1072: 'p_tnc_id :'||p_tnc_id);
1073: END IF;
1074:

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

1081: Close l_rgp_csr;
1082:
1083: If l_rgp_found = 'Y' then
1084: --delete the rule group
1085: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'Before call to delete_rule_group = '||x_return_status);
1087: END IF;
1088: l_rgpv_rec.id := p_tnc_id;
1089: okc_rule_pub.delete_rule_group(

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

1082:
1083: If l_rgp_found = 'Y' then
1084: --delete the rule group
1085: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'Before call to delete_rule_group = '||x_return_status);
1087: END IF;
1088: l_rgpv_rec.id := p_tnc_id;
1089: okc_rule_pub.delete_rule_group(
1090: p_api_version => p_api_version

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

1092: ,x_return_status => x_return_status
1093: ,x_msg_count => x_msg_count
1094: ,x_msg_data => x_msg_data
1095: ,p_rgpv_rec => l_rgpv_rec);
1096: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1097: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_rule_group = '||x_return_status);
1098: END IF;
1099: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1093: ,x_msg_count => x_msg_count
1094: ,x_msg_data => x_msg_data
1095: ,p_rgpv_rec => l_rgpv_rec);
1096: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1097: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_rule_group = '||x_return_status);
1098: END IF;
1099: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1101: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

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

1128: Fetch l_ppyl_csr into l_ppyl_id, l_cpl_id;
1129: Exit when l_ppyl_csr%NOTFOUND;
1130: If l_ppyl_id is Not Null Then
1131: --delete the party payment detail
1132: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'Before call to delete_party_payment_dtls = '||x_return_status);
1134: END IF;
1135: l_ppydv_rec.id := l_ppyl_id;
1136: OKL_PARTY_PAYMENTS_PVT.delete_party_payment_dtls(

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

1129: Exit when l_ppyl_csr%NOTFOUND;
1130: If l_ppyl_id is Not Null Then
1131: --delete the party payment detail
1132: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1133: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'Before call to delete_party_payment_dtls = '||x_return_status);
1134: END IF;
1135: l_ppydv_rec.id := l_ppyl_id;
1136: OKL_PARTY_PAYMENTS_PVT.delete_party_payment_dtls(
1137: p_api_version => p_api_version,

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

1140: x_msg_count => x_msg_count,
1141: x_msg_data => x_msg_data,
1142: p_ppydv_rec => l_ppydv_rec
1143: );
1144: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_dtls = '||x_return_status);
1146: END IF;
1147: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1141: x_msg_data => x_msg_data,
1142: p_ppydv_rec => l_ppydv_rec
1143: );
1144: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1145: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_dtls = '||x_return_status);
1146: END IF;
1147: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

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

1152: End If;
1153: End Loop;
1154: Close l_ppyl_csr;
1155: --Delete the party payment header record
1156: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1157: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'Before call to delete_party_payment_hdr = '||x_return_status);
1158: END IF;
1159: l_pphv_rec.id := p_tnc_id;
1160: OKL_PARTY_PAYMENTS_PVT.delete_party_payment_hdr(

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

1153: End Loop;
1154: Close l_ppyl_csr;
1155: --Delete the party payment header record
1156: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1157: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'Before call to delete_party_payment_hdr = '||x_return_status);
1158: END IF;
1159: l_pphv_rec.id := p_tnc_id;
1160: OKL_PARTY_PAYMENTS_PVT.delete_party_payment_hdr(
1161: p_api_version => p_api_version,

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

1164: x_msg_count => x_msg_count,
1165: x_msg_data => x_msg_data,
1166: p_pphv_rec => l_pphv_rec
1167: );
1168: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_hdr = '||x_return_status);
1170: END IF;
1171: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1172: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1165: x_msg_data => x_msg_data,
1166: p_pphv_rec => l_pphv_rec
1167: );
1168: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_hdr = '||x_return_status);
1170: END IF;
1171: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1172: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1173: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

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

1176: End If;
1177: End If;
1178: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1179:
1180: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'End(-)');
1182: END IF;
1183:
1184: EXCEPTION

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

1177: End If;
1178: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1179:
1180: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'End(-)');
1182: END IF;
1183:
1184: EXCEPTION
1185: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

1198: 'OKL_API.G_RET_STS_ERROR',
1199: x_msg_count,
1200: x_msg_data,
1201: '_PVT');
1202: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1203: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - ERROR');
1204: END IF;
1205: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1206: IF l_rgp_csr%ISOPEN THEN

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

1199: x_msg_count,
1200: x_msg_data,
1201: '_PVT');
1202: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1203: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - ERROR');
1204: END IF;
1205: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1206: IF l_rgp_csr%ISOPEN THEN
1207: CLOSE l_rgp_csr;

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

1218: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1219: x_msg_count,
1220: x_msg_data,
1221: '_PVT');
1222: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1223: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - UNEXCP ERROR');
1224: END IF;
1225: WHEN OTHERS THEN
1226: IF l_rgp_csr%ISOPEN THEN

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

1219: x_msg_count,
1220: x_msg_data,
1221: '_PVT');
1222: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1223: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - UNEXCP ERROR');
1224: END IF;
1225: WHEN OTHERS THEN
1226: IF l_rgp_csr%ISOPEN THEN
1227: CLOSE l_rgp_csr;

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

1238: 'OTHERS',
1239: x_msg_count,
1240: x_msg_data,
1241: '_PVT');
1242: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1243: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - OTHERS');
1244: END IF;
1245: END delete_tnc_group;
1246:

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

1239: x_msg_count,
1240: x_msg_data,
1241: '_PVT');
1242: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1243: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - OTHERS');
1244: END IF;
1245: END delete_tnc_group;
1246:
1247: End OKL_DEAL_TERMS_PVT;