[Home] [Help]
1003: l_init_msg_list VARCHAR2(2000) := OKC_API.G_FALSE;
1004: l_return_status VARCHAR2(1);
1005: l_msg_count NUMBER;
1006: l_msg_data VARCHAR2(2000);
1007: l_gen_bulk_Rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
1008: l_gen_return_Rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
1009: l_use_type VARCHAR2(30);
1010: l_contract_id NUMBER;
1011: l_contract_number VARCHAR2(120);
1004: l_return_status VARCHAR2(1);
1005: l_msg_count NUMBER;
1006: l_msg_data VARCHAR2(2000);
1007: l_gen_bulk_Rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
1008: l_gen_return_Rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
1009: l_use_type VARCHAR2(30);
1010: l_contract_id NUMBER;
1011: l_contract_number VARCHAR2(120);
1012: l_cro_code VARCHAR2(200);
2244: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2245: 'INSERTED INTO oks_reassign_resource_TMP : Successful'
2246: || 'Nmber of Recs passedto JTF: '
2247: || l_gen_bulk_rec.trans_object_id.count
2248: || 'JTF_TERR_ASSIGN_PUB.get_winners start :'
2249: || to_char(sysdate,'HH:MI:SS'));
2250: END IF;
2251:
2252: -- Call JTT API to get the winners
2249: || to_char(sysdate,'HH:MI:SS'));
2250: END IF;
2251:
2252: -- Call JTT API to get the winners
2253: JTF_TERR_ASSIGN_PUB.get_winners
2254: ( p_api_version_number => 1.0,
2255: p_init_msg_list => OKC_API.G_FALSE,
2256: p_use_type => l_use_type,
2257: p_source_id => -1500,
2274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2275: ELSE
2276: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2277: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2278: 'JTF_TERR_ASSIGN_PUB.get_winners end :'
2279: || to_char(sysdate,'HH:MI:SS') );
2280: END IF;
2281:
2282: END IF;