DBA Data[Home] [Help]

APPS.JTY_TRANS_USG_PGM_SQL_PKG dependencies on JTY_TRANS_USG_PGM_DETAILS

Line 154: FROM jty_trans_usg_pgm_details

150: ,l_real_time_trans_table_name
151: ,l_batch_trans_table_name
152: ,l_batch_nm_trans_table_name
153: ,l_batch_dea_trans_table_name
154: FROM jty_trans_usg_pgm_details
155: WHERE source_id = p_source_id
156: AND trans_type_id = p_trans_type_id
157: AND program_name = p_program_name;
158: EXCEPTION

Line 161: errbuf := 'No row in the table jty_trans_usg_pgm_details corr to the source, transaction type and program name passed';

157: AND program_name = p_program_name;
158: EXCEPTION
159: WHEN NO_DATA_FOUND THEN
160: retcode := 2;
161: errbuf := 'No row in the table jty_trans_usg_pgm_details corr to the source, transaction type and program name passed';
162: RAISE FND_API.G_EXC_ERROR;
163: WHEN OTHERS THEN
164: RAISE;
165: END;