DBA Data[Home] [Help]

APPS.IEX_GAR_PUB dependencies on FND_FILE

Line 173: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');

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...');
175:
176: JTY_ASSIGN_BULK_PUB.get_winners(
177: p_api_version_number => 1.0,

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 199: FND_FILE.PUT_LINE(FND_FILE.LOG,'---' || l_date_str || '--------------------------');

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 || '--------------------------');
200: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ending JTY_ASSIGN_BULK_PUB.get_winners...');
201:
202: COMMIT;
203:

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 213: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number of records in jtf_tae_1600_cust_winners : ' || l_acc_count );

209:
210: SELECT count(*) INTO l_acc_count FROM jtf_tae_1600_cust_winners;
211: IEX_TERR_WINNERS_PUB.Print_Debug('Number of records in jtf_tae_1600_cust_winners : ' || l_acc_count );
212:
213: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number of records in jtf_tae_1600_cust_winners : ' || l_acc_count );
214: --
215:
216: -- Set the Session parameters
217: IEX_ATA_PUB.Set_Area_Sizes;