DBA Data[Home] [Help]

APPS.IEX_ATA_PUB dependencies on JTY_ASSIGN_BULK_PUB

Line 267: IEX_DEBUG('Starting JTY_ASSIGN_BULK_PUB.collect_trans_data...');

263: l_percent_analysed :=nvl(TO_NUMBER(fnd_profile.value('IEX_TAP_PERCENT_ANALYSED')),20);
264: l_target_type := 'TOTAL';
265:
266: BEGIN
267: IEX_DEBUG('Starting JTY_ASSIGN_BULK_PUB.collect_trans_data...');
268: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
269: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
270: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting JTY_ASSIGN_BULK_PUB.collect_trans_data...');
271:

Line 270: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting JTY_ASSIGN_BULK_PUB.collect_trans_data...');

266: BEGIN
267: IEX_DEBUG('Starting JTY_ASSIGN_BULK_PUB.collect_trans_data...');
268: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
269: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
270: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting JTY_ASSIGN_BULK_PUB.collect_trans_data...');
271:
272: JTY_ASSIGN_BULK_PUB.collect_trans_data(
273: p_api_version_number => 1.0,
274: p_init_msg_list => FND_API.G_FALSE,

Line 272: JTY_ASSIGN_BULK_PUB.collect_trans_data(

268: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
269: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
270: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting JTY_ASSIGN_BULK_PUB.collect_trans_data...');
271:
272: JTY_ASSIGN_BULK_PUB.collect_trans_data(
273: p_api_version_number => 1.0,
274: p_init_msg_list => FND_API.G_FALSE,
275: p_source_id => -1600,
276: p_trans_id => -1601,

Line 288: IEX_DEBUG('Completed JTY_ASSIGN_BULK_PUB.collect_trans_data with status ' || l_return_status);

284: x_msg_count => lx_msg_count,
285: x_msg_data => lx_msg_data,
286: ERRBUF => lx_errbuf,
287: RETCODE => lx_retcode);
288: IEX_DEBUG('Completed JTY_ASSIGN_BULK_PUB.collect_trans_data with status ' || l_return_status);
289: IEX_DEBUG('Message from JTY_ASSIGN_BULK_PUB.collect_trans_data ' ||lx_msg_data);
290: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
291: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
292: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ending JTY_ASSIGN_BULK_PUB.collect_trans_data...');

Line 289: IEX_DEBUG('Message from JTY_ASSIGN_BULK_PUB.collect_trans_data ' ||lx_msg_data);

285: x_msg_data => lx_msg_data,
286: ERRBUF => lx_errbuf,
287: RETCODE => lx_retcode);
288: IEX_DEBUG('Completed JTY_ASSIGN_BULK_PUB.collect_trans_data with status ' || l_return_status);
289: IEX_DEBUG('Message from JTY_ASSIGN_BULK_PUB.collect_trans_data ' ||lx_msg_data);
290: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
291: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
292: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ending JTY_ASSIGN_BULK_PUB.collect_trans_data...');
293: EXCEPTION WHEN OTHERS THEN

Line 292: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ending JTY_ASSIGN_BULK_PUB.collect_trans_data...');

288: IEX_DEBUG('Completed JTY_ASSIGN_BULK_PUB.collect_trans_data with status ' || l_return_status);
289: IEX_DEBUG('Message from JTY_ASSIGN_BULK_PUB.collect_trans_data ' ||lx_msg_data);
290: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
291: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
292: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ending JTY_ASSIGN_BULK_PUB.collect_trans_data...');
293: EXCEPTION WHEN OTHERS THEN
294: IEX_DEBUG('Error occured JTY_ASSIGN_BULK_PUB.collect_trans_data' ||SQLERRM);
295: IEX_DEBUG('Error buffer ' || lx_errbuf);
296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error occured JTY_ASSIGN_BULK_PUB.collect_trans_data' ||SQLERRM);

Line 294: IEX_DEBUG('Error occured JTY_ASSIGN_BULK_PUB.collect_trans_data' ||SQLERRM);

290: select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;
291: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');
292: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ending JTY_ASSIGN_BULK_PUB.collect_trans_data...');
293: EXCEPTION WHEN OTHERS THEN
294: IEX_DEBUG('Error occured JTY_ASSIGN_BULK_PUB.collect_trans_data' ||SQLERRM);
295: IEX_DEBUG('Error buffer ' || lx_errbuf);
296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error occured JTY_ASSIGN_BULK_PUB.collect_trans_data' ||SQLERRM);
297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error buffer ' || lx_errbuf);
298: END;

Line 296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error occured JTY_ASSIGN_BULK_PUB.collect_trans_data' ||SQLERRM);

292: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ending JTY_ASSIGN_BULK_PUB.collect_trans_data...');
293: EXCEPTION WHEN OTHERS THEN
294: IEX_DEBUG('Error occured JTY_ASSIGN_BULK_PUB.collect_trans_data' ||SQLERRM);
295: IEX_DEBUG('Error buffer ' || lx_errbuf);
296: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error occured JTY_ASSIGN_BULK_PUB.collect_trans_data' ||SQLERRM);
297: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error buffer ' || lx_errbuf);
298: END;
299:
300: