APPS.JTY_ASSIGN_BULK_PUB dependencies on FND_API

Line 99: x_return_status := FND_API.G_RET_STS_SUCCESS;

95: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.begin',
96: 'Start of the procedure JTY_ASSIGN_BULK_PUB.insert_nm_trans_data');
97: END IF;
98:
99: x_return_status := FND_API.G_RET_STS_SUCCESS;
100: l_sysdate := SYSDATE;
101:
102: /* Get the NM_TRANS table name */
103: BEGIN

Line 233: x_return_status := FND_API.G_RET_STS_ERROR ;

229: END IF;
230:
231: EXCEPTION
232: WHEN L_SEED_DATA_NOTFOUND THEN
233: x_return_status := FND_API.G_RET_STS_ERROR ;
234: RETCODE := 2;
235: x_msg_count := 1;
236: ERRBUF := x_msg_data;
237: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

240: x_msg_data);
241: END IF;
242:
243: WHEN L_SCHEMA_NOTFOUND THEN
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245: RETCODE := 2;
246: x_msg_data := 'JTY_ASSIGN_BULK_PUB.insert_nm_trans_data: SCHEMA NAME NOT FOUND CORRESPONDING TO JTF APPLICATION. ';
247: ERRBUF := x_msg_data;
248: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 255: x_return_status := FND_API.G_RET_STS_ERROR ;

251: x_msg_data);
252: END IF;
253:
254: WHEN NO_DATA_FOUND THEN
255: x_return_status := FND_API.G_RET_STS_ERROR ;
256: RETCODE := 2;
257: x_msg_count := 1;
258: ERRBUF := x_msg_data;
259: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

262: x_msg_data);
263: END IF;
264:
265: WHEN OTHERS THEN
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
267: x_msg_data := SQLCODE || ' : ' || SQLERRM;
268: x_msg_count := 1;
269: ERRBUF := x_msg_data;
270: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 339: x_return_status := FND_API.G_RET_STS_SUCCESS;

335: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.begin',
336: 'Start of the procedure JTY_ASSIGN_BULK_PUB.insert_trans_data');
337: END IF;
338:
339: x_return_status := FND_API.G_RET_STS_SUCCESS;
340: l_sysdate := SYSDATE;
341:
342: /* Number of workers is restricted from 1 to 10 */
343: IF ((p_no_of_workers > 10) OR (p_no_of_workers < 1)) THEN

Line 514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

510: END IF;
511:
512: EXCEPTION
513: WHEN L_INVALID_WORKERS THEN
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
515: RETCODE := 2;
516: x_msg_data := 'JTY_ASSIGN_BULK_PUB.insert_trans_data: Invalid number of workers : Valid range from 1 - 10';
517: ERRBUF := x_msg_data;
518: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 525: x_return_status := FND_API.G_RET_STS_ERROR ;

521: x_msg_data);
522: END IF;
523:
524: WHEN L_SEED_DATA_NOTFOUND THEN
525: x_return_status := FND_API.G_RET_STS_ERROR ;
526: RETCODE := 2;
527: x_msg_count := 1;
528: ERRBUF := x_msg_data;
529: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

532: x_msg_data);
533: END IF;
534:
535: WHEN L_SCHEMA_NOTFOUND THEN
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
537: RETCODE := 2;
538: x_msg_data := 'JTY_ASSIGN_BULK_PUB.insert_trans_data: SCHEMA NAME NOT FOUND CORRESPONDING TO JTF APPLICATION. ';
539: ERRBUF := x_msg_data;
540: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 547: x_return_status := FND_API.G_RET_STS_ERROR ;

543: x_msg_data);
544: END IF;
545:
546: WHEN NO_DATA_FOUND THEN
547: x_return_status := FND_API.G_RET_STS_ERROR ;
548: RETCODE := 2;
549: x_msg_count := 1;
550: ERRBUF := x_msg_data;
551: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

554: x_msg_data);
555: END IF;
556:
557: WHEN OTHERS THEN
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
559: x_msg_data := SQLCODE || ' : ' || SQLERRM;
560: x_msg_count := 1;
561: ERRBUF := x_msg_data;
562: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

670: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
671: p_table_name => l_trans_target
672: ,x_return_status => x_return_status );
673:
674: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
675: -- debug message
676: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_trans_target;
677: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
678: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 683: RAISE FND_API.G_EXC_ERROR;

679: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',
680: x_msg_data);
681: END IF;
682:
683: RAISE FND_API.G_EXC_ERROR;
684: END IF;
685:
686: /* Truncate the TRANS table */
687: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

687: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
688: p_table_name => l_trans_target
689: ,x_return_status => x_return_status );
690:
691: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
692: -- debug message
693: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_trans_target;
694: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
695: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 700: RAISE FND_API.G_EXC_ERROR;

696: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',
697: x_msg_data);
698: END IF;
699:
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;
702:
703: END IF; /* end IF (l_trans_target IS NOT NULL) */
704:

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

716: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
717: p_table_name => l_match_target
718: ,x_return_status => x_return_status );
719:
720: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
721:
722: -- debug message
723: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_match_target;
724: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 730: RAISE FND_API.G_EXC_ERROR;

726: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',
727: x_msg_data);
728: END IF;
729:
730: RAISE FND_API.G_EXC_ERROR;
731: END IF;
732:
733: /* Truncate the MATCH table */
734: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

734: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
735: p_table_name => l_match_target
736: ,x_return_status => x_return_status );
737:
738: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
739: -- debug message
740: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_match_target;
741: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
742: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 747: RAISE FND_API.G_EXC_ERROR;

743: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',
744: x_msg_data);
745: END IF;
746:
747: RAISE FND_API.G_EXC_ERROR;
748: END IF;
749:
750: END IF; /* end (l_match_target IS NOT NULL) */
751:

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

763: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
764: p_table_name => l_umatch_target
765: ,x_return_status => x_return_status );
766:
767: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
768:
769: -- debug message
770: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_umatch_target;
771: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 777: RAISE FND_API.G_EXC_ERROR;

773: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',
774: x_msg_data);
775: END IF;
776:
777: RAISE FND_API.G_EXC_ERROR;
778: END IF;
779:
780: /* Truncate the UMATCH table */
781: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

781: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
782: p_table_name => l_umatch_target
783: ,x_return_status => x_return_status );
784:
785: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
786: -- debug message
787: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_umatch_target;
788: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
789: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 794: RAISE FND_API.G_EXC_ERROR;

790: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',
791: x_msg_data);
792: END IF;
793:
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796:
797: END IF; /* end (l_umatch_target IS NOT NULL) */
798:

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

810: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
811: p_table_name => l_winner_target
812: ,x_return_status => x_return_status );
813:
814: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
815:
816: -- debug message
817: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_winner_target;
818: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 824: RAISE FND_API.G_EXC_ERROR;

820: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',
821: x_msg_data);
822: END IF;
823:
824: RAISE FND_API.G_EXC_ERROR;
825: END IF;
826:
827: /* Truncate the WINNER table */
828: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

828: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
829: p_table_name => l_winner_target
830: ,x_return_status => x_return_status );
831:
832: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
833: -- debug message
834: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_winner_target;
835: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
836: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 841: RAISE FND_API.G_EXC_ERROR;

837: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',
838: x_msg_data);
839: END IF;
840:
841: RAISE FND_API.G_EXC_ERROR;
842: END IF;
843:
844: END IF; /* end (l_winner_target IS NOT NULL) */
845:

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

857: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
858: p_table_name => l_uwinner_target
859: ,x_return_status => x_return_status );
860:
861: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
862:
863: -- debug message
864: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_uwinner_target;
865: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 871: RAISE FND_API.G_EXC_ERROR;

867: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',
868: x_msg_data);
869: END IF;
870:
871: RAISE FND_API.G_EXC_ERROR;
872: END IF;
873:
874: /* Truncate the UWINNER table */
875: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

875: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
876: p_table_name => l_uwinner_target
877: ,x_return_status => x_return_status );
878:
879: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
880: -- debug message
881: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_uwinner_target;
882: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
883: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 888: RAISE FND_API.G_EXC_ERROR;

884: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',
885: x_msg_data);
886: END IF;
887:
888: RAISE FND_API.G_EXC_ERROR;
889: END IF;
890:
891: END IF; /* end (l_uwinner_target IS NOT NULL) */
892:

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

904: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
905: p_table_name => l_l1_target
906: ,x_return_status => x_return_status );
907:
908: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
909:
910: -- debug message
911: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l1_target;
912: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 918: RAISE FND_API.G_EXC_ERROR;

914: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l1_clear',
915: x_msg_data);
916: END IF;
917:
918: RAISE FND_API.G_EXC_ERROR;
919: END IF;
920:
921: /* Truncate the L1 table */
922: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

922: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
923: p_table_name => l_l1_target
924: ,x_return_status => x_return_status );
925:
926: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
927: -- debug message
928: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l1_target;
929: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
930: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 935: RAISE FND_API.G_EXC_ERROR;

931: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l1_clear',
932: x_msg_data);
933: END IF;
934:
935: RAISE FND_API.G_EXC_ERROR;
936: END IF;
937:
938: END IF; /* end (l_l1_target IS NOT NULL) */
939:

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

951: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
952: p_table_name => l_l2_target
953: ,x_return_status => x_return_status );
954:
955: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
956:
957: -- debug message
958: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l2_target;
959: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 965: RAISE FND_API.G_EXC_ERROR;

961: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',
962: x_msg_data);
963: END IF;
964:
965: RAISE FND_API.G_EXC_ERROR;
966: END IF;
967:
968: /* Truncate the L2 table */
969: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

969: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
970: p_table_name => l_l2_target
971: ,x_return_status => x_return_status );
972:
973: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
974: -- debug message
975: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l2_target;
976: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
977: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 982: RAISE FND_API.G_EXC_ERROR;

978: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',
979: x_msg_data);
980: END IF;
981:
982: RAISE FND_API.G_EXC_ERROR;
983: END IF;
984:
985: END IF; /* end (l_l2_target IS NOT NULL) */
986:

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

998: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
999: p_table_name => l_l3_target
1000: ,x_return_status => x_return_status );
1001:
1002: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1003:
1004: -- debug message
1005: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l3_target;
1006: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1012: RAISE FND_API.G_EXC_ERROR;

1008: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',
1009: x_msg_data);
1010: END IF;
1011:
1012: RAISE FND_API.G_EXC_ERROR;
1013: END IF;
1014:
1015: /* Truncate the L3 table */
1016: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

1016: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1017: p_table_name => l_l3_target
1018: ,x_return_status => x_return_status );
1019:
1020: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1021: -- debug message
1022: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l3_target;
1023: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1024: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 1029: RAISE FND_API.G_EXC_ERROR;

1025: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',
1026: x_msg_data);
1027: END IF;
1028:
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031:
1032: END IF; /* end (l_l3_target IS NOT NULL) */
1033:

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

1045: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1046: p_table_name => l_l4_target
1047: ,x_return_status => x_return_status );
1048:
1049: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1050:
1051: -- debug message
1052: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l4_target;
1053: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1059: RAISE FND_API.G_EXC_ERROR;

1055: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',
1056: x_msg_data);
1057: END IF;
1058:
1059: RAISE FND_API.G_EXC_ERROR;
1060: END IF;
1061:
1062: /* Truncate the L4 table */
1063: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

1063: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1064: p_table_name => l_l4_target
1065: ,x_return_status => x_return_status );
1066:
1067: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1068: -- debug message
1069: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l4_target;
1070: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1071: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 1076: RAISE FND_API.G_EXC_ERROR;

1072: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',
1073: x_msg_data);
1074: END IF;
1075:
1076: RAISE FND_API.G_EXC_ERROR;
1077: END IF;
1078:
1079: END IF; /* end (l_l4_target IS NOT NULL) */
1080:

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

1092: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1093: p_table_name => l_l5_target
1094: ,x_return_status => x_return_status );
1095:
1096: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1097:
1098: -- debug message
1099: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l5_target;
1100: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1106: RAISE FND_API.G_EXC_ERROR;

1102: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',
1103: x_msg_data);
1104: END IF;
1105:
1106: RAISE FND_API.G_EXC_ERROR;
1107: END IF;
1108:
1109: /* Truncate the L5 table */
1110: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

1110: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1111: p_table_name => l_l5_target
1112: ,x_return_status => x_return_status );
1113:
1114: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1115: -- debug message
1116: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l5_target;
1117: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1118: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 1123: RAISE FND_API.G_EXC_ERROR;

1119: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',
1120: x_msg_data);
1121: END IF;
1122:
1123: RAISE FND_API.G_EXC_ERROR;
1124: END IF;
1125:
1126: END IF; /* end (l_l5_target IS NOT NULL) */
1127:

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

1139: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1140: p_table_name => l_wt_target
1141: ,x_return_status => x_return_status );
1142:
1143: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1144:
1145: -- debug message
1146: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_wt_target;
1147: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1153: RAISE FND_API.G_EXC_ERROR;

1149: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',
1150: x_msg_data);
1151: END IF;
1152:
1153: RAISE FND_API.G_EXC_ERROR;
1154: END IF;
1155:
1156: /* Truncate the WT table */
1157: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

1157: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1158: p_table_name => l_wt_target
1159: ,x_return_status => x_return_status );
1160:
1161: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1162: -- debug message
1163: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_wt_target;
1164: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1165: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 1170: RAISE FND_API.G_EXC_ERROR;

1166: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',
1167: x_msg_data);
1168: END IF;
1169:
1170: RAISE FND_API.G_EXC_ERROR;
1171: END IF;
1172:
1173: END IF; /* end (l_wt_target IS NOT NULL) */
1174:

Line 1210: x_return_status := FND_API.G_RET_STS_ERROR ;

1206: END IF;
1207:
1208: EXCEPTION
1209: WHEN NO_DATA_FOUND THEN
1210: x_return_status := FND_API.G_RET_STS_ERROR ;
1211: RETCODE := 2;
1212: x_msg_count := 1;
1213: x_msg_data := 'No row in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||
1214: ' program name : ' || p_program_name;

Line 1222: WHEN FND_API.G_EXC_ERROR THEN

1218: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Clear_Trans_Data.no_data_found',
1219: x_msg_data);
1220: END IF;
1221:
1222: WHEN FND_API.G_EXC_ERROR THEN
1223: RETCODE := 2;
1224: x_msg_count := 1;
1225: ERRBUF := x_msg_data;
1226: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1229: x_msg_data);
1230: END IF;
1231:
1232: WHEN OTHERS THEN
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1234: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1235: x_msg_count := 1;
1236: ERRBUF := x_msg_data;
1237: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1297: x_return_status := FND_API.G_RET_STS_SUCCESS;

1293: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.begin',
1294: 'Start of the procedure JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup');
1295: END IF;
1296:
1297: x_return_status := FND_API.G_RET_STS_SUCCESS;
1298: l_sysdate := SYSDATE;
1299:
1300: /* Corresponding to the usage, transaction type and program name */
1301: /* get all the interface table names */

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

1433: p_table_name => l_trans_target
1434: , p_percent => p_percent_analyzed
1435: , x_return_status => x_return_status );
1436:
1437: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1438: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP: Call to ' ||
1439: 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' || l_trans_target;
1440: RAISE FND_API.G_EXC_ERROR;
1441: END IF;

Line 1440: RAISE FND_API.G_EXC_ERROR;

1436:
1437: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1438: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP: Call to ' ||
1439: 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' || l_trans_target;
1440: RAISE FND_API.G_EXC_ERROR;
1441: END IF;
1442:
1443: -- debug message
1444: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1452: p_Init_Msg_List => FND_API.G_FALSE,

1448: END IF;
1449:
1450: JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns
1451: (p_Api_Version_Number => 1.0,
1452: p_Init_Msg_List => FND_API.G_FALSE,
1453: p_trans_target => l_trans_target,
1454: p_classify_terr_comb => 'N',
1455: p_process_tx_oin_sel => 'Y',
1456: p_generate_indexes => 'Y',

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

1463: x_Msg_Data => x_msg_data,
1464: errbuf => ERRBUF,
1465: retcode => RETCODE );
1466:
1467: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1468: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP: Call to ' ||
1469: 'JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns API has failed for ' || l_trans_target;
1470: RAISE FND_API.G_EXC_ERROR;
1471: END IF;

Line 1470: RAISE FND_API.G_EXC_ERROR;

1466:
1467: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1468: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP: Call to ' ||
1469: 'JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns API has failed for ' || l_trans_target;
1470: RAISE FND_API.G_EXC_ERROR;
1471: END IF;
1472:
1473: -- debug message
1474: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1486: p_mode => p_mode,
1487: x_Return_Status => x_return_status,
1488: p_run_mode => 'MATCH');
1489:
1490: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1491: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_match_target;
1492: RAISE FND_API.G_EXC_ERROR;
1493: END IF;
1494:

Line 1492: RAISE FND_API.G_EXC_ERROR;

1488: p_run_mode => 'MATCH');
1489:
1490: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1491: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_match_target;
1492: RAISE FND_API.G_EXC_ERROR;
1493: END IF;
1494:
1495: -- debug message
1496: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1508: p_mode => p_mode,
1509: x_Return_Status => x_return_status,
1510: p_run_mode => 'WINNER');
1511:
1512: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1513: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_winner_target;
1514: RAISE FND_API.G_EXC_ERROR;
1515: END IF;
1516:

Line 1514: RAISE FND_API.G_EXC_ERROR;

1510: p_run_mode => 'WINNER');
1511:
1512: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1513: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_winner_target;
1514: RAISE FND_API.G_EXC_ERROR;
1515: END IF;
1516:
1517: -- debug message
1518: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1530: p_mode => p_mode,
1531: x_Return_Status => x_return_status,
1532: p_run_mode => 'TEMP_WINNER');
1533:
1534: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1535: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l1_target;
1536: RAISE FND_API.G_EXC_ERROR;
1537: END IF;
1538:

Line 1536: RAISE FND_API.G_EXC_ERROR;

1532: p_run_mode => 'TEMP_WINNER');
1533:
1534: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1535: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l1_target;
1536: RAISE FND_API.G_EXC_ERROR;
1537: END IF;
1538:
1539: -- debug message
1540: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1552: p_mode => p_mode,
1553: x_Return_Status => x_return_status,
1554: p_run_mode => 'TEMP_WINNER');
1555:
1556: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1557: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l2_target;
1558: RAISE FND_API.G_EXC_ERROR;
1559: END IF;
1560:

Line 1558: RAISE FND_API.G_EXC_ERROR;

1554: p_run_mode => 'TEMP_WINNER');
1555:
1556: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1557: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l2_target;
1558: RAISE FND_API.G_EXC_ERROR;
1559: END IF;
1560:
1561:
1562: -- debug message

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

1575: p_mode => p_mode,
1576: x_Return_Status => x_return_status,
1577: p_run_mode => 'TEMP_WINNER');
1578:
1579: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1580: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l3_target;
1581: RAISE FND_API.G_EXC_ERROR;
1582: END IF;
1583:

Line 1581: RAISE FND_API.G_EXC_ERROR;

1577: p_run_mode => 'TEMP_WINNER');
1578:
1579: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1580: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l3_target;
1581: RAISE FND_API.G_EXC_ERROR;
1582: END IF;
1583:
1584: -- debug message
1585: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1597: p_mode => p_mode,
1598: x_Return_Status => x_return_status,
1599: p_run_mode => 'TEMP_WINNER');
1600:
1601: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1602: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l4_target;
1603: RAISE FND_API.G_EXC_ERROR;
1604: END IF;
1605:

Line 1603: RAISE FND_API.G_EXC_ERROR;

1599: p_run_mode => 'TEMP_WINNER');
1600:
1601: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1602: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l4_target;
1603: RAISE FND_API.G_EXC_ERROR;
1604: END IF;
1605:
1606: -- debug message
1607: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1619: p_mode => p_mode,
1620: x_Return_Status => x_return_status,
1621: p_run_mode => 'TEMP_WINNER');
1622:
1623: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1624: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l5_target;
1625: RAISE FND_API.G_EXC_ERROR;
1626: END IF;
1627:

Line 1625: RAISE FND_API.G_EXC_ERROR;

1621: p_run_mode => 'TEMP_WINNER');
1622:
1623: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1624: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l5_target;
1625: RAISE FND_API.G_EXC_ERROR;
1626: END IF;
1627:
1628: -- debug message
1629: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1641: p_mode => p_mode,
1642: x_Return_Status => x_return_status,
1643: p_run_mode => 'TEMP_WINNER');
1644:
1645: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1646: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_wt_target;
1647: RAISE FND_API.G_EXC_ERROR;
1648: END IF;
1649:

Line 1647: RAISE FND_API.G_EXC_ERROR;

1643: p_run_mode => 'TEMP_WINNER');
1644:
1645: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1646: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_wt_target;
1647: RAISE FND_API.G_EXC_ERROR;
1648: END IF;
1649:
1650: /* if mode is incremental, update the worker_id column for the TRANS table */
1651: IF (p_mode = 'INCREMENTAL') THEN

Line 1666: x_return_status := FND_API.G_RET_STS_SUCCESS;

1662: END IF;
1663:
1664: EXCEPTION
1665: WHEN NO_TAE_DATA_FOUND THEN
1666: x_return_status := FND_API.G_RET_STS_SUCCESS;
1667: x_msg_count := 1;
1668: RETCODE := 0;
1669: ERRBUF := null;
1670: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1676: WHEN FND_API.G_EXC_ERROR THEN

1672: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.no_tae_data_found',
1673: x_msg_data);
1674: END IF;
1675:
1676: WHEN FND_API.G_EXC_ERROR THEN
1677: x_return_status := FND_API.G_RET_STS_ERROR;
1678: x_msg_count := 1;
1679: RETCODE := 2;
1680: ERRBUF := x_msg_data;

Line 1677: x_return_status := FND_API.G_RET_STS_ERROR;

1673: x_msg_data);
1674: END IF;
1675:
1676: WHEN FND_API.G_EXC_ERROR THEN
1677: x_return_status := FND_API.G_RET_STS_ERROR;
1678: x_msg_count := 1;
1679: RETCODE := 2;
1680: ERRBUF := x_msg_data;
1681: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1683: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.g_exc_error',
1684: x_msg_data);
1685: END IF;
1686:
1687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1689: x_msg_count := 1;
1690: RETCODE := 2;
1691: ERRBUF := x_msg_data;

Line 1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1684: x_msg_data);
1685: END IF;
1686:
1687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1689: x_msg_count := 1;
1690: RETCODE := 2;
1691: ERRBUF := x_msg_data;
1692: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1695: x_msg_data);
1696: END IF;
1697:
1698: WHEN OTHERS THEN
1699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1700: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1701: x_msg_count := 1;
1702: RETCODE := 2;
1703: ERRBUF := x_msg_data;

Line 1741: x_return_status := FND_API.G_RET_STS_SUCCESS;

1737: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.start',
1738: 'Start of the procedure JTY_ASSIGN_BULK_PUB.Process_Level_Winners');
1739: END IF;
1740:
1741: x_return_status := FND_API.G_RET_STS_SUCCESS;
1742:
1743: IF (p_date_effective) THEN
1744: l_denorm_table_name := 'JTY_DENORM_DEA_RULES_ALL';
1745: ELSE

Line 2035: WHEN FND_API.G_EXC_ERROR THEN

2031: END IF;
2032:
2033: EXCEPTION
2034:
2035: WHEN FND_API.G_EXC_ERROR THEN
2036: x_return_status := FND_API.G_RET_STS_ERROR;
2037: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2038: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2039: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.other',

Line 2036: x_return_status := FND_API.G_RET_STS_ERROR;

2032:
2033: EXCEPTION
2034:
2035: WHEN FND_API.G_EXC_ERROR THEN
2036: x_return_status := FND_API.G_RET_STS_ERROR;
2037: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2038: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2039: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.other',
2040: 'JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed with FND_API.G_EXC_ERROR exception for ' ||

Line 2040: 'JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed with FND_API.G_EXC_ERROR exception for ' ||

2036: x_return_status := FND_API.G_RET_STS_ERROR;
2037: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2038: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2039: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.other',
2040: 'JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed with FND_API.G_EXC_ERROR exception for ' ||
2041: 'UPPER LEVEL : ' || p_UPPER_LEVEL_FROM_ROOT || ' LOWER LEVEL : ' || p_LOWER_LEVEL_FROM_ROOT);
2042: END IF;
2043:
2044: WHEN OTHERS THEN

Line 2045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2041: 'UPPER LEVEL : ' || p_UPPER_LEVEL_FROM_ROOT || ' LOWER LEVEL : ' || p_LOWER_LEVEL_FROM_ROOT);
2042: END IF;
2043:
2044: WHEN OTHERS THEN
2045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2046: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2047: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2048: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.other',
2049: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));

Line 2082: x_return_status := FND_API.G_RET_STS_SUCCESS;

2078: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners.start',
2079: 'Start of the procedure JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners');
2080: END IF;
2081:
2082: x_return_status := FND_API.G_RET_STS_SUCCESS;
2083:
2084: IF (p_date_effective) THEN
2085: l_denorm_table_name := 'JTY_DENORM_DEA_RULES_ALL';
2086: ELSE

Line 2186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2182: END IF;
2183:
2184: EXCEPTION
2185: WHEN OTHERS THEN
2186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2187: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2188: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
2189: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners.other',
2190: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));

Line 2258: x_return_status := FND_API.G_RET_STS_SUCCESS;

2254: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.start',
2255: 'Start of the procedure JTY_ASSIGN_BULK_PUB.process_nmc_match');
2256: END IF;
2257:
2258: x_return_status := FND_API.G_RET_STS_SUCCESS;
2259:
2260: /* Get the schema name corresponding to JTF application */
2261: IF (FND_INSTALLATION.GET_APP_INFO('JTF', l_status, l_industry, l_owner)) THEN
2262: NULL;

Line 2396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2392: END IF;
2393:
2394: EXCEPTION
2395: WHEN L_SCHEMA_NOTFOUND THEN
2396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2397: x_msg_data := 'Schema name corresponding to JTF application not found';
2398: RETCODE := 2;
2399: x_msg_count := 1;
2400: ERRBUF := x_msg_data;

Line 2408: x_return_status := FND_API.G_RET_STS_ERROR ;

2404: 'Schema name corresponding to the JTF application not found');
2405: END IF;
2406:
2407: WHEN NO_DATA_FOUND THEN
2408: x_return_status := FND_API.G_RET_STS_ERROR ;
2409: RETCODE := 2;
2410: x_msg_count := 1;
2411: ERRBUF := x_msg_data;
2412: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2415: x_msg_data);
2416: END IF;
2417:
2418: WHEN OTHERS THEN
2419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2420: x_msg_data := SQLCODE || ' : ' || SQLERRM;
2421: x_msg_count := 1;
2422: RETCODE := 2;
2423: ERRBUF := x_msg_data;

Line 2474: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2470: 'Start of the procedure JTY_ASSIGN_BULK_PUB.collect_trans_data');
2471: END IF;
2472:
2473: /* Standard call to check for call compatibility. */
2474: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2475: p_api_version_number,
2476: l_api_name,
2477: G_PKG_NAME) THEN
2478:

Line 2479: x_msg_data := 'API FND_API.Compatible_API_Call has failed';

2475: p_api_version_number,
2476: l_api_name,
2477: G_PKG_NAME) THEN
2478:
2479: x_msg_data := 'API FND_API.Compatible_API_Call has failed';
2480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2481: END IF;
2482:
2483: /* Initialize message list if p_init_msg_list is set to TRUE. */

Line 2480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2476: l_api_name,
2477: G_PKG_NAME) THEN
2478:
2479: x_msg_data := 'API FND_API.Compatible_API_Call has failed';
2480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2481: END IF;
2482:
2483: /* Initialize message list if p_init_msg_list is set to TRUE. */
2484: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2484: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2481: END IF;
2482:
2483: /* Initialize message list if p_init_msg_list is set to TRUE. */
2484: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2485: FND_MSG_PUB.initialize;
2486: END IF;
2487:
2488: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2488: x_return_status := FND_API.G_RET_STS_SUCCESS;

2484: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2485: FND_MSG_PUB.initialize;
2486: END IF;
2487:
2488: x_return_status := FND_API.G_RET_STS_SUCCESS;
2489:
2490: -- debug message
2491: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2492: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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

2508: x_msg_data => x_msg_data,
2509: errbuf => errbuf,
2510: retcode => retcode);
2511:
2512: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2513: -- debug message
2514: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.clear_trans_data has failed';
2515: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2516: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 2521: RAISE FND_API.G_EXC_ERROR;

2517: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.clear_trans_data',
2518: x_msg_data);
2519: END IF;
2520:
2521: RAISE FND_API.G_EXC_ERROR;
2522: END IF;
2523:
2524: -- debug message
2525: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2542: x_msg_data => x_msg_data,
2543: errbuf => errbuf,
2544: retcode => retcode);
2545:
2546: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2547: -- debug message
2548: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.insert_trans_data has failed';
2549: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2550: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 2555: RAISE FND_API.G_EXC_ERROR;

2551: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.insert_trans_data',
2552: x_msg_data);
2553: END IF;
2554:
2555: RAISE FND_API.G_EXC_ERROR;
2556: END IF;
2557:
2558: -- debug message
2559: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2576: x_msg_data => x_msg_data,
2577: errbuf => errbuf,
2578: retcode => retcode);
2579:
2580: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2581: -- debug message
2582: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.process_nmc_match has failed';
2583: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2584: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 2589: RAISE FND_API.G_EXC_ERROR;

2585: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.process_nmc_match',
2586: x_msg_data);
2587: END IF;
2588:
2589: RAISE FND_API.G_EXC_ERROR;
2590: END IF;
2591:
2592: -- debug message
2593: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2607: x_msg_data => x_msg_data,
2608: errbuf => errbuf,
2609: retcode => retcode);
2610:
2611: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2612: -- debug message
2613: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.insert_nm_trans_data has failed';
2614: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2615: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 2620: RAISE FND_API.G_EXC_ERROR;

2616: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.insert_nm_trans_data',
2617: x_msg_data);
2618: END IF;
2619:
2620: RAISE FND_API.G_EXC_ERROR;
2621: END IF;
2622:
2623: -- debug message
2624: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2643: ERRBUF => ERRBUF,
2644: RETCODE => RETCODE
2645: );
2646:
2647: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2648: -- debug message
2649: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup has failed';
2650: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2651: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 2656: RAISE FND_API.G_EXC_ERROR;

2652: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.get_winners_parallel_setup',
2653: x_msg_data);
2654: END IF;
2655:
2656: RAISE FND_API.G_EXC_ERROR;
2657: END IF;
2658:
2659: retcode := 0;
2660: errbuf := null;

Line 2670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2666: 'End of the procedure JTY_ASSIGN_BULK_PUB.collect_trans_data');
2667: END IF;
2668:
2669: EXCEPTION
2670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2672: x_msg_count := 1;
2673: RETCODE := 2;
2674: ERRBUF := x_msg_data;

Line 2671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2667: END IF;
2668:
2669: EXCEPTION
2670: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2672: x_msg_count := 1;
2673: RETCODE := 2;
2674: ERRBUF := x_msg_data;
2675: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2682: x_return_status := FND_API.G_RET_STS_ERROR ;

2678: x_msg_data);
2679: END IF;
2680:
2681: WHEN NO_DATA_FOUND THEN
2682: x_return_status := FND_API.G_RET_STS_ERROR ;
2683: RETCODE := 2;
2684: x_msg_count := 1;
2685: ERRBUF := x_msg_data;
2686: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2692: WHEN FND_API.G_EXC_ERROR THEN

2688: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.no_data_found',
2689: x_msg_data);
2690: END IF;
2691:
2692: WHEN FND_API.G_EXC_ERROR THEN
2693: RETCODE := 2;
2694: x_msg_count := 1;
2695: ERRBUF := x_msg_data;
2696: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2699: x_msg_data);
2700: END IF;
2701:
2702: WHEN OTHERS THEN
2703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2704: x_msg_data := SQLCODE || ' : ' || SQLERRM;
2705: x_msg_count := 1;
2706: RETCODE := 2;
2707: ERRBUF := x_msg_data;

Line 2776: x_return_status := FND_API.G_RET_STS_SUCCESS;

2772: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.start',
2773: 'Start of the procedure JTY_ASSIGN_BULK_PUB.process_winner');
2774: END IF;
2775:
2776: x_return_status := FND_API.G_RET_STS_SUCCESS;
2777: lp_sysdate := SYSDATE;
2778:
2779: IF (p_mode = 'DATE EFFECTIVE') THEN
2780: l_date_effective := true;

Line 2992: x_return_status := FND_API.G_RET_STS_SUCCESS;

2988: END IF;
2989:
2990: IF ((l_max_terr IS NULL) OR (l_max_terr = 0)) THEN
2991: x_msg_data := 'No row in ' || l_match_target || ' for worker_id = ' || p_worker_id;
2992: x_return_status := FND_API.G_RET_STS_SUCCESS;
2993: RETCODE := 0;
2994: x_msg_count := 1;
2995: ERRBUF := null;
2996: RAISE L_NO_MATCH_TERR;

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

3245: x_return_status => x_return_status,
3246: p_worker_id => p_worker_id
3247: );
3248:
3249: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3250: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3251: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3252: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l1',
3253: x_msg_data);

Line 3255: RAISE FND_API.G_EXC_ERROR;

3251: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3252: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l1',
3253: x_msg_data);
3254: END IF;
3255: RAISE FND_API.G_EXC_ERROR;
3256: END IF;
3257:
3258: COMMIT;
3259:

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

3262: p_table_name => l_L1_target
3263: , p_percent => p_percent_analyzed
3264: , x_return_status => x_return_status );
3265:
3266: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3267: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L1_target;
3268: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3269: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3270: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l1_analyze',

Line 3273: RAISE FND_API.G_EXC_ERROR;

3269: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3270: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l1_analyze',
3271: x_msg_data);
3272: END IF;
3273: RAISE FND_API.G_EXC_ERROR;
3274: END IF;
3275: */
3276:
3277: /* Process second level */

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

3287: x_return_status => x_return_status,
3288: p_worker_id => p_worker_id
3289: );
3290:
3291: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3292: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3293: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3294: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l2',
3295: x_msg_data);

Line 3297: RAISE FND_API.G_EXC_ERROR;

3293: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3294: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l2',
3295: x_msg_data);
3296: END IF;
3297: RAISE FND_API.G_EXC_ERROR;
3298: END IF;
3299:
3300: COMMIT;
3301:

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

3304: p_table_name => l_L2_target
3305: , p_percent => p_percent_analyzed
3306: , x_return_status => x_return_status );
3307:
3308: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3309: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L2_target;
3310: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3311: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3312: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l2_analyze',

Line 3315: RAISE FND_API.G_EXC_ERROR;

3311: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3312: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l2_analyze',
3313: x_msg_data);
3314: END IF;
3315: RAISE FND_API.G_EXC_ERROR;
3316: END IF;
3317: */
3318:
3319: /* Process third level */

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

3329: x_return_status => x_return_status,
3330: p_worker_id => p_worker_id
3331: );
3332:
3333: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3334: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3335: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3336: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l3',
3337: x_msg_data);

Line 3339: RAISE FND_API.G_EXC_ERROR;

3335: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3336: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l3',
3337: x_msg_data);
3338: END IF;
3339: RAISE FND_API.G_EXC_ERROR;
3340: END IF;
3341:
3342: COMMIT;
3343:

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

3346: p_table_name => l_L3_target
3347: , p_percent => p_percent_analyzed
3348: , x_return_status => x_return_status );
3349:
3350: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3351: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L3_target;
3352: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3353: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3354: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l3_analyze',

Line 3357: RAISE FND_API.G_EXC_ERROR;

3353: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3354: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l3_analyze',
3355: x_msg_data);
3356: END IF;
3357: RAISE FND_API.G_EXC_ERROR;
3358: END IF;
3359: */
3360:
3361: /* Process fourth level */

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

3371: x_return_status => x_return_status,
3372: p_worker_id => p_worker_id
3373: );
3374:
3375: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3376: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3377: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3378: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l4',
3379: x_msg_data);

Line 3381: RAISE FND_API.G_EXC_ERROR;

3377: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3378: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l4',
3379: x_msg_data);
3380: END IF;
3381: RAISE FND_API.G_EXC_ERROR;
3382: END IF;
3383:
3384: COMMIT;
3385:

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

3388: p_table_name => l_L4_target
3389: , p_percent => p_percent_analyzed
3390: , x_return_status => x_return_status );
3391:
3392: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3393: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L4_target;
3394: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3395: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3396: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l4_analyze',

Line 3399: RAISE FND_API.G_EXC_ERROR;

3395: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3396: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l4_analyze',
3397: x_msg_data);
3398: END IF;
3399: RAISE FND_API.G_EXC_ERROR;
3400: END IF;
3401: */
3402:
3403: /* Process fifth level */

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

3413: x_return_status => x_return_status,
3414: p_worker_id => p_worker_id
3415: );
3416:
3417: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3418: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3419: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3420: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l5',
3421: x_msg_data);

Line 3423: RAISE FND_API.G_EXC_ERROR;

3419: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3420: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l5',
3421: x_msg_data);
3422: END IF;
3423: RAISE FND_API.G_EXC_ERROR;
3424: END IF;
3425:
3426: COMMIT;
3427:

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

3430: p_table_name => l_L5_target
3431: , p_percent => p_percent_analyzed
3432: , x_return_status => x_return_status );
3433:
3434: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3435: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L5_target;
3436: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3437: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3438: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l5_analyze',

Line 3441: RAISE FND_API.G_EXC_ERROR;

3437: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3438: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l5_analyze',
3439: x_msg_data);
3440: END IF;
3441: RAISE FND_API.G_EXC_ERROR;
3442: END IF;
3443: */
3444:
3445: /* Process final level */

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

3453: x_return_status => x_return_status,
3454: p_worker_id => p_worker_id
3455: );
3456:
3457: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3458: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3459: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3460: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.wt',
3461: x_msg_data);

Line 3463: RAISE FND_API.G_EXC_ERROR;

3459: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3460: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.wt',
3461: x_msg_data);
3462: END IF;
3463: RAISE FND_API.G_EXC_ERROR;
3464: END IF;
3465:
3466: COMMIT;
3467:

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

3470: p_table_name => l_wt_target
3471: , p_percent => p_percent_analyzed
3472: , x_return_status => x_return_status );
3473:
3474: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3475: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_wt_target;
3476: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3477: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3478: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.wt_analyze',

Line 3481: RAISE FND_API.G_EXC_ERROR;

3477: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3478: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.wt_analyze',
3479: x_msg_data);
3480: END IF;
3481: RAISE FND_API.G_EXC_ERROR;
3482: END IF;
3483: */
3484:
3485: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3787: p_table_name => l_winner_target
3788: , p_percent => p_percent_analyzed
3789: , x_return_status => x_return_status );
3790:
3791: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3792: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_winner_target;
3793: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3794: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3795: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner_analyze',

Line 3798: RAISE FND_API.G_EXC_ERROR;

3794: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
3795: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner_analyze',
3796: x_msg_data);
3797: END IF;
3798: RAISE FND_API.G_EXC_ERROR;
3799: END IF;
3800:
3801: /* Program completed successfully */
3802: ERRBUF := null;

Line 3803: x_return_status := FND_API.G_RET_STS_SUCCESS;

3799: END IF;
3800:
3801: /* Program completed successfully */
3802: ERRBUF := null;
3803: x_return_status := FND_API.G_RET_STS_SUCCESS;
3804: RETCODE := 0;
3805:
3806: -- debug message
3807: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3811: END IF;
3812:
3813: EXCEPTION
3814: WHEN L_SCHEMA_NOTFOUND THEN
3815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3816: x_msg_data := 'Schema name corresponding to the FND application not found';
3817: RETCODE := 2;
3818: x_msg_count := 1;
3819: ERRBUF := x_msg_data;

Line 3827: x_return_status := FND_API.G_RET_STS_ERROR ;

3823: x_msg_data);
3824: END IF;
3825:
3826: WHEN NO_DATA_FOUND THEN
3827: x_return_status := FND_API.G_RET_STS_ERROR ;
3828: RETCODE := 2;
3829: x_msg_count := 1;
3830: ERRBUF := x_msg_data;
3831: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3844: WHEN FND_API.G_EXC_ERROR THEN

3840: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.l_no_match_terr',
3841: x_msg_data);
3842: END IF;
3843:
3844: WHEN FND_API.G_EXC_ERROR THEN
3845: x_return_status := FND_API.G_RET_STS_ERROR ;
3846: RETCODE := 2;
3847: x_msg_count := 1;
3848: ERRBUF := x_msg_data;

Line 3845: x_return_status := FND_API.G_RET_STS_ERROR ;

3841: x_msg_data);
3842: END IF;
3843:
3844: WHEN FND_API.G_EXC_ERROR THEN
3845: x_return_status := FND_API.G_RET_STS_ERROR ;
3846: RETCODE := 2;
3847: x_msg_count := 1;
3848: ERRBUF := x_msg_data;
3849: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3852: x_msg_data);
3853: END IF;
3854:
3855: WHEN OTHERS THEN
3856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3857: x_msg_data := SQLCODE || ' : ' || SQLERRM;
3858: x_msg_count := 1;
3859: RETCODE := 2;
3860: ERRBUF := x_msg_data;

Line 3924: x_return_status := FND_API.G_RET_STS_SUCCESS;

3920: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.start',
3921: 'Start of the procedure JTY_ASSIGN_BULK_PUB.process_match');
3922: END IF;
3923:
3924: x_return_status := FND_API.G_RET_STS_SUCCESS;
3925: l_sysdate := SYSDATE;
3926:
3927: BEGIN
3928: SELECT decode(p_mode, 'TOTAL', tup.batch_trans_table_name

Line 3950: x_return_status := FND_API.G_RET_STS_SUCCESS;

3946: EXECUTE IMMEDIATE l_sql_stmt INTO l_no_of_records USING p_worker_id;
3947:
3948: IF (l_no_of_records <= 0) THEN
3949: x_msg_data := 'No row in ' || l_trans_target || ' for worker_id = ' || p_worker_id;
3950: x_return_status := FND_API.G_RET_STS_SUCCESS;
3951: RETCODE := 0;
3952: x_msg_count := 1;
3953: ERRBUF := null;
3954: RAISE FND_API.G_EXC_ERROR;

Line 3954: RAISE FND_API.G_EXC_ERROR;

3950: x_return_status := FND_API.G_RET_STS_SUCCESS;
3951: RETCODE := 0;
3952: x_msg_count := 1;
3953: ERRBUF := null;
3954: RAISE FND_API.G_EXC_ERROR;
3955: END IF;
3956:
3957: IF (p_mode = 'DATE EFFECTIVE') THEN
3958:

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

4017: p_table_name => l_match_target
4018: , p_percent => p_percent_analyzed
4019: , x_return_status => x_return_status );
4020:
4021: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4022: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4023: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4024: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.analyze_match',
4025: 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for table : ' || l_match_target);

Line 4028: RAISE FND_API.G_EXC_ERROR;

4024: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.analyze_match',
4025: 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for table : ' || l_match_target);
4026: END IF;
4027:
4028: RAISE FND_API.G_EXC_ERROR;
4029: RETCODE := 2;
4030: x_msg_count := 1;
4031: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for table : ' || l_match_target;
4032: errbuf := x_msg_data;

Line 4044: x_return_status := FND_API.G_RET_STS_ERROR ;

4040: END IF;
4041:
4042: EXCEPTION
4043: WHEN NO_DATA_FOUND THEN
4044: x_return_status := FND_API.G_RET_STS_ERROR ;
4045: RETCODE := 2;
4046: x_msg_count := 1;
4047: ERRBUF := x_msg_data;
4048: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4054: WHEN FND_API.G_EXC_ERROR THEN

4050: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.no_data_found',
4051: x_msg_data);
4052: END IF;
4053:
4054: WHEN FND_API.G_EXC_ERROR THEN
4055: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4056: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4057: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.g_exc_error',
4058: x_msg_data);

Line 4062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4058: x_msg_data);
4059: END IF;
4060:
4061: WHEN OTHERS THEN
4062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4063: x_msg_data := SQLCODE || ' : ' || SQLERRM;
4064: x_msg_count := 1;
4065: RETCODE := 2;
4066: ERRBUF := x_msg_data;

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

4083: -- transaction objs, it supports multiple worker architecture
4084: --
4085: PROCEDURE get_winners
4086: ( p_api_version_number IN NUMBER,
4087: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4088: p_source_id IN NUMBER,
4089: p_trans_id IN NUMBER,
4090: p_program_name IN VARCHAR2,
4091: p_mode IN VARCHAR2,

Line 4114: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

4110: 'Start of the procedure JTY_ASSIGN_BULK_PUB.get_winners');
4111: END IF;
4112:
4113: /* Standard call to check for call compatibility. */
4114: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4115: p_api_version_number,
4116: l_api_name,
4117: G_PKG_NAME) THEN
4118:

Line 4119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4115: p_api_version_number,
4116: l_api_name,
4117: G_PKG_NAME) THEN
4118:
4119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4120: END IF;
4121:
4122: /* Initialize message list if p_init_msg_list is set to TRUE. */
4123: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 4123: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4120: END IF;
4121:
4122: /* Initialize message list if p_init_msg_list is set to TRUE. */
4123: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4124: FND_MSG_PUB.initialize;
4125: END IF;
4126:
4127: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4127: x_return_status := FND_API.G_RET_STS_SUCCESS;

4123: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4124: FND_MSG_PUB.initialize;
4125: END IF;
4126:
4127: x_return_status := FND_API.G_RET_STS_SUCCESS;
4128:
4129: -- debug message
4130: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4131: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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

4147: x_msg_data => x_msg_data,
4148: errbuf => errbuf,
4149: retcode => retcode);
4150:
4151: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4152: -- debug message
4153: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4154: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4155: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.match',

Line 4160: RAISE FND_API.G_EXC_ERROR;

4156: 'process_match API has failed for source : ' || p_source_id || ' trans : ' || p_trans_id ||
4157: ' program name : ' || p_program_name);
4158: END IF;
4159:
4160: RAISE FND_API.G_EXC_ERROR;
4161: END IF;
4162:
4163: -- debug message
4164: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

4180: x_msg_data => x_msg_data,
4181: errbuf => errbuf,
4182: retcode => retcode);
4183:
4184: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4185: -- debug message
4186: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4187: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,
4188: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner',

Line 4193: RAISE FND_API.G_EXC_ERROR;

4189: 'process_winners API has failed for source : ' || p_source_id || ' trans : ' || p_trans_id ||
4190: ' program name : ' || p_program_name);
4191: END IF;
4192:
4193: RAISE FND_API.G_EXC_ERROR;
4194: END IF;
4195:
4196: -- debug message
4197: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4211: WHEN FND_API.G_EXC_ERROR THEN

4207: 'End of the procedure JTY_ASSIGN_BULK_PUB.get_winners');
4208: END IF;
4209:
4210: EXCEPTION
4211: WHEN FND_API.G_EXC_ERROR THEN
4212: x_return_status := FND_API.G_RET_STS_ERROR ;
4213: RETCODE := 2;
4214: x_msg_count := 1;
4215: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4212: x_return_status := FND_API.G_RET_STS_ERROR ;

4208: END IF;
4209:
4210: EXCEPTION
4211: WHEN FND_API.G_EXC_ERROR THEN
4212: x_return_status := FND_API.G_RET_STS_ERROR ;
4213: RETCODE := 2;
4214: x_msg_count := 1;
4215: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4216: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 4222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4218: x_msg_data);
4219: END IF;
4220:
4221: WHEN OTHERS THEN
4222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4223: x_msg_data := SQLCODE || ' : ' || SQLERRM;
4224: x_msg_count := 1;
4225: RETCODE := 2;
4226: ERRBUF := x_msg_data;