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_ASSIGN_PUB

Line 1: Package Body JTF_TAE_ASSIGN_PUB AS

1: Package Body JTF_TAE_ASSIGN_PUB AS
2: /* $Header: jtftaeab.pls 120.0 2005/06/02 18:21:08 appldev ship $ */
3: ---------------------------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------

Line 6: -- PACKAGE NAME: JTF_TAE_ASSIGN_PUB

2: /* $Header: jtftaeab.pls 120.0 2005/06/02 18:21:08 appldev ship $ */
3: ---------------------------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------
6: -- PACKAGE NAME: JTF_TAE_ASSIGN_PUB
7: -- ---------------------------------------------------
8: -- PURPOSE
9: -- Joint task force applications territory manager public api's.
10: -- This package is a public API for getting winning territories

Line 65: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TAE_ASSIGN_PUB';

61: -- ***************************************************
62: -- GLOBAL VARIABLES and RECORD TYPE DEFINITIONS
63: -- ***************************************************
64:
65: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TAE_ASSIGN_PUB';
66: G_FILE_NAME CONSTANT VARCHAR2(12):='jtftaeab.pls';
67:
68: G_NEW_LINE VARCHAR2(02) := fnd_global.local_chr(10);
69: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;

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 156: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_NUM_ROWS: [END] SCHEMA NAME FOUND CORRESPONDING TO JTF APPLICATION. ';

152: WHEN L_SCHEMA_NOTFOUND THEN
153:
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;

Line 166: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_NUM_ROWS: [END] OTHERS: ' ||

162: WHEN OTHERS THEN
163:
164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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);

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 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 373: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [1] Call to ' ||

369: , x_return_status => x_return_status );
370:
371: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
372:
373: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [1] Call to ' ||
374: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
375: l_matches_target;
376:
377: RAISE FND_API.G_EXC_ERROR;

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 395: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [2] Call to ' ||

391: , x_return_status => x_return_status );
392:
393: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
394:
395: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [2] Call to ' ||
396: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
397: l_winners_target;
398:
399: RAISE FND_API.G_EXC_ERROR;

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 450: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [3] There are NO Active Territories with Active ' ||

446: -- 2357180: ERROR HANDLING FOR NO TERRITORY DATA:
447: -- AFTER MATCHES AND WINNERS TABLES HAVE BEEN TRUNCATED
448: IF (num_of_terr = 0) THEN
449:
450: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [3] There are NO Active Territories with Active ' ||
451: 'Resources existing for this Usage/Transaction combination, so no assignments ' ||
452: 'can take place.';
453:
454: RAISE NO_TAE_DATA_FOUND;

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 478: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [4] There are NO valid ' ||

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 ' ||
479: 'Transaction Objects to assign.';
480: RAISE NO_TAE_DATA_FOUND;
481: END IF;
482:

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 506: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [4.1] Exception while setting worker_id to 1.';

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;
508: END;
509:
510: -----------

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 526: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [5] Call to ' ||

522: , p_percent => 99
523: , x_return_status => x_return_status );
524:
525: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
526: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [5] Call to ' ||
527: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' ||
528: l_trans_target;
529: RAISE FND_API.G_EXC_ERROR;
530: END IF;

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 559: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [6] Call to ' ||

555: errbuf => ERRBUF,
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:

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 602: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [7] Call to ' ||

598:
599: END IF; -- what tx type
600:
601: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
602: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [7] Call to ' ||
603: 'JTF_TAE_1001_..._DYN.SEARCH_TERR_RULES API has failed.';
604: RAISE FND_API.G_EXC_ERROR;
605: END IF;
606:

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 630: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [9] Call to ' ||

626: , p_percent => 20
627: , x_return_status => x_return_status );
628:
629: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
630: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [9] Call to ' ||
631: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' ||
632: l_matches_target;
633: RAISE FND_API.G_EXC_ERROR;
634: END IF;

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 650: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10.1] Call to ' ||

646: p_table_name => l_terr_L1_target
647: , x_return_status => x_return_status );
648:
649: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
650: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10.1] Call to ' ||
651: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
652: l_terr_L1_target;
653: RAISE FND_API.G_EXC_ERROR;
654: END IF;

