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_TRANS_USG_PGM_DETAILS

Line 116: FROM jty_trans_usg_pgm_details tup

112: /* Get the NM_TRANS table name */
113: BEGIN
114: SELECT tup.batch_nm_trans_table_name
115: INTO l_trans_target
116: FROM jty_trans_usg_pgm_details tup
117: WHERE tup.source_id = p_source_id
118: AND tup.trans_type_id = p_trans_id
119: AND tup.program_name = p_program_name;
120: EXCEPTION

Line 122: x_msg_data := 'No row in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||

118: AND tup.trans_type_id = p_trans_id
119: AND tup.program_name = p_program_name;
120: EXCEPTION
121: WHEN NO_DATA_FOUND THEN
122: x_msg_data := 'No row in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||
123: ' program name : ' || p_program_name;
124: RAISE;
125: END;
126:

Line 143: x_msg_data := 'No trans table name in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' ||

139: RAISE;
140: END;
141:
142: IF (l_trans_target IS NULL) THEN
143: x_msg_data := 'No trans table name in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' ||
144: p_trans_id || ' program name : ' || p_program_name;
145: RAISE L_SEED_DATA_NOTFOUND;
146: END IF;
147:

Line 354: FROM jty_trans_usg_pgm_details tup

350: SELECT decode(p_mode, 'TOTAL', tup.batch_trans_table_name
351: , 'INCREMENTAL', tup.batch_nm_trans_table_name
352: , 'DATE EFFECTIVE', tup.batch_dea_trans_table_name)
353: INTO l_trans_target
354: FROM jty_trans_usg_pgm_details tup
355: WHERE tup.source_id = p_source_id
356: AND tup.trans_type_id = p_trans_id
357: AND tup.program_name = p_program_name;
358: EXCEPTION

Line 360: x_msg_data := 'No row in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||

356: AND tup.trans_type_id = p_trans_id
357: AND tup.program_name = p_program_name;
358: EXCEPTION
359: WHEN NO_DATA_FOUND THEN
360: x_msg_data := 'No row in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||
361: ' program name : ' || p_program_name;
362: RAISE;
363: END;
364:

Line 383: x_msg_data := 'No trans table name in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' ||

379: RAISE;
380: END;
381:
382: IF (l_trans_target IS NULL) THEN
383: x_msg_data := 'No trans table name in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' ||
384: p_trans_id || ' program name : ' || p_program_name;
385: RAISE L_SEED_DATA_NOTFOUND;
386: END IF;
387:

Line 637: jty_trans_usg_pgm_details tup

633: ,l_L4_target
634: ,l_L5_target
635: ,l_WT_target
636: FROM
637: jty_trans_usg_pgm_details tup
638: WHERE tup.source_id = p_source_id
639: AND tup.trans_type_id = p_trans_id
640: AND tup.program_name = p_program_name;
641:

Line 1137: x_msg_data := 'No row in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||

1133: WHEN NO_DATA_FOUND THEN
1134: x_return_status := FND_API.G_RET_STS_ERROR ;
1135: RETCODE := 2;
1136: x_msg_count := 1;
1137: x_msg_data := 'No row in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||
1138: ' program name : ' || p_program_name;
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',

Line 1245: jty_trans_usg_pgm_details tup

1241: ,l_L4_target
1242: ,l_L5_target
1243: ,l_WT_target
1244: FROM
1245: jty_trans_usg_pgm_details tup
1246: WHERE tup.source_id = p_source_id
1247: AND tup.trans_type_id = p_trans_id
1248: AND tup.program_name = p_program_name;
1249:

Line 2135: FROM jty_trans_usg_pgm_details tup

2131: SELECT tup.batch_trans_table_name
2132: ,tup.batch_nm_trans_table_name
2133: INTO l_trans_target
2134: ,l_nm_trans_target
2135: FROM jty_trans_usg_pgm_details tup
2136: WHERE tup.source_id = p_source_id
2137: AND tup.trans_type_id = p_trans_id
2138: AND tup.program_name = p_program_name;
2139: EXCEPTION

Line 2141: x_msg_data := 'No row in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||

2137: AND tup.trans_type_id = p_trans_id
2138: AND tup.program_name = p_program_name;
2139: EXCEPTION
2140: WHEN NO_DATA_FOUND THEN
2141: x_msg_data := 'No row in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||
2142: ' program name : ' || p_program_name;
2143: RAISE;
2144: END;
2145:

Line 2660: FROM jty_trans_usg_pgm_details tup

2656: ,l_uwinner_target
2657: ,l_mp_winner_target
2658: ,l_dmc_winner_target
2659: ,l_multi_level_winning_flag
2660: FROM jty_trans_usg_pgm_details tup
2661: WHERE tup.source_id = p_source_id
2662: AND tup.trans_type_id = p_trans_id
2663: AND tup.program_name = p_program_name;
2664: EXCEPTION

Line 2666: x_msg_data := 'No row in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||

2662: AND tup.trans_type_id = p_trans_id
2663: AND tup.program_name = p_program_name;
2664: EXCEPTION
2665: WHEN NO_DATA_FOUND THEN
2666: x_msg_data := 'No row in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||
2667: ' program name : ' || p_program_name;
2668: RAISE;
2669: END;
2670:

Line 3736: FROM jty_trans_usg_pgm_details tup

3732: , 'DATE EFFECTIVE', tup.batch_dea_trans_table_name)
3733: ,batch_match_table_name
3734: INTO l_trans_target
3735: ,l_match_target
3736: FROM jty_trans_usg_pgm_details tup
3737: WHERE tup.source_id = p_source_id
3738: AND tup.trans_type_id = p_trans_id
3739: AND tup.program_name = p_program_name;
3740: EXCEPTION

Line 3742: x_msg_data := 'No row in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||

3738: AND tup.trans_type_id = p_trans_id
3739: AND tup.program_name = p_program_name;
3740: EXCEPTION
3741: WHEN NO_DATA_FOUND THEN
3742: x_msg_data := 'No row in jty_trans_usg_pgm_details corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||
3743: ' program name : ' || p_program_name;
3744: RAISE;
3745: END;
3746: