APPS.FTP_IRC_ADI_MIGRATE dependencies on FEM_ENGINES_PKG

Line 46: FEM_ENGINES_PKG.TECH_MESSAGE(

42:
43: l_block CONSTANT VARCHAR2(80) := 'ftp.plsql.ftp_irc_adi_migrate.migrateparameters';
44: BEGIN
45:
46: FEM_ENGINES_PKG.TECH_MESSAGE(
47: p_severity => c_log_level_2,
48: p_module => l_block||'.interest_rate_code',
49: p_msg_text => p_int_rate_code
50: );

Line 100: FEM_ENGINES_PKG.Put_Message(

96: update FTP_IRC_ADI_PARAM_T set STATUS ='FTP_PARAM_MIGRATE_ERR' where EFFECTIVE_DATE = l_eff_date_tbl(i)
97: AND INTEREST_RATE_CODE = p_int_rate_code;
98:
99: --put message on the message stack for calling program to handle
100: FEM_ENGINES_PKG.Put_Message(
101: p_app_name => 'FTP',
102: p_msg_name => 'FTP_PARAM_MIGRATE_ERR',
103: p_token1 => 'EFF_DATE',
104: p_value1 => l_eff_date_tbl(i)

Line 110: FEM_ENGINES_PKG.TECH_MESSAGE(

106: END;
107: END LOOP;
108:
109:
110: FEM_ENGINES_PKG.TECH_MESSAGE(
111: p_severity => c_log_level_2,
112: p_module => l_block,
113: p_msg_text => 'Successfully inserted/updated rows: '||l_mean_rev_tbl.COUNT
114: );

Line 132: FEM_ENGINES_PKG.Put_Message(

128: EXCEPTION
129: when others then
130:
131: --put message on the message stack for calling program to handle
132: FEM_ENGINES_PKG.Put_Message(
133: p_app_name => 'FTP',
134: p_msg_name => 'FTP_UNEXP_ERR',
135: p_token1 => 'SQLERRM',
136: p_value1 => sqlerrm

Line 155: FEM_ENGINES_PKG.TECH_MESSAGE(

151: IS
152: l_block CONSTANT VARCHAR2(80) := 'ftp.plsql.ftp_irc_adi_migrate.deleteparameters';
153: BEGIN
154:
155: FEM_ENGINES_PKG.TECH_MESSAGE(
156: p_severity => c_log_level_2,
157: p_module => l_block||'.interest_rate_code',
158: p_msg_text => p_int_rate_code
159: );

Line 164: FEM_ENGINES_PKG.TECH_MESSAGE(

160:
161: DELETE FROM FTP_IRC_ADI_PARAM_T WHERE
162: INTEREST_RATE_CODE = p_int_rate_code and STATUS IN ('INSERT','UPDATE');
163:
164: FEM_ENGINES_PKG.TECH_MESSAGE(
165: p_severity => c_log_level_2,
166: p_module => l_block,
167: p_msg_text => 'Successfully deleted rows: '||SQL%ROWCOUNT
168: );

Line 177: FEM_ENGINES_PKG.Put_Message(

173: EXCEPTION
174: when others then
175:
176: --put message on the message stack for calling program to handle
177: FEM_ENGINES_PKG.Put_Message(
178: p_app_name => 'FTP',
179: p_msg_name => 'FTP_UNEXP_ERR',
180: p_token1 => 'SQLERRM',
181: p_value1 => sqlerrm

Line 232: FEM_ENGINES_PKG.TECH_MESSAGE(

228:
229: l_block CONSTANT VARCHAR2(80) := 'ftp.plsql.ftp_irc_adi_migrate.migratehistrates';
230:
231: BEGIN
232: FEM_ENGINES_PKG.TECH_MESSAGE(
233: p_severity => c_log_level_2,
234: p_module => l_block||'.interest_rate_code',
235: p_msg_text => p_int_rate_code
236: );

Line 346: FEM_ENGINES_PKG.Put_Message(

342: EXCEPTION
343: when others then
344:
345: --put message on the message stack for calling program to handle
346: FEM_ENGINES_PKG.Put_Message(
347: p_app_name => 'FTP',
348: p_msg_name => 'FTP_HIST_MIGRATE_ERR',
349: p_token1 => 'EFF_DATE',
350: p_value1 => l_eff_date_tbl(i)

Line 356: FEM_ENGINES_PKG.TECH_MESSAGE(

352: END;
353: END LOOP;
354:
355:
356: FEM_ENGINES_PKG.TECH_MESSAGE(
357: p_severity => c_log_level_2,
358: p_module => l_block,
359: p_msg_text => 'Successfully inserted/updated rows: '||l_int_terms_tbl.COUNT
360: );

Line 377: FEM_ENGINES_PKG.Put_Message(

373: EXCEPTION
374: when others then
375:
376: --put message on the message stack for calling program to handle
377: FEM_ENGINES_PKG.Put_Message(
378: p_app_name => 'FTP',
379: p_msg_name => 'FTP_UNEXP_ERR',
380: p_token1 => 'SQLERRM',
381: p_value1 => sqlerrm

Line 401: FEM_ENGINES_PKG.TECH_MESSAGE(

397: IS
398: l_block CONSTANT VARCHAR2(80) := 'ftp.plsql.ftp_irc_adi_migrate.deletehistrates';
399: BEGIN
400:
401: FEM_ENGINES_PKG.TECH_MESSAGE(
402: p_severity => c_log_level_2,
403: p_module => l_block||'.interest_rate_code',
404: p_msg_text => p_int_rate_code
405: );

Line 410: FEM_ENGINES_PKG.TECH_MESSAGE(

406:
407: DELETE FROM FTP_IRC_ADI_RATE_T WHERE INTEREST_RATE_CODE = p_int_rate_code and
408: STATUS IN ('INSERT','UPDATE');
409:
410: FEM_ENGINES_PKG.TECH_MESSAGE(
411: p_severity => c_log_level_2,
412: p_module => l_block,
413: p_msg_text => 'Successfully deleted rows: '||SQL%ROWCOUNT
414: );

Line 423: FEM_ENGINES_PKG.Put_Message(

419: EXCEPTION
420: when others then
421:
422: --put message on the message stack for calling program to handle
423: FEM_ENGINES_PKG.Put_Message(
424: p_app_name => 'FTP',
425: p_msg_name => 'FTP_UNEXP_ERR',
426: p_token1 => 'SQLERRM',
427: p_value1 => sqlerrm