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 JTF_TERR_ASSIGN_PUB

Line 1076: Calls JTF_TERR_ASSIGN_PUB.get_winners to get the resource

1072: END REPRICE_CONTRACT;
1073:
1074: /*
1075: Internal procedure for getting a winning resource from JTF Territories
1076: Calls JTF_TERR_ASSIGN_PUB.get_winners to get the resource
1077: Parameters
1078: p_org_id : org id of the contract
1079: p_party_id : customer or subscriber party id
1080: x_winning_res_id : resource id of the winning salesrep

Line 1103: l_gen_bulk_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;

1099: l_state_code VARCHAR2(360);
1100: l_counter NUMBER;
1101: l_count NUMBER;
1102:
1103: l_gen_bulk_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
1104: l_gen_return_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
1105:
1106: CURSOR c_vendor_details(cp_org_id IN NUMBER, cp_party_id IN NUMBER) IS
1107: SELECT hz.party_name, hrl.country, hrl.region_2

Line 1104: l_gen_return_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;

1100: l_counter NUMBER;
1101: l_count NUMBER;
1102:
1103: l_gen_bulk_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
1104: l_gen_return_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
1105:
1106: CURSOR c_vendor_details(cp_org_id IN NUMBER, cp_party_id IN NUMBER) IS
1107: SELECT hz.party_name, hrl.country, hrl.region_2
1108: FROM hr_locations hrl, hr_all_organization_units hr, hz_parties hz

Line 1162: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_winners', 'calling JTF_TERR_ASSIGN_PUB.get_winners, p_use_type=RESOURCE, p_source_id=-1500, p_trans_id=-1501');

1158: l_gen_bulk_rec.SQUAL_CHAR07(1) := l_country_code;
1159: l_gen_bulk_rec.SQUAL_NUM01(1) := p_party_id;
1160:
1161: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1162: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_winners', 'calling JTF_TERR_ASSIGN_PUB.get_winners, p_use_type=RESOURCE, p_source_id=-1500, p_trans_id=-1501');
1163: END IF;
1164:
1165: fnd_file.put_line(FND_FILE.LOG,' ');
1166: fnd_file.put_line(FND_FILE.LOG,'Calling JTF_TERR_ASSIGN_PUB.get_winners ');

Line 1166: fnd_file.put_line(FND_FILE.LOG,'Calling JTF_TERR_ASSIGN_PUB.get_winners ');

1162: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_winners', 'calling JTF_TERR_ASSIGN_PUB.get_winners, p_use_type=RESOURCE, p_source_id=-1500, p_trans_id=-1501');
1163: END IF;
1164:
1165: fnd_file.put_line(FND_FILE.LOG,' ');
1166: fnd_file.put_line(FND_FILE.LOG,'Calling JTF_TERR_ASSIGN_PUB.get_winners ');
1167: fnd_file.put_line(FND_FILE.LOG,' Parameters: ');
1168: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_object_id(1): '||100);
1169: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.trans_detail_object_id(1): '||1000);
1170: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR01(1): '||l_party_name);

Line 1176: JTF_TERR_ASSIGN_PUB.get_winners

1172: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_CHAR07(1): '||l_country_code);
1173: fnd_file.put_line(FND_FILE.LOG,' l_gen_bulk_rec.SQUAL_NUM01(1): '||p_party_id);
1174: fnd_file.put_line(FND_FILE.LOG,' ');
1175:
1176: JTF_TERR_ASSIGN_PUB.get_winners
1177: (p_api_version_number => 1.0,
1178: p_init_msg_list => FND_API.G_FALSE,
1179: p_use_type => 'RESOURCE',
1180: p_source_id => - 1500,

Line 1193: fnd_file.put_line(FND_FILE.LOG,'After Calling JTF_TERR_ASSIGN_PUB.get_winners ');

1189: x_msg_data => x_msg_data,
1190: x_winners_rec => l_gen_return_rec );
1191:
1192: fnd_file.put_line(FND_FILE.LOG,' ');
1193: fnd_file.put_line(FND_FILE.LOG,'After Calling JTF_TERR_ASSIGN_PUB.get_winners ');
1194: fnd_file.put_line(FND_FILE.LOG,'x_return_status : '||x_return_status);
1195: fnd_file.put_line(FND_FILE.LOG,'x_msg_count : '||x_msg_count);
1196: fnd_file.put_line(FND_FILE.LOG,'x_msg_data : '||x_msg_data);
1197: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1200: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_winners', 'after call to JTF_TERR_ASSIGN_PUB.get_winners, x_return_status='||x_return_status);

1196: fnd_file.put_line(FND_FILE.LOG,'x_msg_data : '||x_msg_data);
1197: fnd_file.put_line(FND_FILE.LOG,' ');
1198:
1199: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1200: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_winners', 'after call to JTF_TERR_ASSIGN_PUB.get_winners, x_return_status='||x_return_status);
1201: END IF;
1202:
1203: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1204: RAISE FND_API.g_exc_unexpected_error;