Line 661: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10.2] Call to ' ||

657: p_table_name => l_terr_L2_target
658: , x_return_status => x_return_status );
659:
660: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
661: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10.2] Call to ' ||
662: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
663: l_terr_L2_target;
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;

Line 672: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10.3] Call to ' ||

668: p_table_name => l_terr_L3_target
669: , x_return_status => x_return_status );
670:
671: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
672: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10.3] Call to ' ||
673: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
674: l_terr_L3_target;
675: RAISE FND_API.G_EXC_ERROR;
676: END IF;

Line 683: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10.4] Call to ' ||

679: p_table_name => l_terr_L4_target
680: , x_return_status => x_return_status );
681:
682: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
683: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10.4] Call to ' ||
684: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
685: l_terr_L4_target;
686: RAISE FND_API.G_EXC_ERROR;
687: END IF;

Line 694: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10.5] Call to ' ||

690: p_table_name => l_terr_L5_target
691: , x_return_status => x_return_status );
692:
693: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
694: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10.5] Call to ' ||
695: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
696: l_terr_L5_target;
697: RAISE FND_API.G_EXC_ERROR;
698: END IF;

Line 705: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10.6] Call to ' ||

701: p_table_name => l_terr_WT_target
702: , x_return_status => x_return_status );
703:
704: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
705: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [10.6] Call to ' ||
706: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
707: l_terr_WT_target;
708: RAISE FND_API.G_EXC_ERROR;
709: END IF;

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 734: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.1] Call to ' ||

730: p_worker_id => 1
731: );
732:
733: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
734: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.1] Call to ' ||
735: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
736: l_terr_L1_target;
737: RAISE FND_API.G_EXC_ERROR;
738: END IF;

Line 760: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.2] Call to ' ||

756: p_worker_id => 1
757: );
758:
759: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
760: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.2] Call to ' ||
761: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
762: l_terr_L2_target;
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;

Line 785: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.3] Call to ' ||

781: p_worker_id => 1
782: );
783:
784: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
785: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.3] Call to ' ||
786: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
787: l_terr_L3_target;
788: RAISE FND_API.G_EXC_ERROR;
789: END IF;

Line 810: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.4] Call to ' ||

806: p_worker_id => 1
807: );
808:
809: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
810: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.4] Call to ' ||
811: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
812: l_terr_L4_target;
813: RAISE FND_API.G_EXC_ERROR;
814: END IF;

Line 835: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.5] Call to ' ||

831: p_worker_id => 1
832: );
833:
834: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
835: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.5] Call to ' ||
836: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
837: l_terr_L5_target;
838: RAISE FND_API.G_EXC_ERROR;
839: END IF;

Line 860: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.6] Call to ' ||

856: p_worker_id => 1
857: );
858:
859: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
860: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.6] Call to ' ||
861: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
862: l_terr_WT_target;
863: RAISE FND_API.G_EXC_ERROR;
864: END IF;

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 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 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 1139: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [13] Call to ' ||

1135: , p_source_id
1136: , l_return_status );
1137:
1138: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1139: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [13] Call to ' ||
1140: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||
1141: l_winners_target;
1142: RAISE FND_API.G_EXC_ERROR;
1143: END IF;

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 1161: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [14] Call to ' ||

1157: , p_percent => 20
1158: , x_return_status => x_return_status );
1159:
1160: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1161: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [14] Call to ' ||
1162: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' ||
1163: l_winners_target;
1164: RAISE FND_API.G_EXC_ERROR;
1165: END IF;

Line 1179: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: Successfully completed.';

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;
1181: RETCODE := 0;
1182:
1183: EXCEPTION

Line 1190: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] NO_TAE_DATA_FOUND: ' ||

1186:
1187: x_return_status := FND_API.G_RET_STS_SUCCESS;
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

Line 1199: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] FND_API.G_EXC_ERROR: ' ||

1195:
1196: x_return_status := FND_API.G_RET_STS_ERROR;
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

Line 1208: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: FND_API.G_EXC_UNEXPECTED_ERROR: ' ||

1204:
1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1206:
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:

Line 1221: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] UTL_FILE: ' ||

1217: utl_file.write_error THEN
1218:
1219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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:

Line 1230: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] OTHERS: ' ||

1226: WHEN OTHERS THEN
1227:
1228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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:

Line 1298: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [1] Call to ' ||

1294: , x_return_status => x_return_status );
1295:
1296: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1297:
1298: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [1] Call to ' ||
1299: 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' ||
1300: l_trans_target;
1301:
1302: RAISE FND_API.G_EXC_ERROR;

Line 1312: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [2] Call to ' ||

1308:
1309: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1310:
1311:
1312: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [2] Call to ' ||
1313: 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' ||
1314: l_matches_target;
1315:
1316: RAISE FND_API.G_EXC_ERROR;

Line 1326: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [3] Call to ' ||

1322:
1323: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1324:
1325:
1326: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [3] Call to ' ||
1327: 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' ||
1328: l_winners_target;
1329:
1330: RAISE FND_API.G_EXC_ERROR;

Line 1335: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: Successfully completed.';

1331:
1332: END IF;
1333:
1334: /* Program completed successfully */
1335: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: Successfully completed.';
1336: x_return_status := FND_API.G_RET_STS_SUCCESS;
1337: RETCODE := 0;
1338:
1339: EXCEPTION

Line 1345: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [END] ' ||

1341: WHEN FND_API.G_EXC_ERROR THEN
1342: x_return_status := FND_API.G_RET_STS_ERROR;
1343:
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:

Line 1355: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [END] ' ||

1351:
1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1353:
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:

Line 1368: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [END] UTL_FILE: ' ||

1364: utl_file.write_error THEN
1365:
1366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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:

Line 1377: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [END] OTHERS: ' ||

1373: WHEN OTHERS THEN
1374:
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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:

Line 1420: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_SQL_FOR_CHANGES: Successfully completed.';

1416: );
1417: --dbms_output.put_line('JTF_TAE_GEN_PVT.gen_details_for_terr_change returned');
1418:
1419: /* Program completed successfully */
1420: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_SQL_FOR_CHANGES: Successfully completed.';
1421: x_return_status := FND_API.G_RET_STS_SUCCESS;
1422: RETCODE := 0;
1423:
1424: EXCEPTION

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 1545: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P01] Call to ' ||

1541: p_table_name => l_trans_target
1542: , x_return_status => x_return_status );
1543:
1544: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1545: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P01] Call to ' ||
1546: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
1547: l_trans_target;
1548:
1549: RAISE FND_API.G_EXC_ERROR;

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 1571: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P02] Call to ' ||

1567: p_table_name => l_matches_target
1568: , x_return_status => x_return_status );
1569:
1570: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1571: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P02] Call to ' ||
1572: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
1573: l_matches_target;
1574: RAISE FND_API.G_EXC_ERROR;
1575: END IF;

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 1594: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P03] Call to ' ||

1590: p_table_name => l_winners_target
1591: , x_return_status => x_return_status );
1592:
1593: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1594: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P03] Call to ' ||
1595: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
1596: l_winners_target;
1597: RAISE FND_API.G_EXC_ERROR;
1598: END IF;

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 1618: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||

1614: p_table_name => l_terr_L1_target
1615: , x_return_status => x_return_status );
1616:
1617: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1618: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||
1619: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
1620: l_terr_L1_target;
1621: RAISE FND_API.G_EXC_ERROR;
1622: END IF;

Line 1633: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||

1629: p_table_name => l_terr_L2_target
1630: , x_return_status => x_return_status );
1631:
1632: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1633: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||
1634: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
1635: l_terr_L2_target;
1636: RAISE FND_API.G_EXC_ERROR;
1637: END IF;

Line 1649: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||

1645: p_table_name => l_terr_L3_target
1646: , x_return_status => x_return_status );
1647:
1648: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1649: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||
1650: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
1651: l_terr_L3_target;
1652: RAISE FND_API.G_EXC_ERROR;
1653: END IF;

Line 1664: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||

1660: p_table_name => l_terr_L4_target
1661: , x_return_status => x_return_status );
1662:
1663: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1664: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||
1665: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
1666: l_terr_L4_target;
1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;

Line 1680: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||

1676: p_table_name => l_terr_L5_target
1677: , x_return_status => x_return_status );
1678:
1679: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1680: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||
1681: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
1682: l_terr_L5_target;
1683: RAISE FND_API.G_EXC_ERROR;
1684: END IF;

Line 1696: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||

1692: p_table_name => l_terr_WT_target
1693: , x_return_status => x_return_status );
1694:
1695: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1696: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03.1] Call to ' ||
1697: 'JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' ||
1698: l_terr_WT_target;
1699: RAISE FND_API.G_EXC_ERROR;
1700: END IF;

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 1715: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P04] Call to ' ||

1711: , x_return_status => x_return_status );
1712:
1713: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1714:
1715: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [P04] Call to ' ||
1716: 'JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' ||
1717: l_trans_target;
1718:
1719: RAISE FND_API.G_EXC_ERROR;

Line 1742: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [END] UTL_FILE: ' ||

1738: utl_file.write_error THEN
1739:
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

Line 1749: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [END] OTHERS: ' ||

1745:
1746: WHEN OTHERS THEN
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;

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 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 2013: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P00] There are NO Active Territories with Active ' ||

2009:
2010: /* 2357180: ERROR HANDLING FOR NO TERRITORY DATA:
2011: ** AFTER MATCHES AND WINNERS TABLES HAVE BEEN TRUNCATED */
2012: IF (num_of_terr = 0) THEN
2013: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P00] There are NO Active Territories with Active ' ||
2014: 'Resources existing for this Usage/Transaction combination, so no assignments ' ||
2015: 'can take place.';
2016:
2017: RAISE NO_TAE_DATA_FOUND;

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 2040: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P01] There are NO valid Transaction Objects to assign.';

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.';
2041: RAISE NO_TAE_DATA_FOUND;
2042: END IF;
2043:
2044: -------------

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 2060: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P02] Call to ' ||

2056: , p_percent => 99
2057: , x_return_status => x_return_status );
2058:
2059: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2060: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P02] Call to ' ||
2061: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' ||
2062: l_trans_target;
2063: RAISE FND_API.G_EXC_ERROR;
2064: END IF;

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 2092: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [P03] Call to ' ||

2088: errbuf => ERRBUF,
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:

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 2114: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.1] Call to ' ||

2110: , l_return_status
2111: , p_target_type);
2112:
2113: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2114: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.1] Call to ' ||
2115: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||
2116: l_matches_target;
2117: RAISE FND_API.G_EXC_ERROR;
2118: END IF;

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 2133: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.2] Call to ' ||

2129: , l_return_status
2130: , p_target_type );
2131:
2132: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2133: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.2] Call to ' ||
2134: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||
2135: l_winners_target;
2136: RAISE FND_API.G_EXC_ERROR;
2137: END IF;

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 2153: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.3] Call to ' ||

2149: , l_return_status
2150: , p_target_type );
2151:
2152: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2153: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.3] Call to ' ||
2154: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||
2155: l_terr_L1_target;
2156: RAISE FND_API.G_EXC_ERROR;
2157: END IF;

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 2173: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.4] Call to ' ||

2169: , l_return_status
2170: , p_target_type );
2171:
2172: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2173: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.4] Call to ' ||
2174: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||
2175: l_terr_L2_target;
2176: RAISE FND_API.G_EXC_ERROR;
2177: END IF;

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 2194: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.5] Call to ' ||

2190: , l_return_status
2191: , p_target_type );
2192:
2193: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2194: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.5] Call to ' ||
2195: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||
2196: l_terr_L3_target;
2197: RAISE FND_API.G_EXC_ERROR;
2198: END IF;

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 2215: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.6] Call to ' ||

2211: , l_return_status
2212: , p_target_type );
2213:
2214: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2215: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.6] Call to ' ||
2216: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||
2217: l_terr_L4_target;
2218: RAISE FND_API.G_EXC_ERROR;
2219: END IF;

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 2235: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.7] Call to ' ||

2231: , l_return_status
2232: , p_target_type );
2233:
2234: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2235: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.7] Call to ' ||
2236: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||
2237: l_terr_L5_target;
2238: RAISE FND_API.G_EXC_ERROR;
2239: END IF;

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 2255: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.8] Call to ' ||

2251: , l_return_status
2252: , p_target_type );
2253:
2254: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2255: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [P04.8] Call to ' ||
2256: 'JTF_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' ||
2257: l_terr_WT_target;
2258: RAISE FND_API.G_EXC_ERROR;
2259: END IF;

Line 2285: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [END] UTL_FILE: ' ||

2281: utl_file.invalid_operation OR
2282: utl_file.write_error THEN
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 ;

Line 2291: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: [END] OTHERS: ' ||

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: ' ||
2292: SQLERRM;
2293: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
2294:
2295: END get_winners_parallel_setup;

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 2480: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL_SETUP: worker_id= ' || p_worker_id ||

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.';
2482: RAISE NO_TAE_DATA_FOUND;
2483: END IF;
2484:

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 2572: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||

2568: END IF; -- what source
2569: --dbms_output.put_line('GET_WINNERS_PARALLEL x_return_status of DYN PACKAGE: ' || x_return_status);
2570:
2571: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2572: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||
2573: p_worker_id ||
2574: '[P01] Call to ' ||
2575: 'JTF_TAE_1001_..._DYN.SEARCH_TERR_RULES API has failed.';
2576: RAISE FND_API.G_EXC_ERROR;

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 2599: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||

2595: , x_return_status => x_return_status );
2596: --dbms_output.put_line('GET_WINNERS_PARALLEL ANALYZING MATCHES TABLE ... COMPLETE ');
2597:
2598: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2599: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: worker_id= ' ||
2600: p_worker_id || '[P02] Call to ' ||
2601: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' ||
2602: l_matches_target;
2603: RAISE FND_API.G_EXC_ERROR;

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 2632: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.1] Call to ' ||

2628: p_worker_id => p_worker_id
2629: );
2630:
2631: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2632: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.1] Call to ' ||
2633: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
2634: l_terr_L1_target;
2635: RAISE FND_API.G_EXC_ERROR;
2636: END IF;

Line 2658: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.2] Call to ' ||

2654: p_worker_id => p_worker_id
2655: );
2656:
2657: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2658: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.2] Call to ' ||
2659: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
2660: l_terr_L2_target;
2661: RAISE FND_API.G_EXC_ERROR;
2662: END IF;

Line 2684: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [P03] Call to ' ||

2680: p_worker_id => p_worker_id
2681: );
2682:
2683: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2684: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [P03] Call to ' ||
2685: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
2686: l_terr_L3_target;
2687: RAISE FND_API.G_EXC_ERROR;
2688: END IF;

Line 2710: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.4] Call to ' ||

2706: p_worker_id => p_worker_id
2707: );
2708:
2709: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2710: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.4] Call to ' ||
2711: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
2712: l_terr_L4_target;
2713: RAISE FND_API.G_EXC_ERROR;
2714: END IF;

Line 2737: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.5] Call to ' ||

2733: );
2734:
2735:
2736: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2737: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.5] Call to ' ||
2738: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
2739: l_terr_L5_target;
2740: RAISE FND_API.G_EXC_ERROR;
2741: END IF;

Line 2762: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.6] Call to ' ||

2758: p_worker_id => p_worker_id
2759: );
2760:
2761: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2762: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: [11.6] Call to ' ||
2763: 'JTF_TAE_INDEX_CREATION_PVT.Process_Level_Winners API has failed for ' ||
2764: l_terr_WT_target;
2765: RAISE FND_API.G_EXC_ERROR;
2766: END IF;

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 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 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 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 3084: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: [P05] Call to ' ||

3080: , p_percent => 20
3081: , x_return_status => x_return_status );
3082:
3083: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3084: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: [P05] Call to ' ||
3085: 'JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' ||
3086: l_winners_target;
3087: RAISE FND_API.G_EXC_ERROR;
3088: END IF;

Line 3098: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: Successfully completed.';

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;
3100: RETCODE := 0;
3101:
3102: EXCEPTION

Line 3126: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: [END] UTL_FILE: ' ||

3122: utl_file.invalid_operation OR
3123: utl_file.write_error THEN
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

Line 3134: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: [END] OTHERS: ' ||

3130: WHEN OTHERS THEN
3131:
3132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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:

Line 3612: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: ' ||

3608:
3609: END IF;
3610:
3611: /* Program completed successfully */
3612: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: ' ||
3613: 'UPPER LEVEL = ' || p_UPPER_LEVEL_FROM_ROOT || ' ' ||
3614: 'Successfully completed.';
3615: x_return_status := FND_API.G_RET_STS_SUCCESS;
3616:

Line 3622: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: ' ||

3618:
3619: WHEN FND_API.G_EXC_ERROR THEN
3620:
3621: x_return_status := FND_API.G_RET_STS_ERROR;
3622: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: ' ||
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;

Line 3632: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: ' ||

3628:
3629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3630:
3631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3632: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: ' ||
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;

Line 3646: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] UTL_FILE: ' ||

3642: utl_file.invalid_operation OR
3643: utl_file.write_error THEN
3644:
3645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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);

Line 3655: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] OTHERS: ' ||

3651:
3652: WHEN OTHERS THEN
3653:
3654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3655: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] OTHERS: ' ||
3656: 'UPPER LEVEL = ' || p_UPPER_LEVEL_FROM_ROOT || ' ' ||
3657: 'LOWER LEVEL = ' || p_LOWER_LEVEL_FROM_ROOT || ' :' ||
3658: SQLERRM;
3659:

Line 3797: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Final_Level_Winners: ' ||

3793:
3794: END;
3795:
3796: /* Program completed successfully */
3797: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Final_Level_Winners: ' ||
3798: 'Successfully completed.';
3799: x_return_status := FND_API.G_RET_STS_SUCCESS;
3800:
3801: EXCEPTION

Line 3806: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Final_Level_Winners: ' ||

3802:
3803: WHEN FND_API.G_EXC_ERROR THEN
3804:
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:

Line 3814: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Final_Level_Winners: ' ||

3810:
3811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3812:
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:

Line 3826: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Final_Level_Winners: [END] UTL_FILE: ' ||

3822: utl_file.invalid_operation OR
3823: utl_file.write_error THEN
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

Line 3833: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Final_Level_Winners: [END] OTHERS: ' ||

3829:
3830: WHEN OTHERS THEN
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;

Line 4003: ERRBUF := 'JTF_TAE_ASSIGN_PUB.TABLE_TRUNCATE_DROP_INDEX: [END] OTHERS: ' ||

3999: EXCEPTION
4000: WHEN OTHERS THEN
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:

Line 4037: --dbms_output.put_line('JTF_TAE_ASSIGN_PUB.FETCH_NM_REASSIGN_TRANS START');

4033: )
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:

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 4098: --dbms_output.put_line('JTF_TAE_ASSIGN_PUB.FETCH_NM_REASSIGN_TRANS END');

4094: END IF; -- what tx type
4095:
4096: x_return_status := FND_API.G_RET_STS_SUCCESS;
4097:
4098: --dbms_output.put_line('JTF_TAE_ASSIGN_PUB.FETCH_NM_REASSIGN_TRANS END');
4099:
4100: EXCEPTION
4101: WHEN OTHERS THEN
4102:

Line 4104: ERRBUF := 'JTF_TAE_ASSIGN_PUB.FETCH_NM_REASSIGN_TRANS: [END] OTHERS: ' ||

4100: EXCEPTION
4101: WHEN OTHERS THEN
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:

Line 4148: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DELETE_CHANGED_TERR_RECS: [END] OTHERS: ' ||

4144: EXCEPTION
4145: WHEN OTHERS THEN
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:

Line 4153: END JTF_TAE_ASSIGN_PUB;

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: