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_LOG

Line 46: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

42: ,p_message IN VARCHAR2)
43: IS
44: pragma autonomous_transaction;
45: BEGIN
46: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
47: FND_LOG.string(p_log_level, p_module, p_message);
48: commit;
49: END IF;
50: END;

Line 47: FND_LOG.string(p_log_level, p_module, p_message);

43: IS
44: pragma autonomous_transaction;
45: BEGIN
46: IF (p_log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
47: FND_LOG.string(p_log_level, p_module, p_message);
48: commit;
49: END IF;
50: END;
51:

Line 105: jty_log(FND_LOG.LEVEL_PROCEDURE,

101:
102: BEGIN
103:
104: -- debug message
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;

Line 214: jty_log(FND_LOG.LEVEL_STATEMENT,

210: g_new_line || l_seeded_sql ||
211: g_new_line || ' ) ) ';
212:
213: -- debug message
214: jty_log(FND_LOG.LEVEL_STATEMENT,
215: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.final_sql',
216: substr('Insert satement : ' || l_final_sql, 1, 4000));
217:
218: /* commit is executed to execute parallel dml in single transaction */

Line 226: jty_log(FND_LOG.LEVEL_STATEMENT,

222: commit;
223: EXECUTE IMMEDIATE 'alter session disable parallel dml';
224:
225: -- debug message
226: jty_log(FND_LOG.LEVEL_STATEMENT,
227: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.num_rows',
228: 'Number of rows inserted : ' || SQL%ROWCOUNT);
229:
230: -- debug message

Line 231: jty_log(FND_LOG.LEVEL_PROCEDURE,

227: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.num_rows',
228: 'Number of rows inserted : ' || SQL%ROWCOUNT);
229:
230: -- debug message
231: jty_log(FND_LOG.LEVEL_PROCEDURE,
232: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.end',
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

Line 241: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 250: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 259: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
260: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.no_data_found',
261: x_msg_data);
262:
263: WHEN OTHERS THEN

Line 268: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
269: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.other',
270: substr(x_msg_data, 1, 4000));
271:
272: END Insert_NM_Trans_Data;

Line 330: jty_log(FND_LOG.LEVEL_PROCEDURE,

326:
327: BEGIN
328:
329: -- debug message
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;

Line 395: jty_log(FND_LOG.LEVEL_STATEMENT,

391: RAISE L_SEED_DATA_NOTFOUND;
392: END IF;
393:
394: -- debug message
395: jty_log(FND_LOG.LEVEL_STATEMENT,
396: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.trans_table_name',
397: 'TRANS table name : ' || l_trans_target);
398: /*
399: jty_log(FND_LOG.LEVEL_STATEMENT,

Line 399: jty_log(FND_LOG.LEVEL_STATEMENT,

395: jty_log(FND_LOG.LEVEL_STATEMENT,
396: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.trans_table_name',
397: 'TRANS table name : ' || l_trans_target);
398: /*
399: jty_log(FND_LOG.LEVEL_STATEMENT,
400: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.trans_table_name',
401: ' Seeded SQL : ' || substr(l_seeded_sql, 1, 4000));
402: jty_log(FND_LOG.LEVEL_STATEMENT,
403: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.trans_table_name',

Line 402: jty_log(FND_LOG.LEVEL_STATEMENT,

398: /*
399: jty_log(FND_LOG.LEVEL_STATEMENT,
400: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.trans_table_name',
401: ' Seeded SQL : ' || substr(l_seeded_sql, 1, 4000));
402: jty_log(FND_LOG.LEVEL_STATEMENT,
403: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.trans_table_name',
404: ' Where clause : ' || substr(p_where, 1, 4000));
405: */
406:

Line 496: jty_log(FND_LOG.LEVEL_STATEMENT,

492: END IF;
493: l_final_sql := l_final_sql || ' ) ';
494:
495: -- debug message
496: jty_log(FND_LOG.LEVEL_STATEMENT,
497: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.final_sql',
498: substr('Insert satement : ' || l_final_sql, 1, 4000));
499:
500: /* commit is executed to execute parallel dml in single transaction */

Line 509: jty_log(FND_LOG.LEVEL_STATEMENT,

505: commit;
506: EXECUTE IMMEDIATE 'alter session disable parallel dml';
507:
508: -- debug message
509: jty_log(FND_LOG.LEVEL_STATEMENT,
510: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.num_rows',
511: 'Number of rows inserted : ' || SQL%ROWCOUNT);
512:
513: -- debug message

Line 514: jty_log(FND_LOG.LEVEL_PROCEDURE,

510: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.num_rows',
511: 'Number of rows inserted : ' || SQL%ROWCOUNT);
512:
513: -- debug message
514: jty_log(FND_LOG.LEVEL_PROCEDURE,
515: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.end',
516: 'End of the procedure JTY_ASSIGN_BULK_PUB.insert_trans_data ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
517:
518: EXCEPTION

Line 524: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 533: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 542: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
543: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.l_schema_notfound',
544: x_msg_data);
545:
546: WHEN NO_DATA_FOUND THEN

Line 551: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
552: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.no_data_found',
553: x_msg_data);
554:
555: WHEN OTHERS THEN

Line 560: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
561: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.other',
562: substr(x_msg_data, 1, 4000));
563:
564: END Insert_Trans_Data;

Line 605: jty_log(FND_LOG.LEVEL_PROCEDURE,

601: l_dummy NUMBER;
602: BEGIN
603:
604: -- debug message
605: jty_log(FND_LOG.LEVEL_PROCEDURE,
606: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.begin',
607: 'Start of the procedure JTY_ASSIGN_BULK_PUB.clear_trans_data ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
608:
609: /* Get the temp tables names corresponding to the usage, transaction type and program name */

Line 643: jty_log(FND_LOG.LEVEL_STATEMENT,

639: AND tup.trans_type_id = p_trans_id
640: AND tup.program_name = p_program_name;
641:
642: -- debug message
643: jty_log(FND_LOG.LEVEL_STATEMENT,
644: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.temp_table_names',
645: 'TRANS table name : ' || l_trans_target || ' MATCH table name : ' || l_match_target ||
646: ' WINNER table name : ' || l_winner_target || ' L1 table name : ' || l_L1_target ||
647: ' L2 table name : ' || l_L2_target || ' L3 table name : ' || l_L3_target ||

Line 655: jty_log(FND_LOG.LEVEL_STATEMENT,

651: /* Truncate and drop indexes on the TRANS table */
652: IF (l_trans_target IS NOT NULL) THEN
653:
654: -- debug message
655: jty_log(FND_LOG.LEVEL_STATEMENT,
656: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',
657: 'Deleting data and dropping indexes from ' || l_trans_target);
658:
659: /* Drop the indexes on the TRANS table */

Line 667: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
669: x_msg_data);
670:
671: RAISE FND_API.G_EXC_ERROR;

Line 682: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
684: x_msg_data);
685:
686: RAISE FND_API.G_EXC_ERROR;

Line 695: jty_log(FND_LOG.LEVEL_STATEMENT,

691: /* Truncate and drop indexes on the MATCH table */
692: IF (l_match_target IS NOT NULL) THEN
693:
694: -- debug message
695: jty_log(FND_LOG.LEVEL_STATEMENT,
696: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',
697: 'Deleting data and dropping indexes from ' || l_match_target);
698:
699: /* Drop the indexes on the MATCH table */

Line 708: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
709: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',
710: x_msg_data);
711:
712: RAISE FND_API.G_EXC_ERROR;

Line 723: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
725: x_msg_data);
726:
727: RAISE FND_API.G_EXC_ERROR;

Line 736: jty_log(FND_LOG.LEVEL_STATEMENT,

732: /* Truncate and drop indexes on the UMATCH table */
733: IF (l_umatch_target IS NOT NULL) THEN
734:
735: -- debug message
736: jty_log(FND_LOG.LEVEL_STATEMENT,
737: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',
738: 'Deleting data and dropping indexes from ' || l_umatch_target);
739:
740: /* Drop the indexes on the UMATCH table */

Line 749: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
750: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',
751: x_msg_data);
752:
753: RAISE FND_API.G_EXC_ERROR;

Line 764: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
766: x_msg_data);
767:
768: RAISE FND_API.G_EXC_ERROR;

Line 777: jty_log(FND_LOG.LEVEL_STATEMENT,

773: /* Truncate and drop indexes on the WINNER table */
774: IF (l_winner_target IS NOT NULL) THEN
775:
776: -- debug message
777: jty_log(FND_LOG.LEVEL_STATEMENT,
778: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',
779: 'Deleting data and dropping indexes from ' || l_winner_target);
780:
781: /* Drop the indexes on the WINNER table */

Line 790: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
791: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',
792: x_msg_data);
793:
794: RAISE FND_API.G_EXC_ERROR;

Line 805: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
807: x_msg_data);
808:
809: RAISE FND_API.G_EXC_ERROR;

Line 818: jty_log(FND_LOG.LEVEL_STATEMENT,

814: /* Truncate and drop indexes on the UWINNER table */
815: IF (l_uwinner_target IS NOT NULL) THEN
816:
817: -- debug message
818: jty_log(FND_LOG.LEVEL_STATEMENT,
819: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',
820: 'Deleting data and dropping indexes from ' || l_uwinner_target);
821:
822: /* Drop the indexes on the UWINNER table */

Line 831: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
832: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',
833: x_msg_data);
834:
835: RAISE FND_API.G_EXC_ERROR;

Line 846: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
848: x_msg_data);
849:
850: RAISE FND_API.G_EXC_ERROR;

Line 859: jty_log(FND_LOG.LEVEL_STATEMENT,

855: /* Truncate and drop indexes on the L1 table */
856: IF (l_l1_target IS NOT NULL) THEN
857:
858: -- debug message
859: jty_log(FND_LOG.LEVEL_STATEMENT,
860: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l1_clear',
861: 'Deleting data and dropping indexes from ' || l_l1_target);
862:
863: /* Drop the indexes on the L1 table */

Line 872: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
873: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l1_clear',
874: x_msg_data);
875:
876: RAISE FND_API.G_EXC_ERROR;

Line 887: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
889: x_msg_data);
890:
891: RAISE FND_API.G_EXC_ERROR;

Line 900: jty_log(FND_LOG.LEVEL_STATEMENT,

896: /* Truncate and drop indexes on the L2 table */
897: IF (l_l2_target IS NOT NULL) THEN
898:
899: -- debug message
900: jty_log(FND_LOG.LEVEL_STATEMENT,
901: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',
902: 'Deleting data and dropping indexes from ' || l_l2_target);
903:
904: /* Drop the indexes on the L2 table */

Line 913: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
914: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',
915: x_msg_data);
916:
917: RAISE FND_API.G_EXC_ERROR;

Line 928: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
930: x_msg_data);
931:
932: RAISE FND_API.G_EXC_ERROR;

Line 941: jty_log(FND_LOG.LEVEL_STATEMENT,

937: /* Truncate and drop indexes on the L3 table */
938: IF (l_l3_target IS NOT NULL) THEN
939:
940: -- debug message
941: jty_log(FND_LOG.LEVEL_STATEMENT,
942: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',
943: 'Deleting data and dropping indexes from ' || l_l3_target);
944:
945: /* Drop the indexes on the L3 table */

Line 954: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
955: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',
956: x_msg_data);
957:
958: RAISE FND_API.G_EXC_ERROR;

Line 969: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
971: x_msg_data);
972:
973: RAISE FND_API.G_EXC_ERROR;

Line 982: jty_log(FND_LOG.LEVEL_STATEMENT,

978: /* Truncate and drop indexes on the L4 table */
979: IF (l_l4_target IS NOT NULL) THEN
980:
981: -- debug message
982: jty_log(FND_LOG.LEVEL_STATEMENT,
983: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',
984: 'Deleting data and dropping indexes from ' || l_l4_target);
985:
986: /* Drop the indexes on the L4 table */

Line 995: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
996: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',
997: x_msg_data);
998:
999: RAISE FND_API.G_EXC_ERROR;

Line 1010: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
1012: x_msg_data);
1013:
1014: RAISE FND_API.G_EXC_ERROR;

Line 1023: jty_log(FND_LOG.LEVEL_STATEMENT,

1019: /* Truncate and drop indexes on the L5 table */
1020: IF (l_l5_target IS NOT NULL) THEN
1021:
1022: -- debug message
1023: jty_log(FND_LOG.LEVEL_STATEMENT,
1024: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',
1025: 'Deleting data and dropping indexes from ' || l_l5_target);
1026:
1027: /* Drop the indexes on the L5 table */

Line 1036: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
1037: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',
1038: x_msg_data);
1039:
1040: RAISE FND_API.G_EXC_ERROR;

Line 1051: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
1053: x_msg_data);
1054:
1055: RAISE FND_API.G_EXC_ERROR;

Line 1064: jty_log(FND_LOG.LEVEL_STATEMENT,

1060: /* Truncate and drop indexes on the WT table */
1061: IF (l_wt_target IS NOT NULL) THEN
1062:
1063: -- debug message
1064: jty_log(FND_LOG.LEVEL_STATEMENT,
1065: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',
1066: 'Deleting data and dropping indexes from ' || l_wt_target);
1067:
1068: /* Drop the indexes on the WT table */

Line 1077: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
1078: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',
1079: x_msg_data);
1080:
1081: RAISE FND_API.G_EXC_ERROR;

Line 1092: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
1094: x_msg_data);
1095:
1096: RAISE FND_API.G_EXC_ERROR;

Line 1128: jty_log(FND_LOG.LEVEL_PROCEDURE,

1124: END;
1125: END IF;
1126:
1127: -- debug message
1128: jty_log(FND_LOG.LEVEL_PROCEDURE,
1129: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.end',
1130: 'End of the procedure JTY_ASSIGN_BULK_PUB.clear_trans_data ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1131:
1132: EXCEPTION

Line 1140: jty_log(FND_LOG.LEVEL_EXCEPTION,

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;
1139: ERRBUF := x_msg_data;
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

Line 1148: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
1149: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Clear_Trans_Data.g_exc_error',
1150: x_msg_data);
1151:
1152: WHEN OTHERS THEN

Line 1157: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
1158: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.other',
1159: substr(x_msg_data, 1, 4000));
1160:
1161: END Clear_Trans_Data;

Line 1209: jty_log(FND_LOG.LEVEL_PROCEDURE,

1205:
1206: BEGIN
1207:
1208: -- debug message
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;

Line 1251: jty_log(FND_LOG.LEVEL_STATEMENT,

1247: AND tup.trans_type_id = p_trans_id
1248: AND tup.program_name = p_program_name;
1249:
1250: -- debug message
1251: jty_log(FND_LOG.LEVEL_STATEMENT,
1252: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.temp_table_names',
1253: 'TRANS table name : ' || l_trans_target || ' MATCH table name : ' || l_match_target ||
1254: ' WINNER table name : ' || l_winner_target || ' L1 table name : ' || l_L1_target ||
1255: ' L2 table name : ' || l_L2_target || ' L3 table name : ' || l_L3_target ||

Line 1309: jty_log(FND_LOG.LEVEL_STATEMENT,

1305: START WITH jt.terr_id = jt1.terr_id)
1306: AND jqtu.qual_type_id <> -1001;
1307:
1308: -- debug message
1309: jty_log(FND_LOG.LEVEL_STATEMENT,
1310: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.num_of_terr',
1311: 'Number of valid territories with resources for this transaction : ' || num_of_terr);
1312:
1313: IF (num_of_terr = 0) THEN

Line 1326: jty_log(FND_LOG.LEVEL_STATEMENT,

1322: d_statement := ' SELECT COUNT(*) FROM ' || l_trans_target || ' WHERE rownum < 2 ';
1323: EXECUTE IMMEDIATE d_statement INTO num_of_trans;
1324:
1325: -- debug message
1326: jty_log(FND_LOG.LEVEL_STATEMENT,
1327: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.num_of_trans',
1328: 'Number of valid transaction objects : ' || num_of_trans);
1329:
1330: IF (num_of_trans = 0) THEN

Line 1336: jty_log(FND_LOG.LEVEL_STATEMENT,

1332: RAISE NO_TAE_DATA_FOUND;
1333: END IF;
1334:
1335: -- debug message
1336: jty_log(FND_LOG.LEVEL_STATEMENT,
1337: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_trans',
1338: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_trans_target);
1339:
1340: JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX(

Line 1352: jty_log(FND_LOG.LEVEL_STATEMENT,

1348: RAISE FND_API.G_EXC_ERROR;
1349: END IF;
1350:
1351: -- debug message
1352: jty_log(FND_LOG.LEVEL_STATEMENT,
1353: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.decompose_terr_defns',
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

Line 1380: jty_log(FND_LOG.LEVEL_STATEMENT,

1376: RAISE FND_API.G_EXC_ERROR;
1377: END IF;
1378:
1379: -- debug message
1380: jty_log(FND_LOG.LEVEL_STATEMENT,
1381: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_matches',
1382: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_match_target);
1383:
1384: /* Build Index on Matches table */

Line 1400: jty_log(FND_LOG.LEVEL_STATEMENT,

1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;
1398:
1399: -- debug message
1400: jty_log(FND_LOG.LEVEL_STATEMENT,
1401: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_winners',
1402: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_winner_target);
1403:
1404: /* Build Index on Winners table */

Line 1420: jty_log(FND_LOG.LEVEL_STATEMENT,

1416: RAISE FND_API.G_EXC_ERROR;
1417: END IF;
1418:
1419: -- debug message
1420: jty_log(FND_LOG.LEVEL_STATEMENT,
1421: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l1',
1422: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l1_target);
1423:
1424: /* Build Index on L1 table */

Line 1440: jty_log(FND_LOG.LEVEL_STATEMENT,

1436: RAISE FND_API.G_EXC_ERROR;
1437: END IF;
1438:
1439: -- debug message
1440: jty_log(FND_LOG.LEVEL_STATEMENT,
1441: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l2',
1442: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l2_target);
1443:
1444: /* Build Index on L2 table */

Line 1461: jty_log(FND_LOG.LEVEL_STATEMENT,

1457: END IF;
1458:
1459:
1460: -- debug message
1461: jty_log(FND_LOG.LEVEL_STATEMENT,
1462: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l3',
1463: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l3_target);
1464:
1465: /* Build Index on L3 table */

Line 1481: jty_log(FND_LOG.LEVEL_STATEMENT,

1477: RAISE FND_API.G_EXC_ERROR;
1478: END IF;
1479:
1480: -- debug message
1481: jty_log(FND_LOG.LEVEL_STATEMENT,
1482: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l4',
1483: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l4_target);
1484:
1485: /* Build Index on L4 table */

Line 1501: jty_log(FND_LOG.LEVEL_STATEMENT,

1497: RAISE FND_API.G_EXC_ERROR;
1498: END IF;
1499:
1500: -- debug message
1501: jty_log(FND_LOG.LEVEL_STATEMENT,
1502: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l5',
1503: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_l5_target);
1504:
1505: /* Build Index on L5 table */

Line 1521: jty_log(FND_LOG.LEVEL_STATEMENT,

1517: RAISE FND_API.G_EXC_ERROR;
1518: END IF;
1519:
1520: -- debug message
1521: jty_log(FND_LOG.LEVEL_STATEMENT,
1522: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_wt',
1523: 'Call to JTY_TAE_INDEX_CREATION_PVT.ANALYZE_TABLE_INDEX API begins for : ' || l_wt_target);
1524:
1525: /* Build Index on WT table */

Line 1548: jty_log(FND_LOG.LEVEL_PROCEDURE,

1544: EXECUTE IMMEDIATE d_statement USING p_no_of_workers;
1545: END IF;
1546:
1547: -- debug message
1548: jty_log(FND_LOG.LEVEL_PROCEDURE,
1549: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.end',
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

Line 1558: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 1567: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 1576: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
1577: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.g_exc_unexpected_error',
1578: x_msg_data);
1579:
1580: WHEN OTHERS THEN

Line 1586: jty_log(FND_LOG.LEVEL_EXCEPTION,

1582: x_msg_data := SQLCODE || ' : ' || SQLERRM;
1583: x_msg_count := 1;
1584: RETCODE := 2;
1585: ERRBUF := x_msg_data;
1586: jty_log(FND_LOG.LEVEL_EXCEPTION,
1587: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.other',
1588: substr(x_msg_data, 1, 4000));
1589:
1590: END get_winners_parallel_setup;

Line 1615: jty_log(FND_LOG.LEVEL_PROCEDURE,

1611:
1612: BEGIN
1613:
1614: -- debug message
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;

Line 1898: jty_log(FND_LOG.LEVEL_STATEMENT,

1894:
1895: END IF; /* end IF ( p_UPPER_LEVEL_FROM_ROOT = 1 AND p_LOWER_LEVEL_FROM_ROOT = 1) */
1896:
1897: -- debug message
1898: jty_log(FND_LOG.LEVEL_STATEMENT,
1899: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.num_rows',
1900: 'Number of rows inserted into ' || p_terr_LEVEL_target_tbl || ' : ' || SQL%ROWCOUNT);
1901:
1902: -- debug message

Line 1903: jty_log(FND_LOG.LEVEL_PROCEDURE,

1899: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.num_rows',
1900: 'Number of rows inserted into ' || p_terr_LEVEL_target_tbl || ' : ' || SQL%ROWCOUNT);
1901:
1902: -- debug message
1903: jty_log(FND_LOG.LEVEL_PROCEDURE,
1904: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.end',
1905: 'End of the procedure JTY_ASSIGN_BULK_PUB.Process_Level_Winners ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
1906:
1907: EXCEPTION

Line 1911: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 1918: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
1922: END Process_Level_Winners;

Line 1946: jty_log(FND_LOG.LEVEL_PROCEDURE,

1942:
1943: BEGIN
1944:
1945: -- debug message
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;

Line 2039: jty_log(FND_LOG.LEVEL_STATEMENT,

2035: NULL;
2036: END;
2037:
2038: -- debug message
2039: jty_log(FND_LOG.LEVEL_STATEMENT,
2040: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners.num_rows',
2041: 'Number of rows inserted into ' || p_terr_LEVEL_target_tbl || ' : ' || SQL%ROWCOUNT);
2042:
2043: -- debug message

Line 2044: jty_log(FND_LOG.LEVEL_PROCEDURE,

2040: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners.num_rows',
2041: 'Number of rows inserted into ' || p_terr_LEVEL_target_tbl || ' : ' || SQL%ROWCOUNT);
2042:
2043: -- debug message
2044: jty_log(FND_LOG.LEVEL_PROCEDURE,
2045: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners.end',
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

Line 2051: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
2055: END Process_Final_Level_Winners;

Line 2114: jty_log(FND_LOG.LEVEL_PROCEDURE,

2110: L_SCHEMA_NOTFOUND EXCEPTION;
2111: BEGIN
2112:
2113: -- debug message
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;

Line 2211: jty_log(FND_LOG.LEVEL_STATEMENT,

2207: l_final_sql := l_insert_stmt || g_new_line ||
2208: l_select_stmt || g_new_line || 'FROM ' || l_nm_trans_target || g_new_line || ' ) ';
2209:
2210: -- debug message
2211: jty_log(FND_LOG.LEVEL_STATEMENT,
2212: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.final_sql',
2213: substr('Insert satement : ' || l_final_sql, 1, 4000));
2214:
2215: /* Insert all the transaction objects into the TRANS table */

Line 2256: jty_log(FND_LOG.LEVEL_STATEMENT,

2252:
2253: END IF;
2254:
2255: -- debug message
2256: jty_log(FND_LOG.LEVEL_STATEMENT,
2257: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.match',
2258: 'Number of records inserted for qualifier combination ' || jtf_csr.relation_product || ' : ' || SQL%ROWCOUNT);
2259: END LOOP;
2260:

Line 2262: jty_log(FND_LOG.LEVEL_PROCEDURE,

2258: 'Number of records inserted for qualifier combination ' || jtf_csr.relation_product || ' : ' || SQL%ROWCOUNT);
2259: END LOOP;
2260:
2261: -- debug message
2262: jty_log(FND_LOG.LEVEL_PROCEDURE,
2263: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.end',
2264: 'End of the procedure JTY_ASSIGN_BULK_PUB.process_nmc_match ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
2265:
2266: EXCEPTION

Line 2273: jty_log(FND_LOG.LEVEL_EXCEPTION,

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;
2273: jty_log(FND_LOG.LEVEL_EXCEPTION,
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

Line 2282: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
2283: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.no_data_found',
2284: x_msg_data);
2285:
2286: WHEN OTHERS THEN

Line 2292: jty_log(FND_LOG.LEVEL_EXCEPTION,

2288: x_msg_data := SQLCODE || ' : ' || SQLERRM;
2289: x_msg_count := 1;
2290: RETCODE := 2;
2291: ERRBUF := x_msg_data;
2292: jty_log(FND_LOG.LEVEL_EXCEPTION,
2293: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.other',
2294: substr(x_msg_data, 1, 4000));
2295:
2296: END process_nmc_match;

Line 2336: jty_log(FND_LOG.LEVEL_PROCEDURE,

2332:
2333: BEGIN
2334:
2335: -- debug message
2336: jty_log(FND_LOG.LEVEL_PROCEDURE,
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. */

Line 2360: jty_log(FND_LOG.LEVEL_STATEMENT,

2356:
2357: IF p_oic_mode = 'NOOIC' or p_oic_mode = 'CLEAR' THEN
2358:
2359: -- debug message
2360: jty_log(FND_LOG.LEVEL_STATEMENT,
2361: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.param_value',
2362: 'Source : ' || p_source_id || ' Trans : ' || p_trans_id || ' Program Name : ' || p_program_name ||
2363: ' Mode : ' || p_mode || ' Where clause : ' || p_where || ' Number of workers : ' || p_no_of_workers ||
2364: ' Percent Analyzed : ' || p_percent_analyzed);

Line 2382: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
2384: x_msg_data);
2385:
2386: RAISE FND_API.G_EXC_ERROR;

Line 2390: jty_log(FND_LOG.LEVEL_EVENT,

2386: RAISE FND_API.G_EXC_ERROR;
2387: END IF;
2388:
2389: -- debug message
2390: jty_log(FND_LOG.LEVEL_EVENT,
2391: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end_clear_trans_data',
2392: 'API clear_trans_data completed successfully');
2393: END IF; -- p_oic_mode = 'NOOIC' or p_oic_mode = 'CLEAR'
2394:

Line 2417: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
2419: x_msg_data);
2420:
2421: RAISE FND_API.G_EXC_ERROR;

Line 2425: jty_log(FND_LOG.LEVEL_EVENT,

2421: RAISE FND_API.G_EXC_ERROR;
2422: END IF;
2423:
2424: -- debug message
2425: jty_log(FND_LOG.LEVEL_EVENT,
2426: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end_insert_trans_data',
2427: 'API insert_trans_data completed successfully');
2428: END IF; -- p_oic_mode = 'NOOIC' or p_oic_mode = 'INSERT'
2429:

Line 2449: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
2451: x_msg_data);
2452:
2453: RAISE FND_API.G_EXC_ERROR;

Line 2457: jty_log(FND_LOG.LEVEL_EVENT,

2453: RAISE FND_API.G_EXC_ERROR;
2454: END IF;
2455:
2456: -- debug message
2457: jty_log(FND_LOG.LEVEL_EVENT,
2458: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end_process_nmc_match',
2459: 'API process_nmc_match completed successfully');
2460:
2461: /* insert into NM_TRANS txn objs that are assigned to changed territories */

Line 2476: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
2478: x_msg_data);
2479:
2480: RAISE FND_API.G_EXC_ERROR;

Line 2484: jty_log(FND_LOG.LEVEL_EVENT,

2480: RAISE FND_API.G_EXC_ERROR;
2481: END IF;
2482:
2483: -- debug message
2484: jty_log(FND_LOG.LEVEL_EVENT,
2485: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end_insert_nm_trans_data',
2486: 'API insert_nm_trans_data completed successfully');
2487:
2488: END IF; /* end IF (p_mode = 'INCREMENTAL') */

Line 2510: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
2512: x_msg_data);
2513:
2514: RAISE FND_API.G_EXC_ERROR;

Line 2522: jty_log(FND_LOG.LEVEL_PROCEDURE,

2518: retcode := 0;
2519: errbuf := null;
2520:
2521: -- debug message
2522: jty_log(FND_LOG.LEVEL_PROCEDURE,
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

Line 2532: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 2541: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 2549: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
2550: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.g_exc_error',
2551: x_msg_data);
2552:
2553: WHEN OTHERS THEN

Line 2559: jty_log(FND_LOG.LEVEL_EXCEPTION,

2555: x_msg_data := SQLCODE || ' : ' || SQLERRM;
2556: x_msg_count := 1;
2557: RETCODE := 2;
2558: ERRBUF := x_msg_data;
2559: jty_log(FND_LOG.LEVEL_EXCEPTION,
2560: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.other',
2561: substr(x_msg_data, 1, 4000));
2562:
2563: END collect_trans_data;

Line 2620: jty_log(FND_LOG.LEVEL_PROCEDURE,

2616: L_NO_MATCH_TERR EXCEPTION;
2617: BEGIN
2618:
2619: -- debug message
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;

Line 2801: jty_log(FND_LOG.LEVEL_STATEMENT,

2797: , p_trans_id;
2798:
2799: COMMIT; -- after modifying table in parallel
2800:
2801: jty_log(FND_LOG.LEVEL_STATEMENT,
2802: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.winner_num_row',
2803: 'Number of records inserted into ' || l_winner_target || ' for worker_id : ' || p_worker_id || ' : ' || SQL%ROWCOUNT);
2804: EXCEPTION
2805: WHEN NO_DATA_FOUND THEN

Line 2810: jty_log(FND_LOG.LEVEL_STATEMENT,

2806: NULL;
2807: END;
2808:
2809: ELSE
2810: jty_log(FND_LOG.LEVEL_STATEMENT,
2811: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.winning_process',
2812: 'Star of winning process');
2813:
2814: IF (FND_INSTALLATION.GET_APP_INFO('FND', l_status, l_industry, l_fnd_schema)) THEN

Line 2831: jty_log(FND_LOG.LEVEL_STATEMENT,

2827: 'GROUP BY trans_object_id, trans_detail_object_id';
2828:
2829: EXECUTE IMMEDIATE l_dyn_str INTO l_max_terr USING p_worker_id;
2830:
2831: jty_log(FND_LOG.LEVEL_STATEMENT,
2832: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_max_terr',
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

Line 2851: jty_log(FND_LOG.LEVEL_STATEMENT,

2847: BEGIN
2848: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.drop_table, 'drop table ' || l_mp_winner_target, l_mp_winner_target);
2849: EXCEPTION
2850: when others then
2851: jty_log(FND_LOG.LEVEL_STATEMENT,
2852: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_target',
2853: 'Table ' || l_mp_winner_target || ' drop FAILED ');
2854: -- RAISE ;
2855: END;

Line 2857: jty_log(FND_LOG.LEVEL_STATEMENT,

2853: 'Table ' || l_mp_winner_target || ' drop FAILED ');
2854: -- RAISE ;
2855: END;
2856:
2857: jty_log(FND_LOG.LEVEL_STATEMENT,
2858: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_target',
2859: 'Table ' || l_mp_winner_target || ' successfully dropped');
2860:
2861: /* create a temp table that will contain all the transaction objects */

Line 2881: jty_log(FND_LOG.LEVEL_STATEMENT,

2877: ' from ' || l_match_target ||
2878: ' where worker_id = ' || p_worker_id || ' ) ' ||
2879: ' group by trans_object_id, trans_detail_object_id, txn_date )';
2880:
2881: jty_log(FND_LOG.LEVEL_STATEMENT,
2882: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_target',
2883: substr(l_dyn_str, 1, 4000));
2884:
2885: /* create the table in jtf schema */

Line 2888: jty_log(FND_LOG.LEVEL_STATEMENT,

2884:
2885: /* create the table in jtf schema */
2886: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_table, l_dyn_str, l_mp_winner_target);
2887:
2888: jty_log(FND_LOG.LEVEL_STATEMENT,
2889: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_target',
2890: 'Table ' || l_mp_winner_target || ' successfully created');
2891:
2892: /* create a temp table that will contain only the distinct */

Line 2899: jty_log(FND_LOG.LEVEL_STATEMENT,

2895: BEGIN
2896: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.drop_table, 'drop table ' || l_dmc_winner_target, l_dmc_winner_target);
2897: EXCEPTION
2898: when others then
2899: jty_log(FND_LOG.LEVEL_STATEMENT,
2900: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target',
2901: 'Table ' || l_dmc_winner_target || ' drop FAILED');
2902: -- RAISE;
2903: END;

Line 2905: jty_log(FND_LOG.LEVEL_STATEMENT,

2901: 'Table ' || l_dmc_winner_target || ' drop FAILED');
2902: -- RAISE;
2903: END;
2904:
2905: jty_log(FND_LOG.LEVEL_STATEMENT,
2906: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target',
2907: 'Table ' || l_dmc_winner_target || ' successfully dropped');
2908:
2909: /* Form the create table statement */

Line 2924: jty_log(FND_LOG.LEVEL_STATEMENT,

2920: ' ,terr_id' || i;
2921: end loop;
2922: l_dyn_str := l_dyn_str || ' )';
2923:
2924: jty_log(FND_LOG.LEVEL_STATEMENT,
2925: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target',
2926: substr(l_dyn_str, 1, 4000));
2927:
2928: /* Create the table in JTF schema */

Line 2931: jty_log(FND_LOG.LEVEL_STATEMENT,

2927:
2928: /* Create the table in JTF schema */
2929: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_table, l_dyn_str, l_dmc_winner_target);
2930:
2931: jty_log(FND_LOG.LEVEL_STATEMENT,
2932: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target',
2933: 'Table ' || l_dmc_winner_target || ' successfully created');
2934:
2935: /* Insert into umatch table the unique combination of matching territories */

Line 3010: jty_log(FND_LOG.LEVEL_STATEMENT,

3006: end if;
3007: end loop;
3008: l_dyn_str := l_dyn_str || ' )';
3009: */
3010: jty_log(FND_LOG.LEVEL_STATEMENT,
3011: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_umatch',
3012: substr(l_dyn_str, 1, 4000));
3013:
3014: execute immediate l_dyn_str;

Line 3016: jty_log(FND_LOG.LEVEL_STATEMENT,

3012: substr(l_dyn_str, 1, 4000));
3013:
3014: execute immediate l_dyn_str;
3015:
3016: jty_log(FND_LOG.LEVEL_STATEMENT,
3017: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_umatch',
3018: 'Data successfully inserted in umatch table');
3019:
3020: /* Create in index on l_dmc_winner_target */

Line 3034: jty_log(FND_LOG.LEVEL_STATEMENT,

3030: ' , terr_id' || i;
3031: end loop;
3032: l_dyn_str := l_dyn_str || ' )';
3033:
3034: jty_log(FND_LOG.LEVEL_STATEMENT,
3035: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target_index',
3036: substr(l_dyn_str, 1, 4000));
3037:
3038: /* Create the index in JTF schema */

Line 3054: jty_log(FND_LOG.LEVEL_STATEMENT,

3050: ' and a.terr_id' || i || ' = b.terr_id' || i || ' ';
3051: end loop;
3052: l_dyn_str := l_dyn_str || ' )';
3053:
3054: jty_log(FND_LOG.LEVEL_STATEMENT,
3055: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_update',
3056: substr(l_dyn_str, 1, 4000));
3057:
3058: execute immediate l_dyn_str;

Line 3060: jty_log(FND_LOG.LEVEL_STATEMENT,

3056: substr(l_dyn_str, 1, 4000));
3057:
3058: execute immediate l_dyn_str;
3059:
3060: jty_log(FND_LOG.LEVEL_STATEMENT,
3061: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_update',
3062: 'Link successfully updated in ' || l_dmc_winner_target || ' table');
3063:
3064: /* Process first level */

Line 3079: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 3095: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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',
3098: x_msg_data);
3099: END IF;

Line 3096: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
3098: x_msg_data);
3099: END IF;
3100: RAISE FND_API.G_EXC_ERROR;

Line 3119: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 3135: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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',
3138: x_msg_data);
3139: END IF;

Line 3136: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
3138: x_msg_data);
3139: END IF;
3140: RAISE FND_API.G_EXC_ERROR;

Line 3159: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 3175: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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',
3178: x_msg_data);
3179: END IF;

Line 3176: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
3178: x_msg_data);
3179: END IF;
3180: RAISE FND_API.G_EXC_ERROR;

Line 3199: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 3215: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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',
3218: x_msg_data);
3219: END IF;

Line 3216: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
3218: x_msg_data);
3219: END IF;
3220: RAISE FND_API.G_EXC_ERROR;

Line 3239: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 3255: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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',
3258: x_msg_data);
3259: END IF;

Line 3256: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
3258: x_msg_data);
3259: END IF;
3260: RAISE FND_API.G_EXC_ERROR;

Line 3277: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 3293: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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',
3296: x_msg_data);
3297: END IF;

Line 3294: jty_log(FND_LOG.LEVEL_EXCEPTION,

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',
3296: x_msg_data);
3297: END IF;
3298: RAISE FND_API.G_EXC_ERROR;

Line 3302: jty_log(FND_LOG.LEVEL_EXCEPTION,

3298: RAISE FND_API.G_EXC_ERROR;
3299: END IF;
3300: */
3301:
3302: jty_log(FND_LOG.LEVEL_EXCEPTION,
3303: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.begin_populate_winners',
3304: 'Start of populating the winner table');
3305:
3306: l_dyn_str :=

Line 3467: jty_log(FND_LOG.LEVEL_STATEMENT,

3463: , p_worker_id /* :bv_worker_id */
3464: , p_worker_id /* :bv_worker_id */ --10
3465: , p_worker_id; /* :bv_worker_id */
3466:
3467: jty_log(FND_LOG.LEVEL_STATEMENT,
3468: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner_num_row',
3469: 'Number of records inserted into ' || l_winner_target || ' for worker_id : ' || p_worker_id || ' : ' || SQL%ROWCOUNT);
3470:
3471: COMMIT; -- after modifying table in parallel

Line 3584: jty_log(FND_LOG.LEVEL_STATEMENT,

3580: , lp_sysdate /* :BV1_PROGRAM_UPDATE_DATE */
3581: , p_worker_id /* :bv_worker_id */ --1
3582: , p_trans_id;
3583:
3584: jty_log(FND_LOG.LEVEL_STATEMENT,
3585: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner_num_row',
3586: 'Number of records inserted into ' || l_winner_target || ' for worker_id : ' || p_worker_id || ' : ' || SQL%ROWCOUNT);
3587:
3588: COMMIT; -- after modifying table in parallel

Line 3608: jty_log(FND_LOG.LEVEL_EXCEPTION,

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);
3611: RAISE FND_API.G_EXC_ERROR;
3612: END IF;

Line 3621: jty_log(FND_LOG.LEVEL_PROCEDURE,

3617: x_return_status := FND_API.G_RET_STS_SUCCESS;
3618: RETCODE := 0;
3619:
3620: -- debug message
3621: jty_log(FND_LOG.LEVEL_PROCEDURE,
3622: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.end',
3623: 'End of the procedure JTY_ASSIGN_BULK_PUB.process_winner ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
3624:
3625: EXCEPTION

Line 3632: jty_log(FND_LOG.LEVEL_EXCEPTION,

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;
3632: jty_log(FND_LOG.LEVEL_EXCEPTION,
3633: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.l_schema_notfound',
3634: x_msg_data);
3635:
3636: WHEN NO_DATA_FOUND THEN

Line 3641: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
3642: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.no_data_found',
3643: x_msg_data);
3644:
3645: WHEN L_NO_MATCH_TERR THEN

Line 3646: jty_log(FND_LOG.LEVEL_EXCEPTION,

3642: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.no_data_found',
3643: x_msg_data);
3644:
3645: WHEN L_NO_MATCH_TERR 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

Line 3655: jty_log(FND_LOG.LEVEL_EXCEPTION,

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,
3656: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.g_exc_error',
3657: x_msg_data);
3658:
3659: WHEN OTHERS THEN

Line 3665: jty_log(FND_LOG.LEVEL_EXCEPTION,

3661: x_msg_data := SQLCODE || ' : ' || SQLERRM;
3662: x_msg_count := 1;
3663: RETCODE := 2;
3664: ERRBUF := x_msg_data;
3665: jty_log(FND_LOG.LEVEL_EXCEPTION,
3666: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.other',
3667: substr(x_msg_data, 1, 4000));
3668:
3669: END process_winners;

Line 3722: jty_log(FND_LOG.LEVEL_PROCEDURE,

3718:
3719: BEGIN
3720:
3721: -- debug message
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;

Line 3782: jty_log(FND_LOG.LEVEL_STATEMENT,

3778: END;
3779:
3780: EXECUTE IMMEDIATE l_match_sql USING l_sysdate, g_user_id, l_sysdate, g_user_id, g_user_id, g_request_id,
3781: g_appl_id, g_program_id, l_sysdate, p_worker_id;
3782: jty_log(FND_LOG.LEVEL_STATEMENT,
3783: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.dea_match',
3784: 'Number of records inserted for qualifier combination ' || jtf_csr.attr_relation_product || ' : ' || SQL%ROWCOUNT);
3785:
3786: END LOOP;

Line 3806: jty_log(FND_LOG.LEVEL_STATEMENT,

3802: END;
3803:
3804: EXECUTE IMMEDIATE l_match_sql USING l_sysdate, g_user_id, l_sysdate, g_user_id, g_user_id, g_request_id,
3805: g_appl_id, g_program_id, l_sysdate, p_worker_id, p_terr_id;
3806: jty_log(FND_LOG.LEVEL_STATEMENT,
3807: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.dea_match',
3808: 'Number of records inserted for qualifier combination ' || jtf_csr.attr_relation_product || ' : ' || SQL%ROWCOUNT);
3809:
3810: END LOOP;

Line 3833: jty_log(FND_LOG.LEVEL_STATEMENT,

3829:
3830: EXECUTE IMMEDIATE l_match_sql USING l_sysdate, g_user_id, l_sysdate, g_user_id, g_user_id, g_request_id,
3831: g_appl_id, g_program_id, l_sysdate, p_worker_id;
3832: -- debug message
3833: jty_log(FND_LOG.LEVEL_STATEMENT,
3834: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.match',
3835: 'Number of records inserted for qualifier combination ' || jtf_csr.relation_product || ' : ' || SQL%ROWCOUNT);
3836: END LOOP;
3837:

Line 3849: jty_log(FND_LOG.LEVEL_EXCEPTION,

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:
3853: RAISE FND_API.G_EXC_ERROR;

Line 3861: jty_log(FND_LOG.LEVEL_PROCEDURE,

3857: errbuf := x_msg_data;
3858: END IF;
3859: END IF;
3860: -- debug message
3861: jty_log(FND_LOG.LEVEL_PROCEDURE,
3862: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.end',
3863: 'End of the procedure JTY_ASSIGN_BULK_PUB.process_match ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));
3864:
3865: EXCEPTION

Line 3871: jty_log(FND_LOG.LEVEL_EXCEPTION,

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

Line 3876: 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:
3880: WHEN OTHERS THEN

Line 3886: jty_log(FND_LOG.LEVEL_EXCEPTION,

3882: x_msg_data := SQLCODE || ' : ' || SQLERRM;
3883: x_msg_count := 1;
3884: RETCODE := 2;
3885: ERRBUF := x_msg_data;
3886: jty_log(FND_LOG.LEVEL_EXCEPTION,
3887: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.other',
3888: substr(x_msg_data, 1, 4000));
3889:
3890: END process_match;

Line 3926: jty_log(FND_LOG.LEVEL_PROCEDURE,

3922:
3923: BEGIN
3924:
3925: -- debug message
3926: jty_log(FND_LOG.LEVEL_PROCEDURE,
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. */

Line 3947: jty_log(FND_LOG.LEVEL_STATEMENT,

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',
3949: 'Source : ' || p_source_id || ' Trans : ' || p_trans_id || ' Program Name : ' || p_program_name ||
3950: ' Mode : ' || p_mode || ' Worker : ' || p_worker_id);
3951:

Line 3972: jty_log(FND_LOG.LEVEL_EXCEPTION,

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 ||
3975: ' program name : ' || p_program_name);
3976:

Line 3980: jty_log(FND_LOG.LEVEL_EVENT,

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',
3982: 'Matching process completed successfully');
3983: END IF;
3984:

Line 4004: jty_log(FND_LOG.LEVEL_EXCEPTION,

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 ||
4007: ' program name : ' || p_program_name);
4008:

Line 4013: jty_log(FND_LOG.LEVEL_EVENT,

4009: RAISE FND_API.G_EXC_ERROR;
4010: END IF;
4011:
4012: -- debug message
4013: jty_log(FND_LOG.LEVEL_EVENT,
4014: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.end_winner',
4015: 'Winner process completed successfully');
4016: END IF;
4017: -- debug message

Line 4018: jty_log(FND_LOG.LEVEL_PROCEDURE,

4014: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.end_winner',
4015: 'Winner process completed successfully');
4016: END IF;
4017: -- debug message
4018: jty_log(FND_LOG.LEVEL_PROCEDURE,
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

Line 4027: jty_log(FND_LOG.LEVEL_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',
4029: x_msg_data);
4030:
4031: WHEN OTHERS THEN

Line 4037: jty_log(FND_LOG.LEVEL_EXCEPTION,

4033: x_msg_data := SQLCODE || ' : ' || SQLERRM;
4034: x_msg_count := 1;
4035: RETCODE := 2;
4036: ERRBUF := x_msg_data;
4037: jty_log(FND_LOG.LEVEL_EXCEPTION,
4038: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.other',
4039: substr(x_msg_data, 1, 4000));
4040:
4041: END get_winners;