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 JTY_ASSIGN_BULK_PUB

Line 1: Package Body JTY_ASSIGN_BULK_PUB AS

1: Package Body JTY_ASSIGN_BULK_PUB AS
2: /* $Header: jtfyaeab.pls 120.36 2011/04/26 08:40:15 sseshaiy ship $ */
3: ---------------------------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------

Line 6: -- PACKAGE NAME: JTY_ASSIGN_BULK_PUB

2: /* $Header: jtfyaeab.pls 120.36 2011/04/26 08:40:15 sseshaiy ship $ */
3: ---------------------------------------------------------------------
4: -- Start of Comments
5: -- ---------------------------------------------------
6: -- PACKAGE NAME: JTY_ASSIGN_BULK_PUB
7: -- ---------------------------------------------------
8: -- PURPOSE
9: -- This package is a public API for getting winning territories
10: -- or territory resourcesi in bulk mode.

Line 28: G_PKG_NAME CONSTANT VARCHAR2(30):='JTY_ASSIGN_BULK_PUB';

24: -- ***************************************************
25: -- GLOBAL VARIABLES and RECORD TYPE DEFINITIONS
26: -- ***************************************************
27:
28: G_PKG_NAME CONSTANT VARCHAR2(30):='JTY_ASSIGN_BULK_PUB';
29:
30: G_NEW_LINE VARCHAR2(02) := fnd_global.local_chr(10);
31: G_APPL_ID NUMBER := FND_GLOBAL.Prog_Appl_Id;
32: G_LOGIN_ID NUMBER := FND_GLOBAL.Conc_Login_Id;

Line 106: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.begin',

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;
110: l_sysdate := SYSDATE;

Line 107: 'Start of the procedure JTY_ASSIGN_BULK_PUB.insert_nm_trans_data ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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;
110: l_sysdate := SYSDATE;
111:

Line 215: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.final_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 */
219: commit;

Line 227: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.num_rows',

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
231: jty_log(FND_LOG.LEVEL_PROCEDURE,

Line 232: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.end',

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
236: WHEN L_SEED_DATA_NOTFOUND THEN

Line 233: 'End of the procedure JTY_ASSIGN_BULK_PUB.insert_nm_trans_data ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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
236: WHEN L_SEED_DATA_NOTFOUND THEN
237: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 242: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.l_seed_data_notfound',

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

Line 248: x_msg_data := 'JTY_ASSIGN_BULK_PUB.insert_nm_trans_data: SCHEMA NAME NOT FOUND CORRESPONDING TO JTF APPLICATION. ';

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

Line 251: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.l_schema_notfound',

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

Line 260: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.no_data_found',

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

Line 269: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_nm_trans_data.other',

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

Line 331: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.begin',

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;
335: l_sysdate := SYSDATE;

Line 332: 'Start of the procedure JTY_ASSIGN_BULK_PUB.insert_trans_data ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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;
335: l_sysdate := SYSDATE;
336:

Line 396: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.trans_table_name',

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,
400: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.trans_table_name',

Line 400: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.trans_table_name',

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',
404: ' Where clause : ' || substr(p_where, 1, 4000));

Line 403: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.trans_table_name',

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:
407: /* Initialize local variables */

Line 497: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.final_sql',

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 */
501: commit;

Line 510: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.num_rows',

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
514: jty_log(FND_LOG.LEVEL_PROCEDURE,

Line 515: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.end',

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
519: WHEN L_INVALID_WORKERS THEN

Line 516: 'End of the procedure JTY_ASSIGN_BULK_PUB.insert_trans_data ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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
519: WHEN L_INVALID_WORKERS THEN
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 522: x_msg_data := 'JTY_ASSIGN_BULK_PUB.insert_trans_data: Invalid number of workers : Valid range from 1 - 10';

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,
525: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.l_invalid_workers',
526: x_msg_data);

Line 525: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.l_invalid_workers',

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

Line 534: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.l_seed_data_notfound',

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

Line 540: x_msg_data := 'JTY_ASSIGN_BULK_PUB.insert_trans_data: SCHEMA NAME NOT FOUND CORRESPONDING TO JTF APPLICATION. ';

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

Line 543: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.l_schema_notfound',

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

Line 552: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.no_data_found',

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

Line 561: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.insert_trans_data.other',

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

Line 606: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.begin',

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 */
610: SELECT

Line 607: 'Start of the procedure JTY_ASSIGN_BULK_PUB.clear_trans_data ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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 */
610: SELECT
611: decode(p_mode, 'TOTAL', tup.batch_trans_table_name

Line 644: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.temp_table_names',

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 ||
648: ' L4 table name : ' || l_L4_target || ' L5 table name : ' || l_L5_target ||

Line 656: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',

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 */
660: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 668: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',

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

Line 683: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.trans_clear',

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

Line 696: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',

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 */
700: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 709: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',

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

Line 724: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.match_clear',

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

Line 737: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',

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 */
741: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 750: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',

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

Line 765: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.umatch_clear',

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

Line 778: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',

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 */
782: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 791: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',

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

Line 806: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.winner_clear',

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

Line 819: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',

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 */
823: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 832: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',

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

Line 847: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.uwinner_clear',

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

Line 860: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l1_clear',

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 */
864: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 873: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l1_clear',

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

Line 888: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l1_clear',

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

Line 901: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',

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 */
905: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 914: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',

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

Line 929: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l2_clear',

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

Line 942: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',

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 */
946: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 955: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',

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

Line 970: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l3_clear',

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

Line 983: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',

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 */
987: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 996: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',

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

Line 1011: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l4_clear',

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

Line 1024: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',

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 */
1028: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 1037: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',

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

Line 1052: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.l5_clear',

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

Line 1065: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',

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 */
1069: JTY_TAE_INDEX_CREATION_PVT.DROP_TABLE_INDEXES(

Line 1078: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',

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

Line 1093: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.wt_clear',

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

Line 1129: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.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
1133: WHEN NO_DATA_FOUND THEN

Line 1130: 'End of the procedure JTY_ASSIGN_BULK_PUB.clear_trans_data ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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
1133: WHEN NO_DATA_FOUND THEN
1134: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1141: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Clear_Trans_Data.no_data_found',

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

Line 1149: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Clear_Trans_Data.g_exc_error',

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

Line 1158: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.clear_trans_data.other',

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

Line 1210: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.begin',

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;
1214: l_sysdate := SYSDATE;

Line 1211: 'Start of the procedure JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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;
1214: l_sysdate := SYSDATE;
1215:

Line 1252: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.temp_table_names',

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 ||
1256: ' L4 table name : ' || l_L4_target || ' L5 table name : ' || l_L5_target ||

Line 1310: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.num_of_terr',

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
1314: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP: There are NO Active Territories with Active ' ||

Line 1314: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP: There are NO Active Territories with Active ' ||

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
1314: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP: There are NO Active Territories with Active ' ||
1315: 'Resources existing for this Usage/Transaction combination, so no assignments ' ||
1316: 'can take place.';
1317:
1318: RAISE NO_TAE_DATA_FOUND;

Line 1327: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.num_of_trans',

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
1331: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP : There are NO valid Transaction Objects to assign.';

Line 1331: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP : There are NO valid Transaction Objects to assign.';

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
1331: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP : There are NO valid Transaction Objects to assign.';
1332: RAISE NO_TAE_DATA_FOUND;
1333: END IF;
1334:
1335: -- debug message

Line 1337: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_trans',

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(
1341: p_table_name => l_trans_target

Line 1346: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP: Call to ' ||

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

Line 1353: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.decompose_terr_defns',

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
1357: (p_Api_Version_Number => 1.0,

Line 1374: x_msg_data := 'JTY_ASSIGN_BULK_PUB.GET_WINNERS_PARALLEL_SETUP: Call to ' ||

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

Line 1381: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_matches',

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 */
1385: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

Line 1401: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_winners',

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 */
1405: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

Line 1421: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l1',

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 */
1425: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

Line 1441: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l2',

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 */
1445: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

Line 1462: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l3',

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 */
1466: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

Line 1482: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l4',

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 */
1486: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

Line 1502: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_l5',

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 */
1506: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

Line 1522: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.analyze_wt',

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 */
1526: JTY_TAE_INDEX_CREATION_PVT.CREATE_INDEX

Line 1549: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.end',

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
1553: WHEN NO_TAE_DATA_FOUND THEN

Line 1550: 'End of the procedure JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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
1553: WHEN NO_TAE_DATA_FOUND THEN
1554: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1559: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.no_tae_data_found',

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

Line 1568: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.g_exc_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
1572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1577: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.g_exc_unexpected_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
1581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1587: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup.other',

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

Line 1616: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.start',

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

Line 1617: 'Start of the procedure JTY_ASSIGN_BULK_PUB.Process_Level_Winners ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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;
1620:
1621: IF (p_date_effective) THEN

Line 1899: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.num_rows',

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
1903: jty_log(FND_LOG.LEVEL_PROCEDURE,

Line 1904: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.end',

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

Line 1905: 'End of the procedure JTY_ASSIGN_BULK_PUB.Process_Level_Winners ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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
1908:
1909: WHEN FND_API.G_EXC_ERROR THEN

Line 1912: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.other',

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

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 1919: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Level_Winners.other',

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

Line 1947: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners.start',

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

Line 1948: 'Start of the procedure JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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;
1951:
1952: IF (p_date_effective) THEN

Line 2040: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners.num_rows',

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
2044: jty_log(FND_LOG.LEVEL_PROCEDURE,

Line 2045: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners.end',

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

Line 2046: 'End of the procedure JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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
2049: WHEN OTHERS THEN
2050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2052: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.Process_Final_Level_Winners.other',

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

Line 2115: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.start',

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

Line 2116: 'Start of the procedure JTY_ASSIGN_BULK_PUB.process_nmc_match ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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;
2119:
2120: /* Get the schema name corresponding to JTF application */

Line 2212: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.final_sql',

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 */
2216: EXECUTE IMMEDIATE l_final_sql;

Line 2257: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.match',

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:
2261: -- debug message

Line 2263: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.end',

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
2267: WHEN L_SCHEMA_NOTFOUND THEN

Line 2264: 'End of the procedure JTY_ASSIGN_BULK_PUB.process_nmc_match ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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
2267: WHEN L_SCHEMA_NOTFOUND THEN
2268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2274: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.l_schema_notfound',

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

Line 2283: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.no_data_found',

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

Line 2293: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_nmc_match.other',

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

Line 2337: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.start',

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. */
2341: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 2338: 'Start of the procedure JTY_ASSIGN_BULK_PUB.collect_trans_data ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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. */
2341: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2342: p_api_version_number,

Line 2361: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.param_value',

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

Line 2381: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.clear_trans_data has failed';

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',
2384: x_msg_data);
2385:

Line 2383: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.clear_trans_data',

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

Line 2391: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end_clear_trans_data',

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:
2395: IF p_oic_mode = 'NOOIC' or p_oic_mode = 'INSERT' THEN

Line 2416: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.insert_trans_data has failed';

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',
2419: x_msg_data);
2420:

Line 2418: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.insert_trans_data',

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

Line 2426: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end_insert_trans_data',

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

Line 2448: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.process_nmc_match has failed';

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',
2451: x_msg_data);
2452:

Line 2450: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.process_nmc_match',

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

Line 2458: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end_process_nmc_match',

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 */
2462: insert_nm_trans_data (

Line 2475: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.insert_nm_trans_data has failed';

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',
2478: x_msg_data);
2479:

Line 2477: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.insert_nm_trans_data',

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

Line 2485: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end_insert_nm_trans_data',

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') */
2489:

Line 2509: x_msg_data := 'API JTY_ASSIGN_BULK_PUB.get_winners_parallel_setup has failed';

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',
2512: x_msg_data);
2513:

Line 2511: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.get_winners_parallel_setup',

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

Line 2523: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.end',

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

Line 2524: 'End of the procedure JTY_ASSIGN_BULK_PUB.collect_trans_data ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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
2527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2533: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.g_exc_unexpected_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
2537: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 2542: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.no_data_found',

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

Line 2550: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.g_exc_error',

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

Line 2560: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.collect_trans_data.other',

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

Line 2621: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.start',

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;
2625: lp_sysdate := SYSDATE;

Line 2622: 'Start of the procedure JTY_ASSIGN_BULK_PUB.process_winner ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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;
2625: lp_sysdate := SYSDATE;
2626:

Line 2802: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.winner_num_row',

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
2806: NULL;

Line 2811: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.winning_process',

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
2815: NULL;

Line 2832: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_max_terr',

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
2836: x_msg_data := 'No row in ' || l_match_target || ' for worker_id = ' || p_worker_id;

Line 2852: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_target',

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

Line 2858: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_target',

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 */
2862: /* add the columns trans_object_id, trans_details_object_id, txn_date */

Line 2882: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_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 */
2886: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_table, l_dyn_str, l_mp_winner_target);

Line 2889: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_target',

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 */
2893: /* combination of matching territories in a single row */

Line 2900: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target',

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

Line 2906: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target',

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 */
2910: l_dyn_str :=

Line 2925: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target',

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 */
2929: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_table, l_dyn_str, l_dmc_winner_target);

