DBA Data[Home] [Help]

APPS.IEX_GAR_PUB dependencies on JTY_ASSIGN_BULK_PUB

Line 170: IEX_TERR_WINNERS_PUB.Print_Debug('Starting JTY_ASSIGN_BULK_PUB.get_winners for worker '|| p_worker_id);

166: --
167:
168: BEGIN
169:
170: IEX_TERR_WINNERS_PUB.Print_Debug('Starting JTY_ASSIGN_BULK_PUB.get_winners for worker '|| p_worker_id);
171:
172: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
173: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
174: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting JTY_ASSIGN_BULK_PUB.get_winners...');

Line 174: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting JTY_ASSIGN_BULK_PUB.get_winners...');

170: IEX_TERR_WINNERS_PUB.Print_Debug('Starting JTY_ASSIGN_BULK_PUB.get_winners for worker '|| p_worker_id);
171:
172: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
173: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
174: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting JTY_ASSIGN_BULK_PUB.get_winners...');
175:
176: JTY_ASSIGN_BULK_PUB.get_winners(
177: p_api_version_number => 1.0,
178: p_init_msg_list => FND_API.G_FALSE,

Line 176: JTY_ASSIGN_BULK_PUB.get_winners(

172: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
173: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
174: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting JTY_ASSIGN_BULK_PUB.get_winners...');
175:
176: JTY_ASSIGN_BULK_PUB.get_winners(
177: p_api_version_number => 1.0,
178: p_init_msg_list => FND_API.G_FALSE,
179: p_source_id => -1600,
180: p_trans_id => -1601,

Line 192: IEX_TERR_WINNERS_PUB.Print_Debug('Completed JTY_ASSIGN_BULK_PUB.get_winners for worker '

188: ERRBUF => l_errbuf,
189: RETCODE => l_retcode
190: );
191:
192: IEX_TERR_WINNERS_PUB.Print_Debug('Completed JTY_ASSIGN_BULK_PUB.get_winners for worker '
193: || p_worker_id || ' with status ' || l_return_status);
194:
195: IEX_TERR_WINNERS_PUB.Print_Debug('Message from JTY_ASSIGN_BULK_PUB.get_winners for worker ' ||
196: l_msg_data);

Line 195: IEX_TERR_WINNERS_PUB.Print_Debug('Message from JTY_ASSIGN_BULK_PUB.get_winners for worker ' ||

191:
192: IEX_TERR_WINNERS_PUB.Print_Debug('Completed JTY_ASSIGN_BULK_PUB.get_winners for worker '
193: || p_worker_id || ' with status ' || l_return_status);
194:
195: IEX_TERR_WINNERS_PUB.Print_Debug('Message from JTY_ASSIGN_BULK_PUB.get_winners for worker ' ||
196: l_msg_data);
197:
198: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
199: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');

Line 200: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ending JTY_ASSIGN_BULK_PUB.get_winners...');

196: l_msg_data);
197:
198: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
199: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
200: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ending JTY_ASSIGN_BULK_PUB.get_winners...');
201:
202: COMMIT;
203:
204: EXCEPTION WHEN OTHERS THEN

Line 205: IEX_TERR_WINNERS_PUB.Print_Debug('Error in JTY_ASSIGN_BULK_PUB.get_winners for worker '|| p_worker_id ||

201:
202: COMMIT;
203:
204: EXCEPTION WHEN OTHERS THEN
205: IEX_TERR_WINNERS_PUB.Print_Debug('Error in JTY_ASSIGN_BULK_PUB.get_winners for worker '|| p_worker_id ||
206: ' '|| SQLERRM);
207: IEX_TERR_WINNERS_PUB.Print_Debug('Error buffer ' || l_errbuf);
208: END;
209: