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.JTY_ASSIGN_BULK_PUB dependencies on FND_API

Line 109: x_return_status := FND_API.G_RET_STS_SUCCESS;

105: jty_log(FND_LOG.LEVEL_PROCEDURE,
106: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.begin',
107: 'Start of the procedure JTY_ASSIGN_BULK_PUB.insert_nm_trans_data ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
108:
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110: l_sysdate := SYSDATE;
111:
112: /* Get the NM_TRANS table name */
113: BEGIN

Line 237: x_return_status := FND_API.G_RET_STS_ERROR ;

233: 'End of the procedure JTY_ASSIGN_BULK_PUB.insert_nm_trans_data ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
234:
235: EXCEPTION
236: WHEN L_SEED_DATA_NOTFOUND THEN
237: x_return_status := FND_API.G_RET_STS_ERROR ;
238: RETCODE := 2;
239: x_msg_count := 1;
240: ERRBUF := x_msg_data;
241: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

242: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.l_seed_data_notfound',
243: x_msg_data);
244:
245: WHEN L_SCHEMA_NOTFOUND THEN
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
247: RETCODE := 2;
248: x_msg_data := 'JTY_ASSIGN_BULK_PUB.insert_nm_trans_data: SCHEMA NAME NOT FOUND CORRESPONDING TO JTF APPLICATION. ';
249: ERRBUF := x_msg_data;
250: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 255: x_return_status := FND_API.G_RET_STS_ERROR ;

251: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.l_schema_notfound',
252: x_msg_data);
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: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

260: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.no_data_found',
261: x_msg_data);
262:
263: WHEN OTHERS THEN
264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
265: x_msg_data := SQLCODE || ' : ' || SQLERRM;
266: x_msg_count := 1;
267: ERRBUF := x_msg_data;
268: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 334: x_return_status := FND_API.G_RET_STS_SUCCESS;

330: jty_log(FND_LOG.LEVEL_PROCEDURE,
331: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.begin',
332: 'Start of the procedure JTY_ASSIGN_BULK_PUB.insert_trans_data ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
333:
334: x_return_status := FND_API.G_RET_STS_SUCCESS;
335: l_sysdate := SYSDATE;
336:
337: /* Number of workers is restricted from 1 to 10 */
338: IF (p_oic_mode = 'NOOIC') THEN

Line 520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

516: 'End of the procedure JTY_ASSIGN_BULK_PUB.insert_trans_data ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
517:
518: EXCEPTION
519: WHEN L_INVALID_WORKERS THEN
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
521: RETCODE := 2;
522: x_msg_data := 'JTY_ASSIGN_BULK_PUB.insert_trans_data: Invalid number of workers : Valid range from 1 - 10';
523: ERRBUF := x_msg_data;
524: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 529: x_return_status := FND_API.G_RET_STS_ERROR ;

525: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.l_invalid_workers',
526: x_msg_data);
527:
528: WHEN L_SEED_DATA_NOTFOUND THEN
529: x_return_status := FND_API.G_RET_STS_ERROR ;
530: RETCODE := 2;
531: x_msg_count := 1;
532: ERRBUF := x_msg_data;
533: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

534: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.l_seed_data_notfound',
535: x_msg_data);
536:
537: WHEN L_SCHEMA_NOTFOUND THEN
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
539: RETCODE := 2;
540: x_msg_data := 'JTY_ASSIGN_BULK_PUB.insert_trans_data: SCHEMA NAME NOT FOUND CORRESPONDING TO JTF APPLICATION. ';
541: ERRBUF := x_msg_data;
542: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 547: x_return_status := FND_API.G_RET_STS_ERROR ;

543: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.l_schema_notfound',
544: x_msg_data);
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: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

552: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.no_data_found',
553: x_msg_data);
554:
555: WHEN OTHERS THEN
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
557: x_msg_data := SQLCODE || ' : ' || SQLERRM;
558: x_msg_count := 1;
559: ERRBUF := x_msg_data;
560: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

660: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
661: p_table_name => l_trans_target
662: ,x_return_status => x_return_status );
663:
664: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
665: -- debug message
666: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_trans_target;
667: jty_log(FND_LOG.LEVEL_EXCEPTION,
668: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',

Line 671: RAISE FND_API.G_EXC_ERROR;

667: jty_log(FND_LOG.LEVEL_EXCEPTION,
668: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',
669: x_msg_data);
670:
671: RAISE FND_API.G_EXC_ERROR;
672: END IF;
673:
674: /* Truncate the TRANS table */
675: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

675: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
676: p_table_name => l_trans_target
677: ,x_return_status => x_return_status );
678:
679: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
680: -- debug message
681: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_trans_target;
682: jty_log(FND_LOG.LEVEL_EXCEPTION,
683: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',

Line 686: RAISE FND_API.G_EXC_ERROR;

682: jty_log(FND_LOG.LEVEL_EXCEPTION,
683: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',
684: x_msg_data);
685:
686: RAISE FND_API.G_EXC_ERROR;
687: END IF;
688:
689: END IF; /* end IF (l_trans_target IS NOT NULL) */
690:

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

700: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
701: p_table_name => l_match_target
702: ,x_return_status => x_return_status );
703:
704: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
705:
706: -- debug message
707: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_match_target;
708: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 712: RAISE FND_API.G_EXC_ERROR;

708: jty_log(FND_LOG.LEVEL_EXCEPTION,
709: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',
710: x_msg_data);
711:
712: RAISE FND_API.G_EXC_ERROR;
713: END IF;
714:
715: /* Truncate the MATCH table */
716: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

716: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
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: -- debug message
722: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_match_target;
723: jty_log(FND_LOG.LEVEL_EXCEPTION,
724: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',

Line 727: RAISE FND_API.G_EXC_ERROR;

723: jty_log(FND_LOG.LEVEL_EXCEPTION,
724: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',
725: x_msg_data);
726:
727: RAISE FND_API.G_EXC_ERROR;
728: END IF;
729:
730: END IF; /* end (l_match_target IS NOT NULL) */
731:

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

741: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
742: p_table_name => l_umatch_target
743: ,x_return_status => x_return_status );
744:
745: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
746:
747: -- debug message
748: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_umatch_target;
749: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 753: RAISE FND_API.G_EXC_ERROR;

749: jty_log(FND_LOG.LEVEL_EXCEPTION,
750: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',
751: x_msg_data);
752:
753: RAISE FND_API.G_EXC_ERROR;
754: END IF;
755:
756: /* Truncate the UMATCH table */
757: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

757: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
758: p_table_name => l_umatch_target
759: ,x_return_status => x_return_status );
760:
761: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
762: -- debug message
763: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_umatch_target;
764: jty_log(FND_LOG.LEVEL_EXCEPTION,
765: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',

Line 768: RAISE FND_API.G_EXC_ERROR;

764: jty_log(FND_LOG.LEVEL_EXCEPTION,
765: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',
766: x_msg_data);
767:
768: RAISE FND_API.G_EXC_ERROR;
769: END IF;
770:
771: END IF; /* end (l_umatch_target IS NOT NULL) */
772:

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

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

Line 794: RAISE FND_API.G_EXC_ERROR;

790: jty_log(FND_LOG.LEVEL_EXCEPTION,
791: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',
792: x_msg_data);
793:
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796:
797: /* Truncate the WINNER table */
798: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

798: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
799: p_table_name => l_winner_target
800: ,x_return_status => x_return_status );
801:
802: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
803: -- debug message
804: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_winner_target;
805: jty_log(FND_LOG.LEVEL_EXCEPTION,
806: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',

Line 809: RAISE FND_API.G_EXC_ERROR;

805: jty_log(FND_LOG.LEVEL_EXCEPTION,
806: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',
807: x_msg_data);
808:
809: RAISE FND_API.G_EXC_ERROR;
810: END IF;
811:
812: END IF; /* end (l_winner_target IS NOT NULL) */
813:

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

823: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
824: p_table_name => l_uwinner_target
825: ,x_return_status => x_return_status );
826:
827: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
828:
829: -- debug message
830: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_uwinner_target;
831: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 835: RAISE FND_API.G_EXC_ERROR;

831: jty_log(FND_LOG.LEVEL_EXCEPTION,
832: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',
833: x_msg_data);
834:
835: RAISE FND_API.G_EXC_ERROR;
836: END IF;
837:
838: /* Truncate the UWINNER table */
839: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

839: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
840: p_table_name => l_uwinner_target
841: ,x_return_status => x_return_status );
842:
843: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
844: -- debug message
845: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_uwinner_target;
846: jty_log(FND_LOG.LEVEL_EXCEPTION,
847: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',

Line 850: RAISE FND_API.G_EXC_ERROR;

846: jty_log(FND_LOG.LEVEL_EXCEPTION,
847: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',
848: x_msg_data);
849:
850: RAISE FND_API.G_EXC_ERROR;
851: END IF;
852:
853: END IF; /* end (l_uwinner_target IS NOT NULL) */
854:

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

864: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
865: p_table_name => l_l1_target
866: ,x_return_status => x_return_status );
867:
868: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
869:
870: -- debug message
871: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l1_target;
872: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 876: RAISE FND_API.G_EXC_ERROR;

872: jty_log(FND_LOG.LEVEL_EXCEPTION,
873: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l1_clear',
874: x_msg_data);
875:
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878:
879: /* Truncate the L1 table */
880: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

880: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
881: p_table_name => l_l1_target
882: ,x_return_status => x_return_status );
883:
884: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
885: -- debug message
886: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l1_target;
887: jty_log(FND_LOG.LEVEL_EXCEPTION,
888: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l1_clear',

Line 891: RAISE FND_API.G_EXC_ERROR;

887: jty_log(FND_LOG.LEVEL_EXCEPTION,
888: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l1_clear',
889: x_msg_data);
890:
891: RAISE FND_API.G_EXC_ERROR;
892: END IF;
893:
894: END IF; /* end (l_l1_target IS NOT NULL) */
895:

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

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

Line 917: RAISE FND_API.G_EXC_ERROR;

913: jty_log(FND_LOG.LEVEL_EXCEPTION,
914: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',
915: x_msg_data);
916:
917: RAISE FND_API.G_EXC_ERROR;
918: END IF;
919:
920: /* Truncate the L2 table */
921: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

921: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
922: p_table_name => l_l2_target
923: ,x_return_status => x_return_status );
924:
925: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
926: -- debug message
927: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l2_target;
928: jty_log(FND_LOG.LEVEL_EXCEPTION,
929: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',

Line 932: RAISE FND_API.G_EXC_ERROR;

928: jty_log(FND_LOG.LEVEL_EXCEPTION,
929: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',
930: x_msg_data);
931:
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934:
935: END IF; /* end (l_l2_target IS NOT NULL) */
936:

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

946: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
947: p_table_name => l_l3_target
948: ,x_return_status => x_return_status );
949:
950: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
951:
952: -- debug message
953: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l3_target;
954: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 958: RAISE FND_API.G_EXC_ERROR;

954: jty_log(FND_LOG.LEVEL_EXCEPTION,
955: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',
956: x_msg_data);
957:
958: RAISE FND_API.G_EXC_ERROR;
959: END IF;
960:
961: /* Truncate the L3 table */
962: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

962: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
963: p_table_name => l_l3_target
964: ,x_return_status => x_return_status );
965:
966: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
967: -- debug message
968: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l3_target;
969: jty_log(FND_LOG.LEVEL_EXCEPTION,
970: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',

Line 973: RAISE FND_API.G_EXC_ERROR;

969: jty_log(FND_LOG.LEVEL_EXCEPTION,
970: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',
971: x_msg_data);
972:
973: RAISE FND_API.G_EXC_ERROR;
974: END IF;
975:
976: END IF; /* end (l_l3_target IS NOT NULL) */
977:

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

987: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
988: p_table_name => l_l4_target
989: ,x_return_status => x_return_status );
990:
991: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
992:
993: -- debug message
994: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l4_target;
995: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 999: RAISE FND_API.G_EXC_ERROR;

995: jty_log(FND_LOG.LEVEL_EXCEPTION,
996: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',
997: x_msg_data);
998:
999: RAISE FND_API.G_EXC_ERROR;
1000: END IF;
1001:
1002: /* Truncate the L4 table */
1003: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

1003: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1004: p_table_name => l_l4_target
1005: ,x_return_status => x_return_status );
1006:
1007: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1008: -- debug message
1009: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l4_target;
1010: jty_log(FND_LOG.LEVEL_EXCEPTION,
1011: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',

Line 1014: RAISE FND_API.G_EXC_ERROR;

1010: jty_log(FND_LOG.LEVEL_EXCEPTION,
1011: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',
1012: x_msg_data);
1013:
1014: RAISE FND_API.G_EXC_ERROR;
1015: END IF;
1016:
1017: END IF; /* end (l_l4_target IS NOT NULL) */
1018:

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

1028: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1029: p_table_name => l_l5_target
1030: ,x_return_status => x_return_status );
1031:
1032: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1033:
1034: -- debug message
1035: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_l5_target;
1036: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 1040: RAISE FND_API.G_EXC_ERROR;

1036: jty_log(FND_LOG.LEVEL_EXCEPTION,
1037: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',
1038: x_msg_data);
1039:
1040: RAISE FND_API.G_EXC_ERROR;
1041: END IF;
1042:
1043: /* Truncate the L5 table */
1044: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

1044: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1045: p_table_name => l_l5_target
1046: ,x_return_status => x_return_status );
1047:
1048: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1049: -- debug message
1050: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_l5_target;
1051: jty_log(FND_LOG.LEVEL_EXCEPTION,
1052: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',

Line 1055: RAISE FND_API.G_EXC_ERROR;

1051: jty_log(FND_LOG.LEVEL_EXCEPTION,
1052: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',
1053: x_msg_data);
1054:
1055: RAISE FND_API.G_EXC_ERROR;
1056: END IF;
1057:
1058: END IF; /* end (l_l5_target IS NOT NULL) */
1059:

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

1069: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(
1070: p_table_name => l_wt_target
1071: ,x_return_status => x_return_status );
1072:
1073: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1074:
1075: -- debug message
1076: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES API has failed for ' || l_wt_target;
1077: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 1081: RAISE FND_API.G_EXC_ERROR;

1077: jty_log(FND_LOG.LEVEL_EXCEPTION,
1078: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',
1079: x_msg_data);
1080:
1081: RAISE FND_API.G_EXC_ERROR;
1082: END IF;
1083:
1084: /* Truncate the WT table */
1085: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(

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

1085: JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE(
1086: p_table_name => l_wt_target
1087: ,x_return_status => x_return_status );
1088:
1089: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1090: -- debug message
1091: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.TRUNCATE_TABLE API has failed for ' || l_wt_target;
1092: jty_log(FND_LOG.LEVEL_EXCEPTION,
1093: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',

Line 1096: RAISE FND_API.G_EXC_ERROR;

1092: jty_log(FND_LOG.LEVEL_EXCEPTION,
1093: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',
1094: x_msg_data);
1095:
1096: RAISE FND_API.G_EXC_ERROR;
1097: END IF;
1098:
1099: END IF; /* end (l_wt_target IS NOT NULL) */
1100:

Line 1134: x_return_status := FND_API.G_RET_STS_ERROR ;

1130: 'End of the procedure JTY_ASSIGN_BULK_PUB.clear_trans_data ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1131:
1132: EXCEPTION
1133: WHEN NO_DATA_FOUND THEN
1134: x_return_status := FND_API.G_RET_STS_ERROR ;
1135: RETCODE := 2;
1136: x_msg_count := 1;
1137: x_msg_data := 'No row in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||
1138: ' program name : ' || p_program_name;

Line 1144: WHEN FND_API.G_EXC_ERROR THEN

1140: jty_log(FND_LOG.LEVEL_EXCEPTION,
1141: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Clear_Trans_Data.no_data_found',
1142: x_msg_data);
1143:
1144: WHEN FND_API.G_EXC_ERROR THEN
1145: RETCODE := 2;
1146: x_msg_count := 1;
1147: ERRBUF := x_msg_data;
1148: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1149: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Clear_Trans_Data.g_exc_error',
1150: x_msg_data);
1151:
1152: WHEN OTHERS THEN
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1154: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1155: x_msg_count := 1;
1156: ERRBUF := x_msg_data;
1157: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 1213: x_return_status := FND_API.G_RET_STS_SUCCESS;

1209: jty_log(FND_LOG.LEVEL_PROCEDURE,
1210: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.begin',
1211: 'Start of the procedure JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1212:
1213: x_return_status := FND_API.G_RET_STS_SUCCESS;
1214: l_sysdate := SYSDATE;
1215:
1216: /* Corresponding to the usage, transaction type and program name */
1217: /* get all the interface table names */

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

1341: p_table_name => l_trans_target
1342: , p_percent => p_percent_analyzed
1343: , x_return_status => x_return_status );
1344:
1345: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1346: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP: Call to ' ||
1347: 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' || l_trans_target;
1348: RAISE FND_API.G_EXC_ERROR;
1349: END IF;

Line 1348: RAISE FND_API.G_EXC_ERROR;

1344:
1345: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1346: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP: Call to ' ||
1347: 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for ' || l_trans_target;
1348: RAISE FND_API.G_EXC_ERROR;
1349: END IF;
1350:
1351: -- debug message
1352: jty_log(FND_LOG.LEVEL_STATEMENT,

Line 1358: p_Init_Msg_List => FND_API.G_FALSE,

1354: 'Call to JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns API begins for : ' || l_trans_target);
1355:
1356: JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns
1357: (p_Api_Version_Number => 1.0,
1358: p_Init_Msg_List => FND_API.G_FALSE,
1359: p_trans_target => l_trans_target,
1360: p_classify_terr_comb => 'N',
1361: p_process_tx_oin_sel => 'Y',
1362: p_generate_indexes => 'Y',

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

1369: x_Msg_Data => x_msg_data,
1370: errbuf => ERRBUF,
1371: retcode => RETCODE );
1372:
1373: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1374: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP: Call to ' ||
1375: 'JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns API has failed for ' || l_trans_target;
1376: RAISE FND_API.G_EXC_ERROR;
1377: END IF;

Line 1376: RAISE FND_API.G_EXC_ERROR;

1372:
1373: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1374: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP: Call to ' ||
1375: 'JTY_TAE_CONTROL_PVT.Decompose_Terr_Defns API has failed for ' || l_trans_target;
1376: RAISE FND_API.G_EXC_ERROR;
1377: END IF;
1378:
1379: -- debug message
1380: jty_log(FND_LOG.LEVEL_STATEMENT,

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

1390: p_mode => p_mode,
1391: x_Return_Status => x_return_status,
1392: p_run_mode => 'MATCH');
1393:
1394: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1395: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_match_target;
1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;
1398:

Line 1396: RAISE FND_API.G_EXC_ERROR;

1392: p_run_mode => 'MATCH');
1393:
1394: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1395: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_match_target;
1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;
1398:
1399: -- debug message
1400: jty_log(FND_LOG.LEVEL_STATEMENT,

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

1410: p_mode => p_mode,
1411: x_Return_Status => x_return_status,
1412: p_run_mode => 'WINNER');
1413:
1414: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1415: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_winner_target;
1416: RAISE FND_API.G_EXC_ERROR;
1417: END IF;
1418:

Line 1416: RAISE FND_API.G_EXC_ERROR;

1412: p_run_mode => 'WINNER');
1413:
1414: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1415: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_winner_target;
1416: RAISE FND_API.G_EXC_ERROR;
1417: END IF;
1418:
1419: -- debug message
1420: jty_log(FND_LOG.LEVEL_STATEMENT,

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

1430: p_mode => p_mode,
1431: x_Return_Status => x_return_status,
1432: p_run_mode => 'TEMP_WINNER');
1433:
1434: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1435: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l1_target;
1436: RAISE FND_API.G_EXC_ERROR;
1437: END IF;
1438:

Line 1436: RAISE FND_API.G_EXC_ERROR;

1432: p_run_mode => 'TEMP_WINNER');
1433:
1434: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1435: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l1_target;
1436: RAISE FND_API.G_EXC_ERROR;
1437: END IF;
1438:
1439: -- debug message
1440: jty_log(FND_LOG.LEVEL_STATEMENT,

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

1450: p_mode => p_mode,
1451: x_Return_Status => x_return_status,
1452: p_run_mode => 'TEMP_WINNER');
1453:
1454: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1455: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l2_target;
1456: RAISE FND_API.G_EXC_ERROR;
1457: END IF;
1458:

Line 1456: RAISE FND_API.G_EXC_ERROR;

1452: p_run_mode => 'TEMP_WINNER');
1453:
1454: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1455: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l2_target;
1456: RAISE FND_API.G_EXC_ERROR;
1457: END IF;
1458:
1459:
1460: -- debug message

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

1471: p_mode => p_mode,
1472: x_Return_Status => x_return_status,
1473: p_run_mode => 'TEMP_WINNER');
1474:
1475: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1476: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l3_target;
1477: RAISE FND_API.G_EXC_ERROR;
1478: END IF;
1479:

Line 1477: RAISE FND_API.G_EXC_ERROR;

1473: p_run_mode => 'TEMP_WINNER');
1474:
1475: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1476: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l3_target;
1477: RAISE FND_API.G_EXC_ERROR;
1478: END IF;
1479:
1480: -- debug message
1481: jty_log(FND_LOG.LEVEL_STATEMENT,

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

1491: p_mode => p_mode,
1492: x_Return_Status => x_return_status,
1493: p_run_mode => 'TEMP_WINNER');
1494:
1495: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1496: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l4_target;
1497: RAISE FND_API.G_EXC_ERROR;
1498: END IF;
1499:

Line 1497: RAISE FND_API.G_EXC_ERROR;

1493: p_run_mode => 'TEMP_WINNER');
1494:
1495: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1496: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l4_target;
1497: RAISE FND_API.G_EXC_ERROR;
1498: END IF;
1499:
1500: -- debug message
1501: jty_log(FND_LOG.LEVEL_STATEMENT,

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

1511: p_mode => p_mode,
1512: x_Return_Status => x_return_status,
1513: p_run_mode => 'TEMP_WINNER');
1514:
1515: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1516: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l5_target;
1517: RAISE FND_API.G_EXC_ERROR;
1518: END IF;
1519:

Line 1517: RAISE FND_API.G_EXC_ERROR;

1513: p_run_mode => 'TEMP_WINNER');
1514:
1515: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1516: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_l5_target;
1517: RAISE FND_API.G_EXC_ERROR;
1518: END IF;
1519:
1520: -- debug message
1521: jty_log(FND_LOG.LEVEL_STATEMENT,

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

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

Line 1537: RAISE FND_API.G_EXC_ERROR;

1533: p_run_mode => 'TEMP_WINNER');
1534:
1535: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1536: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX API has failed for ' || l_wt_target;
1537: RAISE FND_API.G_EXC_ERROR;
1538: END IF;
1539:
1540: /* if mode is incremental, update the worker_id column for the TRANS table */
1541: IF (p_mode = 'INCREMENTAL') THEN

Line 1554: x_return_status := FND_API.G_RET_STS_SUCCESS;

1550: 'End of the procedure JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1551:
1552: EXCEPTION
1553: WHEN NO_TAE_DATA_FOUND THEN
1554: x_return_status := FND_API.G_RET_STS_SUCCESS;
1555: x_msg_count := 1;
1556: RETCODE := 0;
1557: ERRBUF := null;
1558: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 1562: WHEN FND_API.G_EXC_ERROR THEN

1558: jty_log(FND_LOG.LEVEL_EXCEPTION,
1559: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.no_tae_data_found',
1560: x_msg_data);
1561:
1562: WHEN FND_API.G_EXC_ERROR THEN
1563: x_return_status := FND_API.G_RET_STS_ERROR;
1564: x_msg_count := 1;
1565: RETCODE := 2;
1566: ERRBUF := x_msg_data;

Line 1563: x_return_status := FND_API.G_RET_STS_ERROR;

1559: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.no_tae_data_found',
1560: x_msg_data);
1561:
1562: WHEN FND_API.G_EXC_ERROR THEN
1563: x_return_status := FND_API.G_RET_STS_ERROR;
1564: x_msg_count := 1;
1565: RETCODE := 2;
1566: ERRBUF := x_msg_data;
1567: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 1571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1567: jty_log(FND_LOG.LEVEL_EXCEPTION,
1568: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.g_exc_error',
1569: x_msg_data);
1570:
1571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1573: x_msg_count := 1;
1574: RETCODE := 2;
1575: ERRBUF := x_msg_data;

Line 1572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1568: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.g_exc_error',
1569: x_msg_data);
1570:
1571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1573: x_msg_count := 1;
1574: RETCODE := 2;
1575: ERRBUF := x_msg_data;
1576: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 1581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1577: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.g_exc_unexpected_error',
1578: x_msg_data);
1579:
1580: WHEN OTHERS THEN
1581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1582: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1583: x_msg_count := 1;
1584: RETCODE := 2;
1585: ERRBUF := x_msg_data;

Line 1619: x_return_status := FND_API.G_RET_STS_SUCCESS;

1615: jty_log(FND_LOG.LEVEL_PROCEDURE,
1616: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.start',
1617: 'Start of the procedure JTY_ASSIGN_BULK_PUB.Process_Level_Winners ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1618:
1619: x_return_status := FND_API.G_RET_STS_SUCCESS;
1620:
1621: IF (p_date_effective) THEN
1622: l_denorm_table_name := 'JTY_DENORM_DEA_RULES_ALL';
1623: ELSE

Line 1909: WHEN FND_API.G_EXC_ERROR THEN

1905: 'End of the procedure JTY_ASSIGN_BULK_PUB.Process_Level_Winners ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1906:
1907: EXCEPTION
1908:
1909: WHEN FND_API.G_EXC_ERROR THEN
1910: x_return_status := FND_API.G_RET_STS_ERROR;
1911: jty_log(FND_LOG.LEVEL_EXCEPTION,
1912: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.other',
1913: 'JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed with FND_API.G_EXC_ERROR exception for ' ||

Line 1910: x_return_status := FND_API.G_RET_STS_ERROR;

1906:
1907: EXCEPTION
1908:
1909: WHEN FND_API.G_EXC_ERROR THEN
1910: x_return_status := FND_API.G_RET_STS_ERROR;
1911: jty_log(FND_LOG.LEVEL_EXCEPTION,
1912: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.other',
1913: 'JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed with FND_API.G_EXC_ERROR exception for ' ||
1914: 'UPPER LEVEL : ' || p_UPPER_LEVEL_FROM_ROOT || ' LOWER LEVEL : ' || p_LOWER_LEVEL_FROM_ROOT);

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

1909: WHEN FND_API.G_EXC_ERROR THEN
1910: x_return_status := FND_API.G_RET_STS_ERROR;
1911: jty_log(FND_LOG.LEVEL_EXCEPTION,
1912: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.other',
1913: 'JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed with FND_API.G_EXC_ERROR exception for ' ||
1914: 'UPPER LEVEL : ' || p_UPPER_LEVEL_FROM_ROOT || ' LOWER LEVEL : ' || p_LOWER_LEVEL_FROM_ROOT);
1915:
1916: WHEN OTHERS THEN
1917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1913: 'JTY_ASSIGN_BULK_PUB.Process_Level_Winners has failed with FND_API.G_EXC_ERROR exception for ' ||
1914: 'UPPER LEVEL : ' || p_UPPER_LEVEL_FROM_ROOT || ' LOWER LEVEL : ' || p_LOWER_LEVEL_FROM_ROOT);
1915:
1916: WHEN OTHERS THEN
1917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1918: jty_log(FND_LOG.LEVEL_EXCEPTION,
1919: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.other',
1920: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
1921:

Line 1950: x_return_status := FND_API.G_RET_STS_SUCCESS;

1946: jty_log(FND_LOG.LEVEL_PROCEDURE,
1947: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners.start',
1948: 'Start of the procedure JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1949:
1950: x_return_status := FND_API.G_RET_STS_SUCCESS;
1951:
1952: IF (p_date_effective) THEN
1953: l_denorm_table_name := 'JTY_DENORM_DEA_RULES_ALL';
1954: ELSE

Line 2050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2046: 'End of the procedure JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2047:
2048: EXCEPTION
2049: WHEN OTHERS THEN
2050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2051: jty_log(FND_LOG.LEVEL_EXCEPTION,
2052: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners.other',
2053: substr(SQLCODE || ' : ' || SQLERRM, 1, 4000));
2054:

Line 2118: x_return_status := FND_API.G_RET_STS_SUCCESS;

2114: jty_log(FND_LOG.LEVEL_PROCEDURE,
2115: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.start',
2116: 'Start of the procedure JTY_ASSIGN_BULK_PUB.process_nmc_match ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2117:
2118: x_return_status := FND_API.G_RET_STS_SUCCESS;
2119:
2120: /* Get the schema name corresponding to JTF application */
2121: IF (FND_INSTALLATION.GET_APP_INFO('JTF', l_status, l_industry, l_owner)) THEN
2122: NULL;

Line 2268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2264: 'End of the procedure JTY_ASSIGN_BULK_PUB.process_nmc_match ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2265:
2266: EXCEPTION
2267: WHEN L_SCHEMA_NOTFOUND THEN
2268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2269: x_msg_data := 'Schema name corresponding to JTF application not found';
2270: RETCODE := 2;
2271: x_msg_count := 1;
2272: ERRBUF := x_msg_data;

Line 2278: x_return_status := FND_API.G_RET_STS_ERROR ;

2274: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.l_schema_notfound',
2275: 'Schema name corresponding to the JTF application not found');
2276:
2277: WHEN NO_DATA_FOUND THEN
2278: x_return_status := FND_API.G_RET_STS_ERROR ;
2279: RETCODE := 2;
2280: x_msg_count := 1;
2281: ERRBUF := x_msg_data;
2282: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 2287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2283: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.no_data_found',
2284: x_msg_data);
2285:
2286: WHEN OTHERS THEN
2287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2288: x_msg_data := SQLCODE || ' : ' || SQLERRM;
2289: x_msg_count := 1;
2290: RETCODE := 2;
2291: ERRBUF := x_msg_data;

Line 2341: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2337: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.start',
2338: 'Start of the procedure JTY_ASSIGN_BULK_PUB.collect_trans_data ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2339:
2340: /* Standard call to check for call compatibility. */
2341: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2342: p_api_version_number,
2343: l_api_name,
2344: G_PKG_NAME) THEN
2345:

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

2342: p_api_version_number,
2343: l_api_name,
2344: G_PKG_NAME) THEN
2345:
2346: x_msg_data := 'API FND_API.Compatible_API_Call has failed';
2347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2348: END IF;
2349:
2350: /* Initialize message list if p_init_msg_list is set to TRUE. */

