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.JTF_TAE_ASSIGN_PUB dependencies on JTF_TAE_CONTROL_PVT

Line 144: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

140: FROM all_tables
141: WHERE owner = l_jtf_schema
142: AND table_name = p_table_name;
143:
144: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
145: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_NUM_ROWS: Number of rows for the table ' ||
146: p_table_name || ' : ' || x_num_rows);
147: End If;
148:

Line 145: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_NUM_ROWS: Number of rows for the table ' ||

141: WHERE owner = l_jtf_schema
142: AND table_name = p_table_name;
143:
144: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
145: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_NUM_ROWS: Number of rows for the table ' ||
146: p_table_name || ' : ' || x_num_rows);
147: End If;
148:
149: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 158: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
155: RETCODE := 2;
156: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_NUM_ROWS: [END] SCHEMA NAME FOUND CORRESPONDING TO JTF APPLICATION. ';
157:
158: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
159: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
160: End If;
161:
162: WHEN OTHERS THEN

Line 159: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

155: RETCODE := 2;
156: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_NUM_ROWS: [END] SCHEMA NAME FOUND CORRESPONDING TO JTF APPLICATION. ';
157:
158: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
159: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
160: End If;
161:
162: WHEN OTHERS THEN
163:

Line 169: If JTF_TAE_CONTROL_PVT.G_DEBUG Then

165: RETCODE := 2;
166: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_NUM_ROWS: [END] OTHERS: ' ||
167: p_table_name || ': ' || SQLERRM;
168:
169: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
170: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
171: End If;
172:
173:

Line 170: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

166: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_NUM_ROWS: [END] OTHERS: ' ||
167: p_table_name || ': ' || SQLERRM;
168:
169: If JTF_TAE_CONTROL_PVT.G_DEBUG Then
170: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
171: End If;
172:
173:
174: END GET_NUM_ROWS;

Line 234: JTF_TAE_CONTROL_PVT.G_DEBUG := TRUE;

230: x_return_status := FND_API.G_RET_STS_SUCCESS;
231:
232: /* If the debug flag is set, Then turn on the debug message logging */
233: If UPPER( rtrim(p_Debug_Flag) ) = 'Y' Then
234: JTF_TAE_CONTROL_PVT.G_DEBUG := TRUE;
235: End If;
236:
237: /* ARPATEL: 12/15/2003: Bug#3305019 */
238: --If UPPER(p_SQL_Trace) = 'Y' Then

Line 247: -- in the call to JTF_TAE_CONTROL_PVT.set_session_parameters below

243:
244: -- 05/16/02: JDOCHERT
245: -- Need COMMIT to avoid the following error:
246: -- ORA-12841: Cannot alter the session parallel DML state within a transaction
247: -- in the call to JTF_TAE_CONTROL_PVT.set_session_parameters below
248: ---
249: COMMIT;
250:
251: /* Standard call to check for call compatibility. */

Line 272: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

268: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MEM_TASK_START');
269: FND_MSG_PUB.Add;
270: END IF;
271:
272: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
273: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/***************** BEGIN: TERRITORY ASSIGNMENT STATUS *********************/');
274: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
275: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS start....');
276: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'source_id = ' || TO_CHAR(p_source_Id) );

Line 273: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/* BEGIN: TERRITORY ASSIGNMENT STATUS *****/');

269: FND_MSG_PUB.Add;
270: END IF;
271:
272: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
273: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/***************** BEGIN: TERRITORY ASSIGNMENT STATUS *********************/');
274: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
275: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS start....');
276: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'source_id = ' || TO_CHAR(p_source_Id) );
277: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'trans_object_type_id = ' || TO_CHAR(p_trans_object_type_id) );

Line 274: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

270: END IF;
271:
272: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
273: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/***************** BEGIN: TERRITORY ASSIGNMENT STATUS *********************/');
274: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
275: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS start....');
276: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'source_id = ' || TO_CHAR(p_source_Id) );
277: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'trans_object_type_id = ' || TO_CHAR(p_trans_object_type_id) );
278:

Line 275: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS start....');

271:
272: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
273: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/***************** BEGIN: TERRITORY ASSIGNMENT STATUS *********************/');
274: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
275: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS start....');
276: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'source_id = ' || TO_CHAR(p_source_Id) );
277: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'trans_object_type_id = ' || TO_CHAR(p_trans_object_type_id) );
278:
279: /* JDOCHERT 05/05/02: Commented out settings in JTF_TAE_CONTROL

Line 276: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'source_id = ' || TO_CHAR(p_source_Id) );

272: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
273: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/***************** BEGIN: TERRITORY ASSIGNMENT STATUS *********************/');
274: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
275: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS start....');
276: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'source_id = ' || TO_CHAR(p_source_Id) );
277: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'trans_object_type_id = ' || TO_CHAR(p_trans_object_type_id) );
278:
279: /* JDOCHERT 05/05/02: Commented out settings in JTF_TAE_CONTROL
280: ** since OSO TAP program has these paramaters

Line 277: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'trans_object_type_id = ' || TO_CHAR(p_trans_object_type_id) );

273: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/***************** BEGIN: TERRITORY ASSIGNMENT STATUS *********************/');
274: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
275: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS start....');
276: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'source_id = ' || TO_CHAR(p_source_Id) );
277: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'trans_object_type_id = ' || TO_CHAR(p_trans_object_type_id) );
278:
279: /* JDOCHERT 05/05/02: Commented out settings in JTF_TAE_CONTROL
280: ** since OSO TAP program has these paramaters
281: */

Line 282: --JTF_TAE_CONTROL_PVT.set_session_parameters

278:
279: /* JDOCHERT 05/05/02: Commented out settings in JTF_TAE_CONTROL
280: ** since OSO TAP program has these paramaters
281: */
282: --JTF_TAE_CONTROL_PVT.set_session_parameters
283: -- ( p_sort_area_size => 100000000
284: -- , p_hash_area_size => 200000000);
285:
286: -----------------------------------------------------------

Line 346: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);

342:
343: END IF; -- what usage
344:
345: /* set NOLOGGING on JTF_TAE_..._MATCHES and JTF_TAE_..._WINNERS tables */
346: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);
347:
348: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_matches_target);
349:
350: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L1_target);

Line 348: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_matches_target);

344:
345: /* set NOLOGGING on JTF_TAE_..._MATCHES and JTF_TAE_..._WINNERS tables */
346: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);
347:
348: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_matches_target);
349:
350: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L1_target);
351: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L2_target);
352: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L3_target);

Line 350: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L1_target);

346: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);
347:
348: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_matches_target);
349:
350: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L1_target);
351: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L2_target);
352: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L3_target);
353: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L4_target);
354: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L5_target);

Line 351: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L2_target);

347:
348: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_matches_target);
349:
350: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L1_target);
351: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L2_target);
352: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L3_target);
353: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L4_target);
354: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L5_target);
355: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_WT_target);

Line 352: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L3_target);

348: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_matches_target);
349:
350: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L1_target);
351: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L2_target);
352: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L3_target);
353: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L4_target);
354: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L5_target);
355: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_WT_target);
356:

Line 353: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L4_target);

349:
350: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L1_target);
351: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L2_target);
352: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L3_target);
353: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L4_target);
354: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L5_target);
355: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_WT_target);
356:
357: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winners_target);

Line 354: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L5_target);

350: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L1_target);
351: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L2_target);
352: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L3_target);
353: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L4_target);
354: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L5_target);
355: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_WT_target);
356:
357: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winners_target);
358:

Line 355: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_WT_target);

351: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L2_target);
352: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L3_target);
353: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L4_target);
354: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L5_target);
355: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_WT_target);
356:
357: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winners_target);
358:
359: -----------

Line 357: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winners_target);

353: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L4_target);
354: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L5_target);
355: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_WT_target);
356:
357: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winners_target);
358:
359: -----------
360: --- [2] ---
361: -----------

Line 362: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

358:
359: -----------
360: --- [2] ---
361: -----------
362: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
363: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [1] Call to ' ||
364: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
365: 'for ' || l_matches_target);
366:

Line 363: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [1] Call to ' ||

359: -----------
360: --- [2] ---
361: -----------
362: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
363: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [1] Call to ' ||
364: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
365: 'for ' || l_matches_target);
366:
367: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

Line 384: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

380:
381: -----------
382: --- [3] ---
383: -----------
384: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
385: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [2] Call to ' ||
386: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
387: 'for ' || l_winners_target);
388:

Line 385: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [2] Call to ' ||

381: -----------
382: --- [3] ---
383: -----------
384: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
385: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [2] Call to ' ||
386: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
387: 'for ' || l_winners_target);
388:
389: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

Line 441: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

437: WHEN NO_DATA_FOUND THEN
438: num_of_terr := 0;
439: END;
440:
441: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
442: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [3] Number of valid ' ||
443: 'Territories with Resources for this Transaction: ' ||
444: num_of_terr );
445:

Line 442: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [3] Number of valid ' ||

438: num_of_terr := 0;
439: END;
440:
441: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
442: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [3] Number of valid ' ||
443: 'Territories with Resources for this Transaction: ' ||
444: num_of_terr );
445:
446: -- 2357180: ERROR HANDLING FOR NO TERRITORY DATA:

Line 473: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

469: WHEN NO_DATA_FOUND THEN
470: num_of_trans := 0;
471: END;
472:
473: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
474: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [4] ' ||
475: 'There are valid Transaction Objects to be assigned.');
476:
477: IF (num_of_trans = 0) THEN

Line 474: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [4] ' ||

470: num_of_trans := 0;
471: END;
472:
473: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
474: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [4] ' ||
475: 'There are valid Transaction Objects to be assigned.');
476:
477: IF (num_of_trans = 0) THEN
478: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [4] There are NO valid ' ||

Line 502: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

498: EXECUTE IMMEDIATE d_statement;
499:
500: EXCEPTION
501: WHEN OTHERS THEN
502: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
503: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [4.1] ' ||
504: 'Exception while setting worker_id to 1');
505:
506: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [4.1] Exception while setting worker_id to 1.';

Line 503: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [4.1] ' ||

499:
500: EXCEPTION
501: WHEN OTHERS THEN
502: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
503: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [4.1] ' ||
504: 'Exception while setting worker_id to 1');
505:
506: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [4.1] Exception while setting worker_id to 1.';
507: RAISE NO_TAE_DATA_FOUND;

Line 513: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

509:
510: -----------
511: --- [5] ---
512: -----------
513: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
514: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [5] Call to ' ||
515: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||
516: 'for ' || l_trans_target);
517:

Line 514: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [5] Call to ' ||

510: -----------
511: --- [5] ---
512: -----------
513: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
514: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [5] Call to ' ||
515: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||
516: 'for ' || l_trans_target);
517:
518: -- Analyze _TRANS table

Line 536: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

532:
533: -----------
534: --- [6] ---
535: -----------
536: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
537: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [6] Call to ' ||
538: 'JTF_TAE_CONTROL_PVT.DECOMPOSE_TERR_DEFNS API BEGINS...');
539: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
540:

Line 537: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [6] Call to ' ||

533: -----------
534: --- [6] ---
535: -----------
536: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
537: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [6] Call to ' ||
538: 'JTF_TAE_CONTROL_PVT.DECOMPOSE_TERR_DEFNS API BEGINS...');
539: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
540:
541: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns

Line 538: 'JTF_TAE_CONTROL_PVT.DECOMPOSE_TERR_DEFNS API BEGINS...');

534: --- [6] ---
535: -----------
536: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
537: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [6] Call to ' ||
538: 'JTF_TAE_CONTROL_PVT.DECOMPOSE_TERR_DEFNS API BEGINS...');
539: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
540:
541: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns
542: (p_Api_Version_Number => 1.0,

Line 539: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

535: -----------
536: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
537: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [6] Call to ' ||
538: 'JTF_TAE_CONTROL_PVT.DECOMPOSE_TERR_DEFNS API BEGINS...');
539: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
540:
541: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns
542: (p_Api_Version_Number => 1.0,
543: p_Init_Msg_List => FND_API.G_FALSE,

Line 541: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns

537: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [6] Call to ' ||
538: 'JTF_TAE_CONTROL_PVT.DECOMPOSE_TERR_DEFNS API BEGINS...');
539: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
540:
541: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns
542: (p_Api_Version_Number => 1.0,
543: p_Init_Msg_List => FND_API.G_FALSE,
544: p_Commit => FND_API.G_FALSE,
545: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 560: 'JTF_TAE_CONTROL_PVT.DECOMPOSE_TERR_DEFNS API has failed.';

556: retcode => RETCODE );
557:
558: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
559: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [6] Call to ' ||
560: 'JTF_TAE_CONTROL_PVT.DECOMPOSE_TERR_DEFNS API has failed.';
561: RAISE FND_API.G_EXC_ERROR;
562: END IF;
563:
564: -----------

Line 567: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

563:
564: -----------
565: --- [7] ---
566: -----------
567: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
568: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [7] Call to ' ||
569: 'JTF_TAE_1001_..._DYN.SEARCH_TERR_RULES API BEGINS... ');
570:
571: -- Start MATCH processing

Line 568: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [7] Call to ' ||