Line 2932: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target',

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 */
2936: l_dyn_str :=

Line 3011: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_umatch',

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

Line 3017: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_umatch',

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 */
3021: IF (l_max_terr > 32) THEN

Line 3035: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_dmc_winner_target_index',

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 */
3039: ad_ddl.do_ddl(l_fnd_schema, 'JTF', ad_ddl.create_index, l_dyn_str, l_dmc_winner_target || 'N');

Line 3055: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_update',

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

Line 3061: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winners.l_mp_winner_update',

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 */
3065: Process_Level_Winners (

Line 3080: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l1',

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

Line 3097: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l1_analyze',

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

Line 3120: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l2',

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

Line 3137: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l2_analyze',

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

Line 3160: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l3',

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

Line 3177: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l3_analyze',

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

Line 3200: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l4',

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

Line 3217: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l4_analyze',

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

Line 3240: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l5',

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

Line 3257: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.l5_analyze',

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

Line 3278: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.wt',

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

Line 3295: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.wt_analyze',

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

Line 3303: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.begin_populate_winners',

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 :=
3307: ' INSERT INTO ' || l_uwinner_target || ' i ' ||

Line 3468: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner_num_row',

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

Line 3585: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner_num_row',

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

Line 3609: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner_analyze',

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

Line 3622: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.end',

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
3626: WHEN L_SCHEMA_NOTFOUND THEN

Line 3623: 'End of the procedure JTY_ASSIGN_BULK_PUB.process_winner ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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
3626: WHEN L_SCHEMA_NOTFOUND THEN
3627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3633: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.l_schema_notfound',

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

Line 3642: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.no_data_found',

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

Line 3647: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.l_no_match_terr',

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

Line 3656: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.g_exc_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
3660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3666: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_winner.other',

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

Line 3723: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.start',

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;
3727: l_sysdate := SYSDATE;

Line 3724: 'Start of the procedure JTY_ASSIGN_BULK_PUB.process_match ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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;
3727: l_sysdate := SYSDATE;
3728:

Line 3783: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.dea_match',

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;
3787: ELSIF p_terr_id IS NOT NULL THEN

Line 3807: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.dea_match',

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

Line 3834: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.match',

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

Line 3850: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.analyze_match',

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

Line 3862: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.end',

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
3866: WHEN NO_DATA_FOUND THEN

Line 3863: 'End of the procedure JTY_ASSIGN_BULK_PUB.process_match ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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
3866: WHEN NO_DATA_FOUND THEN
3867: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 3872: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.no_data_found',

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

Line 3877: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.g_exc_error',

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

Line 3887: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.process_match.other',

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

Line 3927: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.start',

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. */
3931: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 3928: 'Start of the procedure JTY_ASSIGN_BULK_PUB.get_winners ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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. */
3931: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3932: p_api_version_number,

Line 3948: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.param_value',

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:
3952: IF p_oic_mode = 'NOOIC' OR p_oic_mode = 'MATCH/POPULATE' OR p_oic_mode = 'MATCH/POST'

Line 3973: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.match',

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

Line 3981: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.end_match',

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:
3985: IF p_oic_mode = 'NOOIC' OR p_oic_mode = 'WINNER/POPULATE' OR p_oic_mode = 'WINNER/POST'

Line 4005: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.winner',

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

Line 4014: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.end_winner',

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
4018: jty_log(FND_LOG.LEVEL_PROCEDURE,

Line 4019: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.end',

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

Line 4020: 'End of the procedure JTY_ASSIGN_BULK_PUB.get_winners ' || to_char(sysdate,'dd-mm-rrrr HH24:MI:SS'));

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
4023: WHEN FND_API.G_EXC_ERROR THEN
4024: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 4028: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.g_exc_error',

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

Line 4038: 'jtf.plsql.JTY_ASSIGN_BULK_PUB.get_winners.other',

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

Line 4043: END JTY_ASSIGN_BULK_PUB;

4039: substr(x_msg_data, 1, 4000));
4040:
4041: END get_winners;
4042:
4043: END JTY_ASSIGN_BULK_PUB;