Line 2347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2343: l_api_name,
2344: G_PKG_NAME) THEN
2345:
2346: x_msg_data := 'API FND_API.Compatible_API_Call has failed';
2347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2348: END IF;
2349:
2350: /* Initialize message list if p_init_msg_list is set to TRUE. */
2351: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2351: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2348: END IF;
2349:
2350: /* Initialize message list if p_init_msg_list is set to TRUE. */
2351: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2352: FND_MSG_PUB.initialize;
2353: END IF;
2354:
2355: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2355: x_return_status := FND_API.G_RET_STS_SUCCESS;

2351: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2352: FND_MSG_PUB.initialize;
2353: END IF;
2354:
2355: x_return_status := FND_API.G_RET_STS_SUCCESS;
2356:
2357: IF p_oic_mode = 'NOOIC' or p_oic_mode = 'CLEAR' THEN
2358:
2359: -- debug message

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

2375: x_msg_data => x_msg_data,
2376: errbuf => errbuf,
2377: retcode => retcode);
2378:
2379: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2380: -- debug message
2381: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.clear_trans_data has failed';
2382: jty_log(FND_LOG.LEVEL_EXCEPTION,
2383: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.clear_trans_data',

Line 2386: RAISE FND_API.G_EXC_ERROR;

2382: jty_log(FND_LOG.LEVEL_EXCEPTION,
2383: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.clear_trans_data',
2384: x_msg_data);
2385:
2386: RAISE FND_API.G_EXC_ERROR;
2387: END IF;
2388:
2389: -- debug message
2390: jty_log(FND_LOG.LEVEL_EVENT,

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

2410: retcode => retcode,
2411: p_oic_mode => p_oic_mode
2412: );
2413:
2414: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2415: -- debug message
2416: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.insert_trans_data has failed';
2417: jty_log(FND_LOG.LEVEL_EXCEPTION,
2418: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.insert_trans_data',

Line 2421: RAISE FND_API.G_EXC_ERROR;

2417: jty_log(FND_LOG.LEVEL_EXCEPTION,
2418: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.insert_trans_data',
2419: x_msg_data);
2420:
2421: RAISE FND_API.G_EXC_ERROR;
2422: END IF;
2423:
2424: -- debug message
2425: jty_log(FND_LOG.LEVEL_EVENT,

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

2442: x_msg_data => x_msg_data,
2443: errbuf => errbuf,
2444: retcode => retcode);
2445:
2446: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2447: -- debug message
2448: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.process_nmc_match has failed';
2449: jty_log(FND_LOG.LEVEL_EXCEPTION,
2450: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.process_nmc_match',

Line 2453: RAISE FND_API.G_EXC_ERROR;

2449: jty_log(FND_LOG.LEVEL_EXCEPTION,
2450: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.process_nmc_match',
2451: x_msg_data);
2452:
2453: RAISE FND_API.G_EXC_ERROR;
2454: END IF;
2455:
2456: -- debug message
2457: jty_log(FND_LOG.LEVEL_EVENT,

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

2469: x_msg_data => x_msg_data,
2470: errbuf => errbuf,
2471: retcode => retcode);
2472:
2473: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2474: -- debug message
2475: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.insert_nm_trans_data has failed';
2476: jty_log(FND_LOG.LEVEL_EXCEPTION,
2477: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.insert_nm_trans_data',

Line 2480: RAISE FND_API.G_EXC_ERROR;

2476: jty_log(FND_LOG.LEVEL_EXCEPTION,
2477: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.insert_nm_trans_data',
2478: x_msg_data);
2479:
2480: RAISE FND_API.G_EXC_ERROR;
2481: END IF;
2482:
2483: -- debug message
2484: jty_log(FND_LOG.LEVEL_EVENT,

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

2503: ERRBUF => ERRBUF,
2504: RETCODE => RETCODE
2505: );
2506:
2507: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2508: -- debug message
2509: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup has failed';
2510: jty_log(FND_LOG.LEVEL_EXCEPTION,
2511: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.get_winners_parallel_setup',

Line 2514: RAISE FND_API.G_EXC_ERROR;

2510: jty_log(FND_LOG.LEVEL_EXCEPTION,
2511: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.get_winners_parallel_setup',
2512: x_msg_data);
2513:
2514: RAISE FND_API.G_EXC_ERROR;
2515: END IF;
2516: END IF; -- p_oic_mode = 'NOOIC' or p_oic_mode = 'POST'
2517:
2518: retcode := 0;

Line 2527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2523: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end',
2524: 'End of the procedure JTY_ASSIGN_BULK_PUB.collect_trans_data ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2525:
2526: EXCEPTION
2527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2529: x_msg_count := 1;
2530: RETCODE := 2;
2531: ERRBUF := x_msg_data;

Line 2528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2524: 'End of the procedure JTY_ASSIGN_BULK_PUB.collect_trans_data ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2525:
2526: EXCEPTION
2527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2529: x_msg_count := 1;
2530: RETCODE := 2;
2531: ERRBUF := x_msg_data;
2532: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 2537: x_return_status := FND_API.G_RET_STS_ERROR ;

2533: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.g_exc_unexpected_error',
2534: x_msg_data);
2535:
2536: WHEN NO_DATA_FOUND THEN
2537: x_return_status := FND_API.G_RET_STS_ERROR ;
2538: RETCODE := 2;
2539: x_msg_count := 1;
2540: ERRBUF := x_msg_data;
2541: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 2545: WHEN FND_API.G_EXC_ERROR THEN

2541: jty_log(FND_LOG.LEVEL_EXCEPTION,
2542: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.no_data_found',
2543: x_msg_data);
2544:
2545: WHEN FND_API.G_EXC_ERROR THEN
2546: RETCODE := 2;
2547: x_msg_count := 1;
2548: ERRBUF := x_msg_data;
2549: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 2554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2550: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.g_exc_error',
2551: x_msg_data);
2552:
2553: WHEN OTHERS THEN
2554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2555: x_msg_data := SQLCODE || ' : ' || SQLERRM;
2556: x_msg_count := 1;
2557: RETCODE := 2;
2558: ERRBUF := x_msg_data;

Line 2624: x_return_status := FND_API.G_RET_STS_SUCCESS;

2620: jty_log(FND_LOG.LEVEL_PROCEDURE,
2621: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.start',
2622: 'Start of the procedure JTY_ASSIGN_BULK_PUB.process_winner ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2623:
2624: x_return_status := FND_API.G_RET_STS_SUCCESS;
2625: lp_sysdate := SYSDATE;
2626:
2627: IF (p_mode = 'DATE EFFECTIVE') THEN
2628: l_date_effective := true;

Line 2837: x_return_status := FND_API.G_RET_STS_SUCCESS;

2833: 'Number of maximum territories for a matching combination for the worker_id : ' || p_worker_id || ' : ' || l_max_terr);
2834:
2835: IF ((l_max_terr IS NULL) OR (l_max_terr = 0)) THEN
2836: x_msg_data := 'No row in ' || l_match_target || ' for worker_id = ' || p_worker_id;
2837: x_return_status := FND_API.G_RET_STS_SUCCESS;
2838: RETCODE := 0;
2839: x_msg_count := 1;
2840: ERRBUF := null;
2841: RAISE L_NO_MATCH_TERR;

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

3074: x_return_status => x_return_status,
3075: p_worker_id => p_worker_id
3076: );
3077:
3078: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3079: jty_log(FND_LOG.LEVEL_EXCEPTION,
3080: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l1',
3081: x_msg_data);
3082: RAISE FND_API.G_EXC_ERROR;

Line 3082: RAISE FND_API.G_EXC_ERROR;

3078: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3079: jty_log(FND_LOG.LEVEL_EXCEPTION,
3080: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l1',
3081: x_msg_data);
3082: RAISE FND_API.G_EXC_ERROR;
3083: END IF;
3084:
3085: COMMIT;
3086:

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

3089: p_table_name => l_L1_target
3090: , p_percent => p_percent_analyzed
3091: , x_return_status => x_return_status );
3092:
3093: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3094: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L1_target;
3095: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3096: jty_log(FND_LOG.LEVEL_EXCEPTION,
3097: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l1_analyze',

Line 3100: RAISE FND_API.G_EXC_ERROR;

3096: jty_log(FND_LOG.LEVEL_EXCEPTION,
3097: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l1_analyze',
3098: x_msg_data);
3099: END IF;
3100: RAISE FND_API.G_EXC_ERROR;
3101: END IF;
3102: */
3103:
3104: /* Process second level */

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

3114: x_return_status => x_return_status,
3115: p_worker_id => p_worker_id
3116: );
3117:
3118: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3119: jty_log(FND_LOG.LEVEL_EXCEPTION,
3120: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l2',
3121: x_msg_data);
3122: RAISE FND_API.G_EXC_ERROR;

Line 3122: RAISE FND_API.G_EXC_ERROR;

3118: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3119: jty_log(FND_LOG.LEVEL_EXCEPTION,
3120: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l2',
3121: x_msg_data);
3122: RAISE FND_API.G_EXC_ERROR;
3123: END IF;
3124:
3125: COMMIT;
3126:

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

3129: p_table_name => l_L2_target
3130: , p_percent => p_percent_analyzed
3131: , x_return_status => x_return_status );
3132:
3133: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3134: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L2_target;
3135: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3136: jty_log(FND_LOG.LEVEL_EXCEPTION,
3137: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l2_analyze',

Line 3140: RAISE FND_API.G_EXC_ERROR;

3136: jty_log(FND_LOG.LEVEL_EXCEPTION,
3137: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l2_analyze',
3138: x_msg_data);
3139: END IF;
3140: RAISE FND_API.G_EXC_ERROR;
3141: END IF;
3142: */
3143:
3144: /* Process third level */

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

3154: x_return_status => x_return_status,
3155: p_worker_id => p_worker_id
3156: );
3157:
3158: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3159: jty_log(FND_LOG.LEVEL_EXCEPTION,
3160: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l3',
3161: x_msg_data);
3162: RAISE FND_API.G_EXC_ERROR;