564: -----------
565: --- [7] ---
566: -----------
567: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
568: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [7] Call to ' ||
569: 'JTF_TAE_1001_..._DYN.SEARCH_TERR_RULES API BEGINS... ');
570:
571: -- Start MATCH processing
572: IF (p_trans_object_type_id = -1002) THEN

Line 617: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

613:
614: -----------
615: --- [9] ---
616: -----------
617: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
618: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [9] Call to ' ||
619: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||
620: 'for ' || l_matches_target);
621:

Line 618: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [9] Call to ' ||

614: -----------
615: --- [9] ---
616: -----------
617: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
618: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [9] Call to ' ||
619: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||
620: 'for ' || l_matches_target);
621:
622: -- Analyze Matches table

Line 639: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

635:
636: -----------
637: --- [10] ---
638: -----------
639: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
640: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10] Call to ' ||
641: 'MULTI-LEVEL TABLE CLEANUP BEGINS...');
642:
643: ----dbms_output.put_line('10.1: Truncate Level Winners Tables ');

Line 640: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10] Call to ' ||

636: -----------
637: --- [10] ---
638: -----------
639: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
640: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10] Call to ' ||
641: 'MULTI-LEVEL TABLE CLEANUP BEGINS...');
642:
643: ----dbms_output.put_line('10.1: Truncate Level Winners Tables ');
644: -- 10.1: Truncate Level Winners Tables

Line 712: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

708: RAISE FND_API.G_EXC_ERROR;
709: END IF;
710:
711:
712: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
713: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [11] Call to ' ||
714: 'MULTI-LEVEL NUMBER OF WINNERS PROCESSING BEGINS...');
715:
716: --ARPATEL 09/22/03 add commit to avoid large rollback segments

Line 713: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [11] Call to ' ||

709: END IF;
710:
711:
712: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
713: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [11] Call to ' ||
714: 'MULTI-LEVEL NUMBER OF WINNERS PROCESSING BEGINS...');
715:
716: --ARPATEL 09/22/03 add commit to avoid large rollback segments
717: COMMIT;

Line 874: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [12] Call to ' ||

870:
871: --ARPATEL 09/22/03 add commit to avoid large rollback segments
872: COMMIT;
873:
874: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [12] Call to ' ||
875: 'WINNING TERRITORY RESOURCE PROCESSING BEGINS...');
876:
877: --dbms_output.put_line('12: Fetch Winners and Resources ');
878: -- 12.0: Fetch Winners and Resources

Line 1117: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

1113: x_return_status := FND_API.G_RET_STS_SUCCESS;
1114:
1115: --dbms_output.put_line(' phase 10 complete ');
1116:
1117: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1118: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Number of records inserted into ' || l_winners_target ||
1119: ' = ' || SQL%ROWCOUNT );
1120: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1121: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [12] Call to ' ||

Line 1118: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Number of records inserted into ' || l_winners_target ||

1114:
1115: --dbms_output.put_line(' phase 10 complete ');
1116:
1117: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1118: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Number of records inserted into ' || l_winners_target ||
1119: ' = ' || SQL%ROWCOUNT );
1120: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1121: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [12] Call to ' ||
1122: 'NUMBER OF WINNERS PROCESSING COMPLETE.');

Line 1120: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

1116:
1117: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1118: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Number of records inserted into ' || l_winners_target ||
1119: ' = ' || SQL%ROWCOUNT );
1120: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1121: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [12] Call to ' ||
1122: 'NUMBER OF WINNERS PROCESSING COMPLETE.');
1123:
1124: -----------

Line 1121: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [12] Call to ' ||

1117: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1118: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'Number of records inserted into ' || l_winners_target ||
1119: ' = ' || SQL%ROWCOUNT );
1120: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1121: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [12] Call to ' ||
1122: 'NUMBER OF WINNERS PROCESSING COMPLETE.');
1123:
1124: -----------
1125: --- [13] ---

Line 1127: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

1123:
1124: -----------
1125: --- [13] ---
1126: -----------
1127: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1128: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [13] Call to ' ||
1129: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
1130: 'for ' || l_winners_target);
1131:

Line 1128: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [13] Call to ' ||

1124: -----------
1125: --- [13] ---
1126: -----------
1127: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1128: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [13] Call to ' ||
1129: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
1130: 'for ' || l_winners_target);
1131:
1132: /* Build Index on Winners table */

Line 1148: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

1144:
1145: -----------
1146: --- [14] ---
1147: -----------
1148: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1149: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [14] Call to ' ||
1150: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||
1151: 'for ' || l_winners_target);
1152:

Line 1149: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [14] Call to ' ||

1145: -----------
1146: --- [14] ---
1147: -----------
1148: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1149: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [14] Call to ' ||
1150: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||
1151: 'for ' || l_winners_target);
1152:
1153: /* Analyze Winners table */

Line 1174: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

1170:
1171: --------------------------------
1172: -- END API
1173: --------------------------------
1174: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1175: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/***************** END: TERRITORY ASSIGNMENT STATUS *********************/');
1176: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1177:
1178: /* Program completed successfully */

Line 1175: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/* END: TERRITORY ASSIGNMENT STATUS *****/');

1171: --------------------------------
1172: -- END API
1173: --------------------------------
1174: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1175: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/***************** END: TERRITORY ASSIGNMENT STATUS *********************/');
1176: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1177:
1178: /* Program completed successfully */
1179: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: Successfully completed.';

Line 1176: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

1172: -- END API
1173: --------------------------------
1174: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1175: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/***************** END: TERRITORY ASSIGNMENT STATUS *********************/');
1176: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1177:
1178: /* Program completed successfully */
1179: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: Successfully completed.';
1180: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1192: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

1188:
1189: RETCODE := 1;
1190: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] NO_TAE_DATA_FOUND: ' ||
1191: SQLERRM;
1192: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1193:
1194: WHEN FND_API.G_EXC_ERROR THEN
1195:
1196: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1201: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

1197:
1198: RETCODE := 2;
1199: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] FND_API.G_EXC_ERROR: ' ||
1200: SQLERRM;
1201: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1202:
1203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1204:
1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1211: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

1207: RETCODE := 2;
1208: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: FND_API.G_EXC_UNEXPECTED_ERROR: ' ||
1209: SQLERRM;
1210:
1211: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1212:
1213: WHEN utl_file.invalid_path OR
1214: utl_file.invalid_mode OR
1215: utl_file.invalid_filehandle OR

Line 1224: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

1220: RETCODE := 2;
1221: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] UTL_FILE: ' ||
1222: SQLERRM;
1223:
1224: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1225:
1226: WHEN OTHERS THEN
1227:
1228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1233: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

1229: RETCODE := 2;
1230: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] OTHERS: ' ||
1231: SQLERRM;
1232:
1233: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1234:
1235: End Get_Winners;
1236:
1237: -- ***************************************************

Line 1348: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

