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 FND_API

Line 78: /* FYI: FND_API STUFF **************

74: G_APP_SHORT_NAME VARCHAR2(15) := FND_GLOBAL.Application_Short_Name;
75:
76: NO_TAE_DATA_FOUND EXCEPTION;
77:
78: /******************* FYI: FND_API STUFF ********************************
79:
80: -- API return status
81: --
82: -- G_RET_STS_SUCCESS means that the API was successful in performing

Line 149: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

150:
151: EXCEPTION
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

Line 164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

160: End If;
161:
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:

Line 178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

174: END GET_NUM_ROWS;
175:
176: PROCEDURE get_winners
177: ( p_api_version_number IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_SQL_Trace IN VARCHAR2,
180: p_Debug_Flag IN VARCHAR2,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,

Line 230: x_return_status := FND_API.G_RET_STS_SUCCESS;

226:
227: l_worker_id NUMBER := 1;
228: BEGIN
229:
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;

Line 252: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

248: ---
249: COMMIT;
250:
251: /* Standard call to check for call compatibility. */
252: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
253: p_api_version_number,
254: l_api_name,
255: G_PKG_NAME) THEN
256:

Line 257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

253: p_api_version_number,
254: l_api_name,
255: G_PKG_NAME) THEN
256:
257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
258:
259: END IF;
260:
261: /* Initialize message list if p_init_msg_list is set to TRUE. */

Line 262: IF FND_API.to_Boolean( p_init_msg_list ) THEN

258:
259: END IF;
260:
261: /* Initialize message list if p_init_msg_list is set to TRUE. */
262: IF FND_API.to_Boolean( p_init_msg_list ) THEN
263: FND_MSG_PUB.initialize;
264: END IF;
265:
266: -- Debug Message

Line 371: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

367: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
368: p_table_name => l_matches_target
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;

Line 377: RAISE FND_API.G_EXC_ERROR;

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;
378:
379: END IF;
380:
381: -----------

Line 393: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

389: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
390: p_table_name => l_winners_target
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;

Line 399: RAISE FND_API.G_EXC_ERROR;

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;
400:
401: END IF;
402:
403: -----------

Line 525: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

521: p_table_name => l_trans_target
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;

Line 529: RAISE FND_API.G_EXC_ERROR;

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;
531:
532:
533: -----------

Line 543: p_Init_Msg_List => FND_API.G_FALSE,

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,
546: x_Return_Status => x_return_status,
547: x_Msg_Count => x_msg_count,

Line 544: p_Commit => FND_API.G_FALSE,

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,
546: x_Return_Status => x_return_status,
547: x_Msg_Count => x_msg_count,
548: x_Msg_Data => x_msg_data,

Line 545: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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,
546: x_Return_Status => x_return_status,
547: x_Msg_Count => x_msg_count,
548: x_Msg_Data => x_msg_data,
549: p_run_mode => 'FULL',

Line 558: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

554: p_trans_id => p_trans_object_type_id,
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;

Line 561: RAISE FND_API.G_EXC_ERROR;

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: -----------
565: --- [7] ---

Line 601: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

597: x_Msg_Data => x_msg_data );
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;

Line 604: RAISE FND_API.G_EXC_ERROR;

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:
607: -----------
608: --- [8] ---

Line 629: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

625: p_table_name => l_matches_target
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;

Line 633: RAISE FND_API.G_EXC_ERROR;

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;
635:
636: -----------
637: --- [10] ---

Line 649: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

645: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
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;

Line 653: RAISE FND_API.G_EXC_ERROR;

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;
655:
656: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
657: p_table_name => l_terr_L2_target

Line 660: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

656: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
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;

Line 664: RAISE FND_API.G_EXC_ERROR;

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;
666:
667: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
668: p_table_name => l_terr_L3_target

Line 671: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

667: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
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;

Line 675: RAISE FND_API.G_EXC_ERROR;

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;
677:
678: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
679: p_table_name => l_terr_L4_target

Line 682: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

678: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
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;

Line 686: RAISE FND_API.G_EXC_ERROR;

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;
688:
689: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
690: p_table_name => l_terr_L5_target

Line 693: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

689: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
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;

Line 697: RAISE FND_API.G_EXC_ERROR;

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;
699:
700: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
701: p_table_name => l_terr_WT_target

Line 704: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

700: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
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;

Line 708: RAISE FND_API.G_EXC_ERROR;

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;
710:
711:
712: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

Line 733: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

729: x_return_status => l_return_status,
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;

Line 737: RAISE FND_API.G_EXC_ERROR;

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;
739:
740: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
741: p_table_name => l_terr_L1_target

Line 759: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

755: x_return_status => l_return_status,
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;

Line 763: RAISE FND_API.G_EXC_ERROR;

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;
765:
766: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
767: p_table_name => l_terr_L2_target

Line 784: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

780: x_return_status => l_return_status,
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;

Line 788: RAISE FND_API.G_EXC_ERROR;

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;
790:
791: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
792: p_table_name => l_terr_L3_target

Line 809: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

805: x_return_status => l_return_status,
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;

Line 813: RAISE FND_API.G_EXC_ERROR;

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;
815:
816: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
817: p_table_name => l_terr_L4_target

Line 834: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

830: x_return_status => l_return_status,
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;

Line 838: RAISE FND_API.G_EXC_ERROR;

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;
840:
841: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
842: p_table_name => l_terr_L5_target

Line 859: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

855: x_return_status => l_return_status,
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;

Line 863: RAISE FND_API.G_EXC_ERROR;

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;
865:
866: JTF_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(
867: p_table_name => l_terr_WT_target

Line 1113: x_return_status := FND_API.G_RET_STS_SUCCESS;

1109: WHEN NO_DATA_FOUND THEN
1110: NULL;
1111: END;
1112:
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, ' ');

Line 1138: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1134: , p_trans_object_type_id
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;

Line 1142: RAISE FND_API.G_EXC_ERROR;

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;
1144:
1145: -----------
1146: --- [14] ---

Line 1160: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1156: p_table_name => l_winners_target
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;

Line 1164: RAISE FND_API.G_EXC_ERROR;

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;
1166:
1167: ELSIF p_target_type ='RPT' THEN
1168: NULL;

Line 1180: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
1184:

Line 1187: x_return_status := FND_API.G_RET_STS_SUCCESS;

1183: EXCEPTION
1184:
1185: WHEN NO_TAE_DATA_FOUND THEN
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;

Line 1194: WHEN FND_API.G_EXC_ERROR THEN

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;
1197:
1198: RETCODE := 2;

Line 1196: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1197:
1198: RETCODE := 2;
1199: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] FND_API.G_EXC_ERROR: ' ||
1200: SQLERRM;

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 1203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
1206:
1207: RETCODE := 2;

Line 1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1206:
1207: RETCODE := 2;
1208: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: FND_API.G_EXC_UNEXPECTED_ERROR: ' ||
1209: SQLERRM;

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 1219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1215: utl_file.invalid_filehandle OR
1216: utl_file.invalid_operation OR
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:

Line 1228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
1229: RETCODE := 2;
1230: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS: [END] OTHERS: ' ||
1231: SQLERRM;
1232:

Line 1248: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1244: -- notes:
1245: --
1246: PROCEDURE Drop_TAE_TRANS_Indexes
1247: ( p_api_version_number IN NUMBER,
1248: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1249: p_SQL_Trace IN VARCHAR2,
1250: p_Debug_Flag IN VARCHAR2,
1251: x_return_status OUT NOCOPY VARCHAR2,
1252: p_source_id IN NUMBER,

Line 1268: x_return_status := FND_API.G_RET_STS_SUCCESS;

1264: l_trans_id number := p_trans_object_type_id;
1265:
1266: BEGIN
1267:
1268: x_return_status := FND_API.G_RET_STS_SUCCESS;
1269:
1270: /* Sales and Telesales/Account */
1271: IF (l_source_id = -1001) THEN
1272:

Line 1296: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1292:
1293: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES( p_table_name => l_trans_target
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;

Line 1302: RAISE FND_API.G_EXC_ERROR;

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;
1303:
1304: END IF;
1305:
1306: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES( p_table_name => l_matches_target

Line 1309: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1305:
1306: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES( p_table_name => l_matches_target
1307: , x_return_status => x_return_status );
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 ' ||

Line 1316: RAISE FND_API.G_EXC_ERROR;

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;
1317:
1318: END IF;
1319:
1320: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES( p_table_name => l_winners_target

Line 1323: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1319:
1320: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES( p_table_name => l_winners_target
1321: , x_return_status => x_return_status );
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 ' ||

Line 1330: RAISE FND_API.G_EXC_ERROR;

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;
1331:
1332: END IF;
1333:
1334: /* Program completed successfully */

Line 1336: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
1340:

Line 1341: WHEN FND_API.G_EXC_ERROR THEN

1337: RETCODE := 0;
1338:
1339: EXCEPTION
1340:
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] ' ||

Line 1342: x_return_status := FND_API.G_RET_STS_ERROR;

1338:
1339: EXCEPTION
1340:
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: ' ||

Line 1346: 'FND_API.G_EXC_ERROR: ' ||

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:
1350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
1353:
1354: RETCODE := 2;

Line 1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1353:
1354: RETCODE := 2;
1355: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [END] ' ||
1356: 'FND_API.G_EXC_UNEXPECTED_ERROR: ' ||

Line 1356: 'FND_API.G_EXC_UNEXPECTED_ERROR: ' ||

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:
1360: WHEN utl_file.invalid_path OR

Line 1366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1362: utl_file.invalid_filehandle OR
1363: Utl_file.invalid_operation OR
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:

Line 1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
1376: RETCODE := 2;
1377: ERRBUF := 'JTF_TAE_ASSIGN_PUB.DROP_TAE_TRANS_INDEXES: [END] OTHERS: ' ||
1378: SQLERRM;
1379:

Line 1421: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
1425: WHEN OTHERS THEN

Line 1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1422: RETCODE := 0;
1423:
1424: EXCEPTION
1425: WHEN OTHERS THEN
1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1427: END Get_SQL_For_Changes;
1428:
1429:
1430:

Line 1444: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1440: --
1441:
1442: PROCEDURE Clear_Trans_Data
1443: ( p_api_version_number IN NUMBER,
1444: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1445: p_SQL_Trace IN VARCHAR2,
1446: p_Debug_Flag IN VARCHAR2,
1447: x_return_status OUT NOCOPY VARCHAR2,
1448: p_source_id IN NUMBER,

Line 1544: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1540: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
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:

Line 1549: RAISE FND_API.G_EXC_ERROR;

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;
1550: END IF;
1551:
1552:
1553: -------------

Line 1570: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1566: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
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;

Line 1574: RAISE FND_API.G_EXC_ERROR;

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;
1576:
1577: -------------
1578: --- [P03] --- TRUNCATE WINNERS

Line 1593: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1589: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
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;

Line 1597: RAISE FND_API.G_EXC_ERROR;

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;
1599:
1600: -------------
1601: --- [P03.1] -

Line 1617: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1613: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
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;

Line 1621: RAISE FND_API.G_EXC_ERROR;

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;
1623:
1624: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1625: p_table_name => l_terr_L2_target

Line 1632: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1628: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
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;

Line 1636: RAISE FND_API.G_EXC_ERROR;

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;
1638:
1639:
1640: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 1648: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1644: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
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;

Line 1652: RAISE FND_API.G_EXC_ERROR;

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;
1654:
1655: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1656: p_table_name => l_terr_L4_target

Line 1663: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1659: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
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;

Line 1667: RAISE FND_API.G_EXC_ERROR;

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;
1669:
1670:
1671: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 1679: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1675: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
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;

Line 1683: RAISE FND_API.G_EXC_ERROR;

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;
1685:
1686:
1687: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 1695: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1691: JTF_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
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;

Line 1699: RAISE FND_API.G_EXC_ERROR;

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;
1701:
1702: -------------
1703: --- [P04] --- DROP INDEXES for TRANS TABLE ONLY (WE KEEP INDEXES FOR MATCHES AND WINNERS )

Line 1713: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1709:
1710: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES( p_table_name => l_trans_target
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;

Line 1719: RAISE FND_API.G_EXC_ERROR;

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;
1720:
1721: END IF;
1722:
1723: EXCEPTION

Line 1724: WHEN FND_API.G_EXC_ERROR THEN

1720:
1721: END IF;
1722:
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:

Line 1725: x_return_status := FND_API.G_RET_STS_ERROR;

1721: END IF;
1722:
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

Line 1729: WHEN FND_API.G_EXC_UNEXPECTED_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;
1732: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1733:

Line 1730: x_return_status := FND_API.G_RET_STS_UNEXP_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;
1732: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
1733:
1734: WHEN utl_file.invalid_path OR

Line 1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1736: utl_file.invalid_filehandle OR
1737: Utl_file.invalid_operation OR
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);

Line 1747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
1749: ERRBUF := 'JTF_TAE_ASSIGN_PUB.CLEAR_TRANS_DATA: [END] OTHERS: ' ||
1750: SQLERRM;
1751: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

Line 1768: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1764: --
1765:
1766: PROCEDURE get_winners_parallel_setup
1767: ( p_api_version_number IN NUMBER,
1768: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1769: p_SQL_Trace IN VARCHAR2,
1770: p_Debug_Flag IN VARCHAR2,
1771: x_return_status OUT NOCOPY VARCHAR2,
1772: x_msg_count OUT NOCOPY NUMBER,

Line 1820: x_return_status := FND_API.G_RET_STS_SUCCESS;

1816: lx_runtime VARCHAR2(300);
1817:
1818: BEGIN
1819:
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;

Line 1839: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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,
1840: p_api_version_number,
1841: l_api_name,
1842: G_PKG_NAME) THEN
1843:

Line 1844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1840: p_api_version_number,
1841: l_api_name,
1842: G_PKG_NAME) THEN
1843:
1844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1845:
1846: END IF;
1847:
1848: /* Initialize message list if p_init_msg_list is set to TRUE. */

Line 1849: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1845:
1846: END IF;
1847:
1848: /* Initialize message list if p_init_msg_list is set to TRUE. */
1849: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1850: FND_MSG_PUB.initialize;
1851: END IF;
1852:
1853: -- Debug Message

Line 2059: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2055: p_table_name => l_trans_target
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;

Line 2063: RAISE FND_API.G_EXC_ERROR;

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;
2065:
2066: -------------
2067: --- [P03] ---

Line 2076: p_Init_Msg_List => FND_API.G_FALSE,

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,
2079: x_Return_Status => x_return_status,
2080: x_Msg_Count => x_msg_count,

Line 2077: p_Commit => FND_API.G_FALSE,

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,
2079: x_Return_Status => x_return_status,
2080: x_Msg_Count => x_msg_count,
2081: x_Msg_Data => x_msg_data,

Line 2078: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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,
2079: x_Return_Status => x_return_status,
2080: x_Msg_Count => x_msg_count,
2081: x_Msg_Data => x_msg_data,
2082: p_run_mode => p_target_type,

Line 2091: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2087: p_trans_id => p_trans_object_type_id,
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;

Line 2094: RAISE FND_API.G_EXC_ERROR;

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:
2098: -----------

Line 2113: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2109: , p_source_id
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;

Line 2117: RAISE FND_API.G_EXC_ERROR;

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;
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 ' ||

Line 2132: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2128: , p_source_id
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;

Line 2136: RAISE FND_API.G_EXC_ERROR;

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;
2138:
2139:
2140: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

Line 2152: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2148: , p_source_id
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;

Line 2156: RAISE FND_API.G_EXC_ERROR;

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;
2158:
2159:
2160: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

Line 2172: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2168: , p_source_id
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;

Line 2176: RAISE FND_API.G_EXC_ERROR;

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;
2178:
2179:
2180:

Line 2193: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2189: , p_source_id
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;

Line 2197: RAISE FND_API.G_EXC_ERROR;

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;
2199:
2200:
2201:

Line 2214: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2210: , p_source_id
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;

Line 2218: RAISE FND_API.G_EXC_ERROR;

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;
2220:
2221:
2222: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

Line 2234: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2230: , p_source_id
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;

Line 2238: RAISE FND_API.G_EXC_ERROR;

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;
2240:
2241:
2242: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ' ');

Line 2254: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2250: , p_source_id
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;

Line 2258: RAISE FND_API.G_EXC_ERROR;

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;
2260:
2261:
2262: EXCEPTION

Line 2264: x_return_status := FND_API.G_RET_STS_SUCCESS;

2260:
2261:
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

Line 2268: WHEN FND_API.G_EXC_ERROR 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;
2271: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
2272:

Line 2269: x_return_status := FND_API.G_RET_STS_ERROR;

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;
2271: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
2272:
2273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2273: WHEN FND_API.G_EXC_UNEXPECTED_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;
2276: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
2277:

Line 2274: x_return_status := FND_API.G_RET_STS_UNEXP_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;
2276: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
2277:
2278: WHEN utl_file.invalid_path OR

Line 2283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2279: utl_file.invalid_mode OR
2280: utl_file.invalid_filehandle OR
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);

Line 2289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 2311: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2307: --
2308:
2309: PROCEDURE GET_WINNERS_PARALLEL
2310: ( p_api_version_number IN NUMBER,
2311: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2312: p_SQL_Trace IN VARCHAR2,
2313: p_Debug_Flag IN VARCHAR2,
2314: x_return_status OUT NOCOPY VARCHAR2,
2315: x_msg_count OUT NOCOPY NUMBER,

Line 2367: x_return_status := FND_API.G_RET_STS_SUCCESS;

2363: lx_runtime VARCHAR2(300);
2364:
2365: BEGIN
2366:
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;

Line 2571: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2567: END IF; -- what tx type
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.';

Line 2576: RAISE FND_API.G_EXC_ERROR;

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;
2577: END IF;
2578:
2579: -------------
2580: --- [P02] --- ANALYZE MATCHES TABLE

Line 2598: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2594: , p_percent => 20
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;

Line 2603: RAISE FND_API.G_EXC_ERROR;

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;
2604: END IF;
2605:
2606: -------------
2607: --- [P03] --- PARALLEL MULTI_VARIABLE NUMBER OF WINNERS PROCESSING

Line 2631: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2627: x_return_status => l_return_status,
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;

Line 2635: RAISE FND_API.G_EXC_ERROR;

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;
2637:
2638: --ARPATEL 09/22/03 add commit to avoid large rollback segments
2639: COMMIT;

Line 2657: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2653: x_return_status => l_return_status,
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;

Line 2661: RAISE FND_API.G_EXC_ERROR;

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;
2663:
2664: --ARPATEL 09/22/03 add commit to avoid large rollback segments
2665: COMMIT;

Line 2683: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2679: x_return_status => l_return_status,
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;

Line 2687: RAISE FND_API.G_EXC_ERROR;

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;
2689:
2690: --ARPATEL 09/22/03 add commit to avoid large rollback segments
2691: COMMIT;

Line 2709: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2705: x_return_status => l_return_status,
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;

Line 2713: RAISE FND_API.G_EXC_ERROR;

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;
2715:
2716: --ARPATEL 09/22/03 add commit to avoid large rollback segments
2717: COMMIT;

Line 2736: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2732: p_worker_id => p_worker_id
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;

Line 2740: RAISE FND_API.G_EXC_ERROR;

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;
2742:
2743: --ARPATEL 09/22/03 add commit to avoid large rollback segments
2744: COMMIT;

Line 2761: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2757: x_return_status => l_return_status,
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;

Line 2765: RAISE FND_API.G_EXC_ERROR;

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;
2767:
2768: --ARPATEL 09/22/03 add commit to avoid large rollback segments
2769: COMMIT;

Line 3055: x_return_status := FND_API.G_RET_STS_SUCCESS;

3051: WHEN NO_DATA_FOUND THEN
3052: NULL;
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 ||

Line 3083: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3079: p_table_name => l_winners_target
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;

Line 3087: RAISE FND_API.G_EXC_ERROR;

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;
3089:
3090: --------------------------------
3091: -- END API

Line 3099: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
3103:

Line 3105: x_return_status := FND_API.G_RET_STS_SUCCESS;

3101:
3102: EXCEPTION
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

Line 3109: WHEN FND_API.G_EXC_ERROR 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;
3112: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3113:

Line 3110: x_return_status := FND_API.G_RET_STS_ERROR;

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;
3112: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3113:
3114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3114: WHEN FND_API.G_EXC_UNEXPECTED_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;
3117: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3118:

Line 3115: x_return_status := FND_API.G_RET_STS_UNEXP_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;
3117: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3118:
3119: WHEN utl_file.invalid_path OR

Line 3124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3120: utl_file.invalid_mode OR
3121: utl_file.invalid_filehandle OR
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);

Line 3132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
3133: RETCODE := 2;
3134: ERRBUF := 'JTF_TAE_ASSIGN_PUB.GET_WINNERS_PARALLEL: [END] OTHERS: ' ||
3135: SQLERRM;
3136:

Line 3301: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3297: GET_NUM_ROWS( p_table_name => p_matches_target
3298: , x_num_rows => l_matches_num_rows
3299: , x_return_status => x_return_status );
3300:
3301: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3302: RAISE FND_API.G_EXC_ERROR;
3303: END IF;
3304:
3305: GET_NUM_ROWS( p_table_name => p_terr_PARENT_LEVEL_tbl

Line 3302: RAISE FND_API.G_EXC_ERROR;

3298: , x_num_rows => l_matches_num_rows
3299: , x_return_status => x_return_status );
3300:
3301: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3302: RAISE FND_API.G_EXC_ERROR;
3303: END IF;
3304:
3305: GET_NUM_ROWS( p_table_name => p_terr_PARENT_LEVEL_tbl
3306: , x_num_rows => l_level_num_rows

Line 3309: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3305: GET_NUM_ROWS( p_table_name => p_terr_PARENT_LEVEL_tbl
3306: , x_num_rows => l_level_num_rows
3307: , x_return_status => x_return_status );
3308:
3309: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3310: RAISE FND_API.G_EXC_ERROR;
3311: END IF;
3312:
3313: GET_NUM_ROWS( p_table_name => 'JTF_TERR_DENORM_RULES_ALL'

Line 3310: RAISE FND_API.G_EXC_ERROR;

3306: , x_num_rows => l_level_num_rows
3307: , x_return_status => x_return_status );
3308:
3309: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3310: RAISE FND_API.G_EXC_ERROR;
3311: END IF;
3312:
3313: GET_NUM_ROWS( p_table_name => 'JTF_TERR_DENORM_RULES_ALL'
3314: , x_num_rows => l_denorm_num_rows

Line 3317: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3313: GET_NUM_ROWS( p_table_name => 'JTF_TERR_DENORM_RULES_ALL'
3314: , x_num_rows => l_denorm_num_rows
3315: , x_return_status => x_return_status );
3316:
3317: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3318: RAISE FND_API.G_EXC_ERROR;
3319: END IF;
3320:
3321: END IF;

Line 3318: RAISE FND_API.G_EXC_ERROR;

3314: , x_num_rows => l_denorm_num_rows
3315: , x_return_status => x_return_status );
3316:
3317: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3318: RAISE FND_API.G_EXC_ERROR;
3319: END IF;
3320:
3321: END IF;
3322:

Line 3615: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
3617: EXCEPTION
3618:
3619: WHEN FND_API.G_EXC_ERROR THEN

Line 3619: WHEN FND_API.G_EXC_ERROR THEN

3615: x_return_status := FND_API.G_RET_STS_SUCCESS;
3616:
3617: EXCEPTION
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: ' ||

Line 3621: x_return_status := FND_API.G_RET_STS_ERROR;

3617: EXCEPTION
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 || ' :' ||

Line 3623: '[END] FND_API.G_RET_STS_ERROR: ' ||

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;
3627: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

Line 3629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
3632: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Level_Winners: ' ||
3633: '[END] FND_API.G_EXC_UNEXPECTED_ERROR: ' ||

Line 3631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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 || ' :' ||

Line 3633: '[END] FND_API.G_EXC_UNEXPECTED_ERROR: ' ||

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;
3637: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);

Line 3645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3641: utl_file.invalid_filehandle OR
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;

Line 3654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
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;

Line 3799: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 3803: WHEN FND_API.G_EXC_ERROR THEN

3799: x_return_status := FND_API.G_RET_STS_SUCCESS;
3800:
3801: EXCEPTION
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: ' ||

Line 3805: x_return_status := FND_API.G_RET_STS_ERROR;

3801: EXCEPTION
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);

Line 3807: '[END] FND_API.G_RET_STS_ERROR: ' ||

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

Line 3811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
3814: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Final_Level_Winners: ' ||
3815: '[END] FND_API.G_EXC_UNEXPECTED_ERROR: ' ||

Line 3813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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);

Line 3815: '[END] FND_API.G_EXC_UNEXPECTED_ERROR: ' ||

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:
3819: WHEN utl_file.invalid_path OR

Line 3825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3821: utl_file.invalid_filehandle OR
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:

Line 3832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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 ;
3833: ERRBUF := 'JTF_TAE_ASSIGN_PUB.Process_Final_Level_Winners: [END] OTHERS: ' ||
3834: SQLERRM;
3835: JTF_TAE_CONTROL_PVT.WRITE_LOG(2, ERRBUF);
3836:

Line 3852: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3848: --
3849:
3850: PROCEDURE NM_TABLE_TRUNCATE_DROP_INDEX
3851: ( p_api_version_number IN NUMBER,
3852: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3853: p_SQL_Trace IN VARCHAR2,
3854: p_Debug_Flag IN VARCHAR2,
3855: p_table_name IN VARCHAR2,
3856: x_return_status OUT NOCOPY VARCHAR2,

Line 3998: x_return_status := FND_API.G_RET_STS_SUCCESS;

3994: JTF_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
3995: p_table_name => l_terr_WT_target
3996: , x_return_status => x_return_status);
3997:
3998: x_return_status := FND_API.G_RET_STS_SUCCESS;
3999: EXCEPTION
4000: WHEN OTHERS THEN
4001:
4002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 4021: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4017: --
4018:
4019: PROCEDURE FETCH_NM_REASSIGN_TRANS
4020: ( p_api_version_number IN NUMBER,
4021: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4022: p_SQL_Trace IN VARCHAR2,
4023: p_Debug_Flag IN VARCHAR2,
4024: p_destination_table IN VARCHAR2,
4025: p_source_id IN NUMBER,

Line 4096: x_return_status := FND_API.G_RET_STS_SUCCESS;

4092: p_worker_id => 1 );
4093:
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

Line 4103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4099:
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:

Line 4127: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4123: --
4124:
4125: PROCEDURE DELETE_CHANGED_TERR_RECS
4126: ( p_api_version_number IN NUMBER,
4127: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4128: p_SQL_Trace IN VARCHAR2,
4129: p_Debug_Flag IN VARCHAR2,
4130: p_request_id IN VARCHAR2,
4131: x_return_status OUT NOCOPY VARCHAR2,

Line 4143: x_return_status := FND_API.G_RET_STS_SUCCESS;

4139:
4140: DELETE FROM JTF_CHANGED_TERR_ALL
4141: WHERE REQUEST_ID = p_request_id;
4142:
4143: x_return_status := FND_API.G_RET_STS_SUCCESS;
4144: EXCEPTION
4145: WHEN OTHERS THEN
4146:
4147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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