Line 3162: RAISE FND_API.G_EXC_ERROR;

3158: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3159: jty_log(FND_LOG.LEVEL_EXCEPTION,
3160: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l3',
3161: x_msg_data);
3162: RAISE FND_API.G_EXC_ERROR;
3163: END IF;
3164:
3165: COMMIT;
3166:

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

3169: p_table_name => l_L3_target
3170: , p_percent => p_percent_analyzed
3171: , x_return_status => x_return_status );
3172:
3173: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3174: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L3_target;
3175: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3176: jty_log(FND_LOG.LEVEL_EXCEPTION,
3177: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l3_analyze',

Line 3180: RAISE FND_API.G_EXC_ERROR;

3176: jty_log(FND_LOG.LEVEL_EXCEPTION,
3177: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l3_analyze',
3178: x_msg_data);
3179: END IF;
3180: RAISE FND_API.G_EXC_ERROR;
3181: END IF;
3182: */
3183:
3184: /* Process fourth level */

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

3194: x_return_status => x_return_status,
3195: p_worker_id => p_worker_id
3196: );
3197:
3198: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3199: jty_log(FND_LOG.LEVEL_EXCEPTION,
3200: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l4',
3201: x_msg_data);
3202: RAISE FND_API.G_EXC_ERROR;

Line 3202: RAISE FND_API.G_EXC_ERROR;

3198: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3199: jty_log(FND_LOG.LEVEL_EXCEPTION,
3200: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l4',
3201: x_msg_data);
3202: RAISE FND_API.G_EXC_ERROR;
3203: END IF;
3204:
3205: COMMIT;
3206:

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

3209: p_table_name => l_L4_target
3210: , p_percent => p_percent_analyzed
3211: , x_return_status => x_return_status );
3212:
3213: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3214: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L4_target;
3215: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3216: jty_log(FND_LOG.LEVEL_EXCEPTION,
3217: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l4_analyze',

Line 3220: RAISE FND_API.G_EXC_ERROR;

3216: jty_log(FND_LOG.LEVEL_EXCEPTION,
3217: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l4_analyze',
3218: x_msg_data);
3219: END IF;
3220: RAISE FND_API.G_EXC_ERROR;
3221: END IF;
3222: */
3223:
3224: /* Process fifth level */

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

3234: x_return_status => x_return_status,
3235: p_worker_id => p_worker_id
3236: );
3237:
3238: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3239: jty_log(FND_LOG.LEVEL_EXCEPTION,
3240: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l5',
3241: x_msg_data);
3242: RAISE FND_API.G_EXC_ERROR;

Line 3242: RAISE FND_API.G_EXC_ERROR;

3238: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3239: jty_log(FND_LOG.LEVEL_EXCEPTION,
3240: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l5',
3241: x_msg_data);
3242: RAISE FND_API.G_EXC_ERROR;
3243: END IF;
3244:
3245: COMMIT;
3246:

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

3249: p_table_name => l_L5_target
3250: , p_percent => p_percent_analyzed
3251: , x_return_status => x_return_status );
3252:
3253: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3254: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_L5_target;
3255: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3256: jty_log(FND_LOG.LEVEL_EXCEPTION,
3257: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l5_analyze',

Line 3260: RAISE FND_API.G_EXC_ERROR;

3256: jty_log(FND_LOG.LEVEL_EXCEPTION,
3257: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l5_analyze',
3258: x_msg_data);
3259: END IF;
3260: RAISE FND_API.G_EXC_ERROR;
3261: END IF;
3262: */
3263:
3264: /* Process final level */

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

3272: x_return_status => x_return_status,
3273: p_worker_id => p_worker_id
3274: );
3275:
3276: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3277: jty_log(FND_LOG.LEVEL_EXCEPTION,
3278: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.wt',
3279: x_msg_data);
3280: RAISE FND_API.G_EXC_ERROR;

Line 3280: RAISE FND_API.G_EXC_ERROR;

3276: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3277: jty_log(FND_LOG.LEVEL_EXCEPTION,
3278: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.wt',
3279: x_msg_data);
3280: RAISE FND_API.G_EXC_ERROR;
3281: END IF;
3282:
3283: COMMIT;
3284:

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

3287: p_table_name => l_wt_target
3288: , p_percent => p_percent_analyzed
3289: , x_return_status => x_return_status );
3290:
3291: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3292: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_wt_target;
3293: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3294: jty_log(FND_LOG.LEVEL_EXCEPTION,
3295: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.wt_analyze',

Line 3298: RAISE FND_API.G_EXC_ERROR;

3294: jty_log(FND_LOG.LEVEL_EXCEPTION,
3295: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.wt_analyze',
3296: x_msg_data);
3297: END IF;
3298: RAISE FND_API.G_EXC_ERROR;
3299: END IF;
3300: */
3301:
3302: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

3602: p_table_name => l_winner_target
3603: , p_percent => p_percent_analyzed
3604: , x_return_status => x_return_status );
3605:
3606: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3607: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_winner_target;
3608: jty_log(FND_LOG.LEVEL_EXCEPTION,
3609: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner_analyze',
3610: x_msg_data);

Line 3611: RAISE FND_API.G_EXC_ERROR;

3607: x_msg_data := 'API JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX has failed for ' || l_winner_target;
3608: jty_log(FND_LOG.LEVEL_EXCEPTION,
3609: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner_analyze',
3610: x_msg_data);
3611: RAISE FND_API.G_EXC_ERROR;
3612: END IF;
3613: END IF;
3614:
3615: /* Program completed successfully */

Line 3617: x_return_status := FND_API.G_RET_STS_SUCCESS;

3613: END IF;
3614:
3615: /* Program completed successfully */
3616: ERRBUF := null;
3617: x_return_status := FND_API.G_RET_STS_SUCCESS;
3618: RETCODE := 0;
3619:
3620: -- debug message
3621: jty_log(FND_LOG.LEVEL_PROCEDURE,

Line 3627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3623: 'End of the procedure JTY_ASSIGN_BULK_PUB.process_winner ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
3624:
3625: EXCEPTION
3626: WHEN L_SCHEMA_NOTFOUND THEN
3627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3628: x_msg_data := 'Schema name corresponding to the FND application not found';
3629: RETCODE := 2;
3630: x_msg_count := 1;
3631: ERRBUF := x_msg_data;

Line 3637: x_return_status := FND_API.G_RET_STS_ERROR ;

3633: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.l_schema_notfound',
3634: x_msg_data);
3635:
3636: WHEN NO_DATA_FOUND THEN
3637: x_return_status := FND_API.G_RET_STS_ERROR ;
3638: RETCODE := 2;
3639: x_msg_count := 1;
3640: ERRBUF := x_msg_data;
3641: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 3650: WHEN FND_API.G_EXC_ERROR THEN

3646: jty_log(FND_LOG.LEVEL_EXCEPTION,
3647: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.l_no_match_terr',
3648: x_msg_data);
3649:
3650: WHEN FND_API.G_EXC_ERROR THEN
3651: x_return_status := FND_API.G_RET_STS_ERROR ;
3652: RETCODE := 2;
3653: x_msg_count := 1;
3654: ERRBUF := x_msg_data;

Line 3651: x_return_status := FND_API.G_RET_STS_ERROR ;

3647: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.l_no_match_terr',
3648: x_msg_data);
3649:
3650: WHEN FND_API.G_EXC_ERROR THEN
3651: x_return_status := FND_API.G_RET_STS_ERROR ;
3652: RETCODE := 2;
3653: x_msg_count := 1;
3654: ERRBUF := x_msg_data;
3655: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 3660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3656: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.g_exc_error',
3657: x_msg_data);
3658:
3659: WHEN OTHERS THEN
3660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3661: x_msg_data := SQLCODE || ' : ' || SQLERRM;
3662: x_msg_count := 1;
3663: RETCODE := 2;
3664: ERRBUF := x_msg_data;

Line 3726: x_return_status := FND_API.G_RET_STS_SUCCESS;

3722: jty_log(FND_LOG.LEVEL_PROCEDURE,
3723: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.start',
3724: 'Start of the procedure JTY_ASSIGN_BULK_PUB.process_match ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
3725:
3726: x_return_status := FND_API.G_RET_STS_SUCCESS;
3727: l_sysdate := SYSDATE;
3728:
3729: BEGIN
3730: SELECT decode(p_mode, 'TOTAL', tup.batch_trans_table_name

Line 3755: x_return_status := FND_API.G_RET_STS_SUCCESS;

3751: EXECUTE IMMEDIATE l_sql_stmt INTO l_no_of_records USING p_worker_id;
3752:
3753: IF (l_no_of_records <= 0) THEN
3754: x_msg_data := 'No row in ' || l_trans_target || ' for worker_id = ' || p_worker_id;
3755: x_return_status := FND_API.G_RET_STS_SUCCESS;
3756: RETCODE := 0;
3757: x_msg_count := 1;
3758: ERRBUF := null;
3759: RAISE FND_API.G_EXC_ERROR;

Line 3759: RAISE FND_API.G_EXC_ERROR;

3755: x_return_status := FND_API.G_RET_STS_SUCCESS;
3756: RETCODE := 0;
3757: x_msg_count := 1;
3758: ERRBUF := null;
3759: RAISE FND_API.G_EXC_ERROR;
3760: END IF;
3761:
3762: IF (p_mode = 'DATE EFFECTIVE') THEN
3763: IF p_terr_id is NULL THEN

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

3844: p_table_name => l_match_target
3845: , p_percent => p_percent_analyzed
3846: , x_return_status => x_return_status );
3847:
3848: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3849: jty_log(FND_LOG.LEVEL_EXCEPTION,
3850: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.analyze_match',
3851: 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for table : ' || l_match_target);
3852:

Line 3853: RAISE FND_API.G_EXC_ERROR;

3849: jty_log(FND_LOG.LEVEL_EXCEPTION,
3850: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.analyze_match',
3851: 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for table : ' || l_match_target);
3852:
3853: RAISE FND_API.G_EXC_ERROR;
3854: RETCODE := 2;
3855: x_msg_count := 1;
3856: x_msg_data := 'JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API has failed for table : ' || l_match_target;
3857: errbuf := x_msg_data;

Line 3867: x_return_status := FND_API.G_RET_STS_ERROR ;

3863: 'End of the procedure JTY_ASSIGN_BULK_PUB.process_match ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
3864:
3865: EXCEPTION
3866: WHEN NO_DATA_FOUND THEN
3867: x_return_status := FND_API.G_RET_STS_ERROR ;
3868: RETCODE := 2;
3869: x_msg_count := 1;
3870: ERRBUF := x_msg_data;
3871: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 3875: WHEN FND_API.G_EXC_ERROR THEN

3871: jty_log(FND_LOG.LEVEL_EXCEPTION,
3872: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.no_data_found',
3873: x_msg_data);
3874:
3875: WHEN FND_API.G_EXC_ERROR THEN
3876: jty_log(FND_LOG.LEVEL_EXCEPTION,
3877: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.g_exc_error',
3878: x_msg_data);
3879:

Line 3881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3877: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.g_exc_error',
3878: x_msg_data);
3879:
3880: WHEN OTHERS THEN
3881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3882: x_msg_data := SQLCODE || ' : ' || SQLERRM;
3883: x_msg_count := 1;
3884: RETCODE := 2;
3885: ERRBUF := x_msg_data;

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

3900: -- transaction objs, it supports multiple worker architecture
3901: --
3902: PROCEDURE get_winners
3903: ( p_api_version_number IN NUMBER,
3904: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3905: p_source_id IN NUMBER,
3906: p_trans_id IN NUMBER,
3907: p_program_name IN VARCHAR2,
3908: p_mode IN VARCHAR2,

Line 3931: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

3927: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.start',
3928: 'Start of the procedure JTY_ASSIGN_BULK_PUB.get_winners ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
3929:
3930: /* Standard call to check for call compatibility. */
3931: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3932: p_api_version_number,
3933: l_api_name,
3934: G_PKG_NAME) THEN
3935:

Line 3936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3932: p_api_version_number,
3933: l_api_name,
3934: G_PKG_NAME) THEN
3935:
3936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3937: END IF;
3938:
3939: /* Initialize message list if p_init_msg_list is set to TRUE. */
3940: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3940: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3937: END IF;
3938:
3939: /* Initialize message list if p_init_msg_list is set to TRUE. */
3940: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3941: FND_MSG_PUB.initialize;
3942: END IF;
3943:
3944: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3944: x_return_status := FND_API.G_RET_STS_SUCCESS;

3940: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3941: FND_MSG_PUB.initialize;
3942: END IF;
3943:
3944: x_return_status := FND_API.G_RET_STS_SUCCESS;
3945:
3946: -- debug message
3947: jty_log(FND_LOG.LEVEL_STATEMENT,
3948: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.param_value',

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

3966: retcode => retcode,
3967: p_oic_mode => p_oic_mode,
3968: p_terr_id => p_terr_id);
3969:
3970: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3971: -- debug message
3972: jty_log(FND_LOG.LEVEL_EXCEPTION,
3973: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.match',
3974: 'process_match API has failed for source : ' || p_source_id || ' trans : ' || p_trans_id ||

Line 3977: RAISE FND_API.G_EXC_ERROR;

3973: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.match',
3974: 'process_match API has failed for source : ' || p_source_id || ' trans : ' || p_trans_id ||
3975: ' program name : ' || p_program_name);
3976:
3977: RAISE FND_API.G_EXC_ERROR;
3978: END IF;
3979: -- debug message
3980: jty_log(FND_LOG.LEVEL_EVENT,
3981: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.end_match',

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

3998: errbuf => errbuf,
3999: retcode => retcode,
4000: p_oic_mode => p_oic_mode);
4001:
4002: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4003: -- debug message
4004: jty_log(FND_LOG.LEVEL_EXCEPTION,
4005: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner',
4006: 'process_winners API has failed for source : ' || p_source_id || ' trans : ' || p_trans_id ||

Line 4009: RAISE FND_API.G_EXC_ERROR;

4005: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner',
4006: 'process_winners API has failed for source : ' || p_source_id || ' trans : ' || p_trans_id ||
4007: ' program name : ' || p_program_name);
4008:
4009: RAISE FND_API.G_EXC_ERROR;
4010: END IF;
4011:
4012: -- debug message
4013: jty_log(FND_LOG.LEVEL_EVENT,

Line 4023: WHEN FND_API.G_EXC_ERROR THEN

4019: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.end',
4020: 'End of the procedure JTY_ASSIGN_BULK_PUB.get_winners ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
4021:
4022: EXCEPTION
4023: WHEN FND_API.G_EXC_ERROR THEN
4024: x_return_status := FND_API.G_RET_STS_ERROR ;
4025: RETCODE := 2;
4026: x_msg_count := 1;
4027: jty_log(FND_LOG.LEVEL_EXCEPTION,

Line 4024: x_return_status := FND_API.G_RET_STS_ERROR ;

4020: 'End of the procedure JTY_ASSIGN_BULK_PUB.get_winners ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
4021:
4022: EXCEPTION
4023: WHEN FND_API.G_EXC_ERROR THEN
4024: x_return_status := FND_API.G_RET_STS_ERROR ;
4025: RETCODE := 2;
4026: x_msg_count := 1;
4027: jty_log(FND_LOG.LEVEL_EXCEPTION,
4028: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.g_exc_error',

Line 4032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4028: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.g_exc_error',
4029: x_msg_data);
4030:
4031: WHEN OTHERS THEN
4032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4033: x_msg_data := SQLCODE || ' : ' || SQLERRM;
4034: x_msg_count := 1;
4035: RETCODE := 2;
4036: ERRBUF := x_msg_data;