1344: RETCODE := 2;
1345: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [END] ' ||
1346: 'FND_API.G_EXC_ERROR: ' ||
1347: SQLERRM;
1348: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1349:
1350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1351:
1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1358: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

1354: RETCODE := 2;
1355: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [END] ' ||
1356: 'FND_API.G_EXC_UNEXPECTED_ERROR: ' ||
1357: SQLERRM;
1358: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1359:
1360: WHEN utl_file.invalid_path OR
1361: utl_file.invalid_mode OR
1362: utl_file.invalid_filehandle OR

Line 1371: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

1367: RETCODE := 2;
1368: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [END] UTL_FILE: ' ||
1369: SQLERRM;
1370:
1371: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1372:
1373: WHEN OTHERS THEN
1374:
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1380: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

1376: RETCODE := 2;
1377: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [END] OTHERS: ' ||
1378: SQLERRM;
1379:
1380: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1381:
1382: end Drop_TAE_TRANS_Indexes;
1383:
1384: -- ***************************************************

Line 1535: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

1531:
1532: -------------
1533: --- [P01] --- TRUNCATE TRANS
1534: -------------
1535: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1536: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P01] Call to ' ||
1537: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
1538: 'for ' || l_trans_target);
1539:

Line 1536: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P01] Call to ' ||

1532: -------------
1533: --- [P01] --- TRUNCATE TRANS
1534: -------------
1535: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1536: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P01] Call to ' ||
1537: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
1538: 'for ' || l_trans_target);
1539:
1540: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

Line 1556: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

1552:
1553: -------------
1554: --- [P02] --- TRUNCATE MATCHES
1555: -------------
1556: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1557: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P02] Call to ' ||
1558: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
1559: 'for ' || l_matches_target);
1560:

Line 1557: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P02] Call to ' ||

1553: -------------
1554: --- [P02] --- TRUNCATE MATCHES
1555: -------------
1556: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1557: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P02] Call to ' ||
1558: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
1559: 'for ' || l_matches_target);
1560:
1561:

Line 1580: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

1576:
1577: -------------
1578: --- [P03] --- TRUNCATE WINNERS
1579: -------------
1580: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1581: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P03] Call to ' ||
1582: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
1583: 'for ' || l_winners_target);
1584:

Line 1581: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P03] Call to ' ||

1577: -------------
1578: --- [P03] --- TRUNCATE WINNERS
1579: -------------
1580: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1581: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P03] Call to ' ||
1582: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API BEGINS ' ||
1583: 'for ' || l_winners_target);
1584:
1585: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 1603: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

1599:
1600: -------------
1601: --- [P03.1] -
1602: -------------
1603: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1604: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||
1605: 'MULTI-LEVEL TABLE CLEANUP BEGINS...');
1606:
1607: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 1604: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||

1600: -------------
1601: --- [P03.1] -
1602: -------------
1603: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1604: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||
1605: 'MULTI-LEVEL TABLE CLEANUP BEGINS...');
1606:
1607: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1608: p_table_name => l_terr_L1_target

Line 1705: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

1701:
1702: -------------
1703: --- [P04] --- DROP INDEXES for TRANS TABLE ONLY (WE KEEP INDEXES FOR MATCHES AND WINNERS )
1704: -------------
1705: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1706: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P04] Call to ' ||
1707: 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API BEGINS ' ||
1708: 'for ' || l_trans_target);
1709:

Line 1706: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P04] Call to ' ||

1702: -------------
1703: --- [P04] --- DROP INDEXES for TRANS TABLE ONLY (WE KEEP INDEXES FOR MATCHES AND WINNERS )
1704: -------------
1705: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1706: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P04] Call to ' ||
1707: 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API BEGINS ' ||
1708: 'for ' || l_trans_target);
1709:
1710: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES( p_table_name => l_trans_target

Line 1727: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

1723: EXCEPTION
1724: WHEN FND_API.G_EXC_ERROR THEN
1725: x_return_status := FND_API.G_RET_STS_ERROR;
1726: RETCODE := 2;
1727: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1728:
1729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1731: RETCODE := 2;

Line 1732: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

1728:
1729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1731: RETCODE := 2;
1732: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1733:
1734: WHEN utl_file.invalid_path OR
1735: utl_file.invalid_mode OR
1736: utl_file.invalid_filehandle OR

Line 1744: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741: RETCODE := 2;
1742: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [END] UTL_FILE: ' ||
1743: SQLERRM;
1744: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1745:
1746: WHEN OTHERS THEN
1747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1748: RETCODE := 2;

Line 1751: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

1747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1748: RETCODE := 2;
1749: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [END] OTHERS: ' ||
1750: SQLERRM;
1751: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1752:
1753: END Clear_Trans_Data;
1754:
1755:

Line 1824: JTF_TAE_CONTROL_PVT.G_DEBUG := TRUE;

1820: x_return_status := FND_API.G_RET_STS_SUCCESS;
1821:
1822: /* If the debug flag is set, Then turn on the debug message logging */
1823: If UPPER( rtrim(p_Debug_Flag) ) = 'Y' Then
1824: JTF_TAE_CONTROL_PVT.G_DEBUG := TRUE;
1825: End If;
1826:
1827: /* ARPATEL: 12/15/2003: Bug#3305019 */
1828: --If UPPER(p_SQL_Trace) = 'Y' Then

Line 1835: -- in the call to JTF_TAE_CONTROL_PVT.set_session_parameters below

1831:
1832: -- 05/16/02: JDOCHERT
1833: -- Need COMMIT to avoid the following error:
1834: -- ORA-12841: Cannot alter the session parallel DML state within a transaction
1835: -- in the call to JTF_TAE_CONTROL_PVT.set_session_parameters below
1836: COMMIT;
1837:
1838: /* Standard call to check for call compatibility. */
1839: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1859: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

1855: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MEM_TASK_START');
1856: FND_MSG_PUB.Add;
1857: END IF;
1858:
1859: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1860: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/***************** BEGIN: TERRITORY ASSIGNMENT STATUS *********************/');
1861: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1862: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP start....');
1863: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'source_id = ' || TO_CHAR(p_source_Id) );

Line 1860: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/* BEGIN: TERRITORY ASSIGNMENT STATUS *****/');

1856: FND_MSG_PUB.Add;
1857: END IF;
1858:
1859: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1860: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/***************** BEGIN: TERRITORY ASSIGNMENT STATUS *********************/');
1861: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1862: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP start....');
1863: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'source_id = ' || TO_CHAR(p_source_Id) );
1864: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'trans_object_type_id = ' || TO_CHAR(p_trans_object_type_id) );

Line 1861: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

1857: END IF;
1858:
1859: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1860: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/***************** BEGIN: TERRITORY ASSIGNMENT STATUS *********************/');
1861: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1862: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP start....');
1863: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'source_id = ' || TO_CHAR(p_source_Id) );
1864: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'trans_object_type_id = ' || TO_CHAR(p_trans_object_type_id) );
1865:

Line 1862: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP start....');

1858:
1859: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1860: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/***************** BEGIN: TERRITORY ASSIGNMENT STATUS *********************/');
1861: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1862: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP start....');
1863: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'source_id = ' || TO_CHAR(p_source_Id) );
1864: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'trans_object_type_id = ' || TO_CHAR(p_trans_object_type_id) );
1865:
1866: /* JDOCHERT 05/05/02: Commented out settings in JTF_TAE_CONTROL

Line 1863: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'source_id = ' || TO_CHAR(p_source_Id) );

1859: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1860: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/***************** BEGIN: TERRITORY ASSIGNMENT STATUS *********************/');
1861: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1862: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP start....');
1863: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'source_id = ' || TO_CHAR(p_source_Id) );
1864: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'trans_object_type_id = ' || TO_CHAR(p_trans_object_type_id) );
1865:
1866: /* JDOCHERT 05/05/02: Commented out settings in JTF_TAE_CONTROL
1867: ** since OSO TAP program has these paramaters

Line 1864: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'trans_object_type_id = ' || TO_CHAR(p_trans_object_type_id) );

1860: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/***************** BEGIN: TERRITORY ASSIGNMENT STATUS *********************/');
1861: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
1862: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP start....');
1863: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'source_id = ' || TO_CHAR(p_source_Id) );
1864: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'trans_object_type_id = ' || TO_CHAR(p_trans_object_type_id) );
1865:
1866: /* JDOCHERT 05/05/02: Commented out settings in JTF_TAE_CONTROL
1867: ** since OSO TAP program has these paramaters
1868: */

Line 1869: --JTF_TAE_CONTROL_PVT.set_session_parameters

1865:
1866: /* JDOCHERT 05/05/02: Commented out settings in JTF_TAE_CONTROL
1867: ** since OSO TAP program has these paramaters
1868: */
1869: --JTF_TAE_CONTROL_PVT.set_session_parameters
1870: -- ( p_sort_area_size => 100000000
1871: -- , p_hash_area_size => 200000000);
1872:
1873: -----------------------------------------------------------

Line 1956: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);

1952:
1953: -- (-1 indentation)
1954:
1955: /* set NOLOGGING on JTF_TAE_..._MATCHES and JTF_TAE_..._WINNERS tables */
1956: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);
1957: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_matches_target);
1958: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winners_target);
1959:
1960: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L1_target);

Line 1957: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_matches_target);

1953: -- (-1 indentation)
1954:
1955: /* set NOLOGGING on JTF_TAE_..._MATCHES and JTF_TAE_..._WINNERS tables */
1956: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);
1957: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_matches_target);
1958: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winners_target);
1959:
1960: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L1_target);
1961: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L2_target);

Line 1958: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winners_target);

1954:
1955: /* set NOLOGGING on JTF_TAE_..._MATCHES and JTF_TAE_..._WINNERS tables */
1956: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);
1957: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_matches_target);
1958: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winners_target);
1959:
1960: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L1_target);
1961: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L2_target);
1962: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L3_target);

Line 1960: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L1_target);

1956: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_trans_target);
1957: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_matches_target);
1958: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winners_target);
1959:
1960: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L1_target);
1961: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L2_target);
1962: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L3_target);
1963: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L4_target);
1964: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L5_target);

Line 1961: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L2_target);

1957: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_matches_target);
1958: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winners_target);
1959:
1960: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L1_target);
1961: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L2_target);
1962: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L3_target);
1963: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L4_target);
1964: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L5_target);
1965: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_WT_target);

Line 1962: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L3_target);

1958: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_winners_target);
1959:
1960: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L1_target);
1961: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L2_target);
1962: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L3_target);
1963: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L4_target);
1964: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L5_target);
1965: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_WT_target);
1966:

Line 1963: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L4_target);

1959:
1960: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L1_target);
1961: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L2_target);
1962: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L3_target);
1963: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L4_target);
1964: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L5_target);
1965: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_WT_target);
1966:
1967: -------------

Line 1964: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L5_target);

1960: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L1_target);
1961: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L2_target);
1962: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L3_target);
1963: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L4_target);
1964: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L5_target);
1965: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_WT_target);
1966:
1967: -------------
1968: --- [P00] ---

Line 1965: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_WT_target);

1961: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L2_target);
1962: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L3_target);
1963: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L4_target);
1964: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_L5_target);
1965: JTF_TAE_CONTROL_PVT.set_table_nologging(p_table_name => l_terr_WT_target);
1966:
1967: -------------
1968: --- [P00] ---
1969: -------------

Line 2005: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

2001: WHEN NO_DATA_FOUND THEN
2002: num_of_terr := 0;
2003: END;
2004:
2005: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2006: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P00] Number of valid ' ||
2007: 'Territories with Resources for this Transaction: ' ||
2008: num_of_terr );
2009:

Line 2006: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P00] Number of valid ' ||

2002: num_of_terr := 0;
2003: END;
2004:
2005: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2006: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P00] Number of valid ' ||
2007: 'Territories with Resources for this Transaction: ' ||
2008: num_of_terr );
2009:
2010: /* 2357180: ERROR HANDLING FOR NO TERRITORY DATA:

Line 2035: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

2031: WHEN NO_DATA_FOUND THEN
2032: num_of_trans := 0;
2033: END;
2034:
2035: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2036: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P01] ' ||
2037: 'There are valid Transaction Objects to be assigned.');
2038:
2039: IF (num_of_trans = 0) THEN

Line 2036: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P01] ' ||

2032: num_of_trans := 0;
2033: END;
2034:
2035: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2036: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P01] ' ||
2037: 'There are valid Transaction Objects to be assigned.');
2038:
2039: IF (num_of_trans = 0) THEN
2040: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P01] There are NO valid Transaction Objects to assign.';

Line 2047: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

2043:
2044: -------------
2045: --- [P02] ---
2046: -------------
2047: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2048: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P02] Call to ' ||
2049: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||
2050: 'for ' || l_trans_target);
2051:

Line 2048: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P02] Call to ' ||

2044: -------------
2045: --- [P02] ---
2046: -------------
2047: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2048: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P02] Call to ' ||
2049: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||
2050: 'for ' || l_trans_target);
2051:
2052: /* Analyze _TRANS table */

Line 2069: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

2065:
2066: -------------
2067: --- [P03] ---
2068: -------------
2069: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2070: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03] Call to ' ||
2071: 'JTF_TAE_CONTROL_PVT.DECOMPOSE_TERR_DEFNS API BEGINS...');
2072: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2073:

Line 2070: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03] Call to ' ||

2066: -------------
2067: --- [P03] ---
2068: -------------
2069: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2070: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03] Call to ' ||
2071: 'JTF_TAE_CONTROL_PVT.DECOMPOSE_TERR_DEFNS API BEGINS...');
2072: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2073:
2074: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns

Line 2071: 'JTF_TAE_CONTROL_PVT.DECOMPOSE_TERR_DEFNS API BEGINS...');

2067: --- [P03] ---
2068: -------------
2069: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2070: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03] Call to ' ||
2071: 'JTF_TAE_CONTROL_PVT.DECOMPOSE_TERR_DEFNS API BEGINS...');
2072: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2073:
2074: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns
2075: (p_Api_Version_Number => 1.0,

Line 2072: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

2068: -------------
2069: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2070: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03] Call to ' ||
2071: 'JTF_TAE_CONTROL_PVT.DECOMPOSE_TERR_DEFNS API BEGINS...');
2072: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2073:
2074: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns
2075: (p_Api_Version_Number => 1.0,
2076: p_Init_Msg_List => FND_API.G_FALSE,

Line 2074: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns

2070: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03] Call to ' ||
2071: 'JTF_TAE_CONTROL_PVT.DECOMPOSE_TERR_DEFNS API BEGINS...');
2072: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2073:
2074: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns
2075: (p_Api_Version_Number => 1.0,
2076: p_Init_Msg_List => FND_API.G_FALSE,
2077: p_Commit => FND_API.G_FALSE,
2078: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2093: 'JTF_TAE_CONTROL_PVT.DECOMPOSE_TERR_DEFNS API has failed.';

2089: retcode => RETCODE );
2090:
2091: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2092: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03] Call to ' ||
2093: 'JTF_TAE_CONTROL_PVT.DECOMPOSE_TERR_DEFNS API has failed.';
2094: RAISE FND_API.G_EXC_ERROR;
2095: END IF;
2096:
2097:

Line 2101: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

2097:
2098: -----------
2099: --- [P04.1] ---
2100: -----------
2101: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2102: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.1] Call to ' ||
2103: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2104: 'for ' || l_matches_target);
2105:

Line 2102: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.1] Call to ' ||

2098: -----------
2099: --- [P04.1] ---
2100: -----------
2101: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2102: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.1] Call to ' ||
2103: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2104: 'for ' || l_matches_target);
2105:
2106: /* Build Index on Winners table */

Line 2120: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

2116: l_matches_target;
2117: RAISE FND_API.G_EXC_ERROR;
2118: END IF;
2119:
2120: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2121: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.2] Call to ' ||
2122: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2123: 'for ' || l_winners_target);
2124:

Line 2121: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.2] Call to ' ||

2117: RAISE FND_API.G_EXC_ERROR;
2118: END IF;
2119:
2120: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2121: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.2] Call to ' ||
2122: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2123: 'for ' || l_winners_target);
2124:
2125: /* Build Index on Winners table */

Line 2140: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

2136: RAISE FND_API.G_EXC_ERROR;
2137: END IF;
2138:
2139:
2140: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2141: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.3] Call to ' ||
2142: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2143: 'for ' || l_terr_L1_target);
2144:

Line 2141: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.3] Call to ' ||

2137: END IF;
2138:
2139:
2140: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2141: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.3] Call to ' ||
2142: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2143: 'for ' || l_terr_L1_target);
2144:
2145: /* Build Index on Winners table */

Line 2160: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

2156: RAISE FND_API.G_EXC_ERROR;
2157: END IF;
2158:
2159:
2160: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2161: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.4] Call to ' ||
2162: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2163: 'for ' || l_terr_L2_target);
2164:

Line 2161: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.4] Call to ' ||

2157: END IF;
2158:
2159:
2160: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2161: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.4] Call to ' ||
2162: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2163: 'for ' || l_terr_L2_target);
2164:
2165: /* Build Index on Winners table */

Line 2181: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

2177: END IF;
2178:
2179:
2180:
2181: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2182: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.5] Call to ' ||
2183: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2184: 'for ' || l_terr_L3_target);
2185:

Line 2182: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.5] Call to ' ||

2178:
2179:
2180:
2181: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2182: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.5] Call to ' ||
2183: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2184: 'for ' || l_terr_L3_target);
2185:
2186: /* Build Index on Winners table */

Line 2202: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

2198: END IF;
2199:
2200:
2201:
2202: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2203: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.6] Call to ' ||
2204: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2205: 'for ' || l_terr_L4_target);
2206:

Line 2203: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.6] Call to ' ||

2199:
2200:
2201:
2202: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2203: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.6] Call to ' ||
2204: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2205: 'for ' || l_terr_L4_target);
2206:
2207: /* Build Index on Winners table */

Line 2222: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

2218: RAISE FND_API.G_EXC_ERROR;
2219: END IF;
2220:
2221:
2222: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2223: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.7] Call to ' ||
2224: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2225: 'for ' || l_terr_L5_target);
2226:

Line 2223: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.7] Call to ' ||

2219: END IF;
2220:
2221:
2222: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2223: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.7] Call to ' ||
2224: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2225: 'for ' || l_terr_L5_target);
2226:
2227: /* Build Index on Winners table */

Line 2242: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

2238: RAISE FND_API.G_EXC_ERROR;
2239: END IF;
2240:
2241:
2242: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2243: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.8] Call to ' ||
2244: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2245: 'for ' || l_terr_WT_target);
2246:

Line 2243: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.8] Call to ' ||

2239: END IF;
2240:
2241:
2242: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2243: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.8] Call to ' ||
2244: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API BEGINS ' ||
2245: 'for ' || l_terr_WT_target);
2246:
2247: /* Build Index on Winners table */

Line 2266: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

2262: EXCEPTION
2263: WHEN NO_TAE_DATA_FOUND THEN
2264: x_return_status := FND_API.G_RET_STS_SUCCESS;
2265: RETCODE := 1;
2266: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
2267:
2268: WHEN FND_API.G_EXC_ERROR THEN
2269: x_return_status := FND_API.G_RET_STS_ERROR;
2270: RETCODE := 2;

Line 2271: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

2267:
2268: WHEN FND_API.G_EXC_ERROR THEN
2269: x_return_status := FND_API.G_RET_STS_ERROR;
2270: RETCODE := 2;
2271: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
2272:
2273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2275: RETCODE := 2;

Line 2276: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

2272:
2273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2275: RETCODE := 2;
2276: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
2277:
2278: WHEN utl_file.invalid_path OR
2279: utl_file.invalid_mode OR
2280: utl_file.invalid_filehandle OR

Line 2287: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

2283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2284: RETCODE := 2;
2285: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [END] UTL_FILE: ' ||
2286: SQLERRM;
2287: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
2288: WHEN OTHERS THEN
2289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2290: RETCODE := 2;
2291: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [END] OTHERS: ' ||

Line 2293: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

2289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2290: RETCODE := 2;
2291: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [END] OTHERS: ' ||
2292: SQLERRM;
2293: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
2294:
2295: END get_winners_parallel_setup;
2296:
2297:

Line 2371: JTF_TAE_CONTROL_PVT.G_DEBUG := TRUE;

2367: x_return_status := FND_API.G_RET_STS_SUCCESS;
2368:
2369: /* If the debug flag is set, Then turn on the debug message logging */
2370: If UPPER( rtrim(p_Debug_Flag) ) = 'Y' Then
2371: JTF_TAE_CONTROL_PVT.G_DEBUG := TRUE;
2372: End If;
2373:
2374: /* ARPATEL: 12/15/2003: Bug#3305019 */
2375: --If UPPER(p_SQL_Trace) = 'Y' Then

Line 2461: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

2457:
2458: -------------
2459: --- [P00] --- DO ANY TRANSACTIONS EXIST FOR THIS WORKER?
2460: -------------
2461: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2462: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||
2463: p_worker_id ||
2464: ' [P00] Check if accounts exist for this worker... ');
2465: BEGIN

Line 2462: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||

2458: -------------
2459: --- [P00] --- DO ANY TRANSACTIONS EXIST FOR THIS WORKER?
2460: -------------
2461: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2462: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||
2463: p_worker_id ||
2464: ' [P00] Check if accounts exist for this worker... ');
2465: BEGIN
2466:

Line 2477: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||

2473: l_num_of_trans := 0;
2474: END;
2475:
2476: IF (l_num_of_trans = 0) THEN
2477: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||
2478: p_worker_id ||
2479: ' [P00] NO TRANSACTIONS EXIST FOR THIS WORKER...Quitting.');
2480: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: worker_id= ' || p_worker_id ||
2481: ' [P00] There are NO valid Transaction Objects to assign.';

Line 2488: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

2484:
2485: -------------
2486: --- [P01] --- CALL DYN PACKAGE
2487: -------------
2488: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2489: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||
2490: p_worker_id ||
2491: ' [P01] Call to ' ||
2492: 'JTF_TAE_1001_..._DYN.SEARCH_TERR_RULES API BEGINS... ');

Line 2489: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||

2485: -------------
2486: --- [P01] --- CALL DYN PACKAGE
2487: -------------
2488: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2489: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||
2490: p_worker_id ||
2491: ' [P01] Call to ' ||
2492: 'JTF_TAE_1001_..._DYN.SEARCH_TERR_RULES API BEGINS... ');
2493:

Line 2582: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

2578:
2579: -------------
2580: --- [P02] --- ANALYZE MATCHES TABLE
2581: -------------
2582: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2583: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||
2584: p_worker_id ||
2585: '[P02] Call to ' ||
2586: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||

Line 2583: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||

2579: -------------
2580: --- [P02] --- ANALYZE MATCHES TABLE
2581: -------------
2582: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2583: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||
2584: p_worker_id ||
2585: '[P02] Call to ' ||
2586: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||
2587: 'for ' || l_matches_target);

Line 2613: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

2609:
2610: --ARPATEL 09/22/03 add commit to avoid large rollback segments
2611: COMMIT;
2612:
2613: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2614: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P03] Call to ' ||
2615: 'PARALLEL MULTI_VARIABLE NUMBER OF WINNERS PROCESSING BEGINS...');
2616:
2617: --dbms_output.put_line('10.2: Process Level Winners ');

Line 2614: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P03] Call to ' ||

2610: --ARPATEL 09/22/03 add commit to avoid large rollback segments
2611: COMMIT;
2612:
2613: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2614: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P03] Call to ' ||
2615: 'PARALLEL MULTI_VARIABLE NUMBER OF WINNERS PROCESSING BEGINS...');
2616:
2617: --dbms_output.put_line('10.2: Process Level Winners ');
2618: -- 11: Process Level Winners

Line 2779: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

2775:
2776: -------------
2777: --- [P03] --- MULTI-LEVEL NUMBER OF WINNERS PROCESSING
2778: -------------
2779: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2780: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||
2781: p_worker_id ||
2782: '[P03] Call to ' ||
2783: 'NUMBER OF WINNERS PROCESSING BEGINS...');

Line 2780: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||

2776: -------------
2777: --- [P03] --- MULTI-LEVEL NUMBER OF WINNERS PROCESSING
2778: -------------
2779: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
2780: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||
2781: p_worker_id ||
2782: '[P03] Call to ' ||
2783: 'NUMBER OF WINNERS PROCESSING BEGINS...');
2784:

Line 3057: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

3053: END;
3054:
3055: x_return_status := FND_API.G_RET_STS_SUCCESS;
3056:
3057: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
3058: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||
3059: p_worker_id ||
3060: 'Number of records inserted into ' || l_winners_target ||
3061: ' = ' || SQL%ROWCOUNT );

Line 3058: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||

3054:
3055: x_return_status := FND_API.G_RET_STS_SUCCESS;
3056:
3057: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
3058: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||
3059: p_worker_id ||
3060: 'Number of records inserted into ' || l_winners_target ||
3061: ' = ' || SQL%ROWCOUNT );
3062: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

Line 3062: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

3058: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||
3059: p_worker_id ||
3060: 'Number of records inserted into ' || l_winners_target ||
3061: ' = ' || SQL%ROWCOUNT );
3062: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
3063: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||
3064: p_worker_id || '[P03] Call to ' ||
3065: 'NUMBER OF WINNERS PROCESSING COMPLETE.');
3066:

Line 3063: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||

3059: p_worker_id ||
3060: 'Number of records inserted into ' || l_winners_target ||
3061: ' = ' || SQL%ROWCOUNT );
3062: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
3063: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||
3064: p_worker_id || '[P03] Call to ' ||
3065: 'NUMBER OF WINNERS PROCESSING COMPLETE.');
3066:
3067:

Line 3071: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

3067:
3068: -------------
3069: --- [P04] --- ANALYZE WINNERS TABLE
3070: -------------
3071: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
3072: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: [P05] Call to ' ||
3073: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||
3074: 'for ' || l_winners_target);
3075:

Line 3072: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: [P05] Call to ' ||

3068: -------------
3069: --- [P04] --- ANALYZE WINNERS TABLE
3070: -------------
3071: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
3072: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: [P05] Call to ' ||
3073: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API BEGINS ' ||
3074: 'for ' || l_winners_target);
3075:
3076: /* Analyze Winners table */

Line 3093: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

3089:
3090: --------------------------------
3091: -- END API
3092: --------------------------------
3093: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
3094: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/***************** END: TERRITORY ASSIGNMENT STATUS *********************/');
3095: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
3096:
3097: /* Program completed successfully */

Line 3094: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/* END: TERRITORY ASSIGNMENT STATUS *****/');

3090: --------------------------------
3091: -- END API
3092: --------------------------------
3093: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
3094: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/***************** END: TERRITORY ASSIGNMENT STATUS *********************/');
3095: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
3096:
3097: /* Program completed successfully */
3098: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: Successfully completed.';

Line 3095: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

3091: -- END API
3092: --------------------------------
3093: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
3094: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, '/***************** END: TERRITORY ASSIGNMENT STATUS *********************/');
3095: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
3096:
3097: /* Program completed successfully */
3098: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: Successfully completed.';
3099: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3107: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

3103:
3104: WHEN NO_TAE_DATA_FOUND THEN
3105: x_return_status := FND_API.G_RET_STS_SUCCESS;
3106: RETCODE := 1;
3107: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3108:
3109: WHEN FND_API.G_EXC_ERROR THEN
3110: x_return_status := FND_API.G_RET_STS_ERROR;
3111: RETCODE := 2;

Line 3112: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

3108:
3109: WHEN FND_API.G_EXC_ERROR THEN
3110: x_return_status := FND_API.G_RET_STS_ERROR;
3111: RETCODE := 2;
3112: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3113:
3114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3116: RETCODE := 2;

Line 3117: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

3113:
3114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3116: RETCODE := 2;
3117: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3118:
3119: WHEN utl_file.invalid_path OR
3120: utl_file.invalid_mode OR
3121: utl_file.invalid_filehandle OR

Line 3128: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

3124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3125: RETCODE := 2;
3126: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: [END] UTL_FILE: ' ||
3127: SQLERRM;
3128: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3129:
3130: WHEN OTHERS THEN
3131:
3132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3137: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

3133: RETCODE := 2;
3134: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: [END] OTHERS: ' ||
3135: SQLERRM;
3136:
3137: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3138:
3139: END GET_WINNERS_PARALLEL;
3140:
3141: -- ***************************************************

Line 3627: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

3623: '[END] FND_API.G_RET_STS_ERROR: ' ||
3624: 'UPPER LEVEL = ' || p_UPPER_LEVEL_FROM_ROOT || ' ' ||
3625: 'LOWER LEVEL = ' || p_LOWER_LEVEL_FROM_ROOT || ' :' ||
3626: SQLERRM;
3627: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3628:
3629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3630:
3631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3637: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

3633: '[END] FND_API.G_EXC_UNEXPECTED_ERROR: ' ||
3634: 'UPPER LEVEL = ' || p_UPPER_LEVEL_FROM_ROOT || ' ' ||
3635: 'LOWER LEVEL = ' || p_LOWER_LEVEL_FROM_ROOT || ' :' ||
3636: SQLERRM;
3637: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3638:
3639: WHEN utl_file.invalid_path OR
3640: utl_file.invalid_mode OR
3641: utl_file.invalid_filehandle OR

Line 3650: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

3646: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] UTL_FILE: ' ||
3647: 'UPPER LEVEL = ' || p_UPPER_LEVEL_FROM_ROOT || ' ' ||
3648: 'LOWER LEVEL = ' || p_LOWER_LEVEL_FROM_ROOT || ' :' ||
3649: SQLERRM;
3650: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3651:
3652: WHEN OTHERS THEN
3653:
3654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3660: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

3656: 'UPPER LEVEL = ' || p_UPPER_LEVEL_FROM_ROOT || ' ' ||
3657: 'LOWER LEVEL = ' || p_LOWER_LEVEL_FROM_ROOT || ' :' ||
3658: SQLERRM;
3659:
3660: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3661:
3662: END Process_Level_Winners;
3663:
3664:

Line 3809: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

3805: x_return_status := FND_API.G_RET_STS_ERROR;
3806: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Final_Level_Winners: ' ||
3807: '[END] FND_API.G_RET_STS_ERROR: ' ||
3808: SQLERRM;
3809: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3810:
3811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3812:
3813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3817: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

3813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3814: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Final_Level_Winners: ' ||
3815: '[END] FND_API.G_EXC_UNEXPECTED_ERROR: ' ||
3816: SQLERRM;
3817: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3818:
3819: WHEN utl_file.invalid_path OR
3820: utl_file.invalid_mode OR
3821: utl_file.invalid_filehandle OR

Line 3828: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

3824:
3825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3826: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Final_Level_Winners: [END] UTL_FILE: ' ||
3827: SQLERRM;
3828: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3829:
3830: WHEN OTHERS THEN
3831:
3832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3835: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

3831:
3832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3833: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Final_Level_Winners: [END] OTHERS: ' ||
3834: SQLERRM;
3835: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3836:
3837: END Process_Final_Level_Winners;
3838:
3839:

Line 4005: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

4001:
4002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4003: ERRBUF := 'JTF_TAE_ASSIGN_PUB.TABLE_TRUNCATE_DROP_INDEX: [END] OTHERS: ' ||
4004: SQLERRM;
4005: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
4006: END NM_TABLE_TRUNCATE_DROP_INDEX;
4007:
4008:
4009: -- ***************************************************

Line 4038: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

4034: AS
4035: BEGIN
4036:
4037: --dbms_output.put_line('JTF_TAE_ASSIGN_PUB.FETCH_NM_REASSIGN_TRANS START');
4038: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
4039: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.FETCH_NM_REASSIGN_TRANS: Begins... ');
4040:
4041:
4042: -- Clear Matches, Winners, and Level tables

Line 4039: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.FETCH_NM_REASSIGN_TRANS: Begins... ');

4035: BEGIN
4036:
4037: --dbms_output.put_line('JTF_TAE_ASSIGN_PUB.FETCH_NM_REASSIGN_TRANS START');
4038: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');
4039: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, 'JTF_TAE_ASSIGN_PUB.FETCH_NM_REASSIGN_TRANS: Begins... ');
4040:
4041:
4042: -- Clear Matches, Winners, and Level tables
4043:

Line 4106: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

4102:
4103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4104: ERRBUF := 'JTF_TAE_ASSIGN_PUB.FETCH_NM_REASSIGN_TRANS: [END] OTHERS: ' ||
4105: SQLERRM;
4106: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
4107:
4108:
4109: END FETCH_NM_REASSIGN_TRANS;
4110:

Line 4150: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

4146:
4147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4148: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DELETE_CHANGED_TERR_RECS: [END] OTHERS: ' ||
4149: SQLERRM;
4150: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
4151: END DELETE_CHANGED_TERR_RECS;
4152:
4153: END JTF_TAE_ASSIGN_PUB;
4154: