APPS.FTP_PAYMENT_SCHEDULE_PKG dependencies on FEM_ENGINES_PKG

Line 41: FEM_ENGINES_PKG.TECH_MESSAGE(

37: l_source_system_code FTP_PAYMENT_SCHEDULE.SOURCE_SYSTEM_CODE%TYPE;
38: l_rowcount Number :=0;
39: BEGIN
40:
41: FEM_ENGINES_PKG.TECH_MESSAGE(
42: p_severity => C_LOG_LEVEL_2,
43: p_module => l_block ||'Transfer Data',
44: p_msg_text => 'Transfer Begins in Bulk'
45: );

Line 88: FEM_ENGINES_PKG.TECH_MESSAGE(

84: SOURCE_SYSTEM_DISPLAY_CODE = l_source_system_display_code(i) AND
85: INSTRUMENT_TYPE_CODE = l_instrument_type_code(i) AND
86: PAYMENT_DATE = l_payment_date(i);
87:
88: FEM_ENGINES_PKG.TECH_MESSAGE(
89: p_severity => C_LOG_LEVEL_2,
90: p_module => l_block ||'Transfer Data',
91: p_msg_text => 'Error Inseting the Data'
92: );

Line 119: FEM_ENGINES_PKG.TECH_MESSAGE(

115: SOURCE_SYSTEM_DISPLAY_CODE = l_source_system_display_code(i) AND
116: INSTRUMENT_TYPE_CODE = l_instrument_type_code(i) AND
117: PAYMENT_DATE = l_payment_date(i);
118:
119: FEM_ENGINES_PKG.TECH_MESSAGE(
120: p_severity => C_LOG_LEVEL_2,
121: p_module => l_block ||'Transfer Data',
122: p_msg_text => 'Error Inserting : OTHERS '
123: );

Line 128: FEM_ENGINES_PKG.TECH_MESSAGE(

124: END;
125:
126: END LOOP;
127:
128: FEM_ENGINES_PKG.TECH_MESSAGE(
129: p_severity => C_LOG_LEVEL_2,
130: p_module => l_block,
131: p_msg_text => 'Successfully inserted rows: '||l_id_number.COUNT
132: );

Line 138: FEM_ENGINES_PKG.User_Message(

134: COMMIT;
135: DeleteData ;
136: COMMIT;
137: retcode := c_true;
138: FEM_ENGINES_PKG.User_Message(
139: p_app_name => 'FTP',
140: p_msg_name => 'FTP_PAY_SCHEDULE_RUN',
141: p_token1 => 'INSCOUNT',
142: p_value1 => l_rowcount,

Line 148: FEM_ENGINES_PKG.Put_Message(

144: p_value2 => l_id_number.COUNT
145: );
146: EXCEPTION
147: when others then
148: FEM_ENGINES_PKG.Put_Message(
149: p_app_name => 'FTP',
150: p_msg_name => 'FTP_UNEXP_ERR',
151: p_token1 => 'SQLERRM',
152: p_value1 => sqlerrm

Line 165: FEM_ENGINES_PKG.TECH_MESSAGE(

161: BEGIN
162:
163: DELETE FROM FTP_PAYMENT_SCHEDULE_T WHERE STATUS IN ('INSERT','UPDATE');
164:
165: FEM_ENGINES_PKG.TECH_MESSAGE(
166: p_severity => C_LOG_LEVEL_2,
167: p_module => l_block,
168: p_msg_text => 'Successfully deleted rows: '||SQL%ROWCOUNT
169: );

Line 176: FEM_ENGINES_PKG.TECH_MESSAGE(

172: COMMIT;
173:
174: EXCEPTION
175: WHEN OTHERS THEN
176: FEM_ENGINES_PKG.TECH_MESSAGE(
177: p_severity => C_LOG_LEVEL_2,
178: p_module => l_block ||'Delete Data',
179: p_msg_text => 'Error Deleteing Data'
180: );

Line 193: FEM_ENGINES_PKG.TECH_MESSAGE(

189: IS
190: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE := 'FTP_PAYMENT_SCHDULDE.validate_source_system';
191:
192: BEGIN
193: FEM_ENGINES_PKG.TECH_MESSAGE(
194: p_severity => C_LOG_LEVEL_2,
195: p_module => C_MODULE,
196: p_msg_text => 'Begin Validating Source System Code for'
197: );

Line 210: FEM_ENGINES_PKG.Tech_Message(

206: AND personal_flag = 'N';
207: EXCEPTION
208: WHEN no_data_found THEN
209: x_return_status := G_RET_STS_ERROR;
210: FEM_ENGINES_PKG.Tech_Message(
211: p_severity => C_LOG_LEVEL_2,
212: p_module => 'Transfer Data',
213: p_msg_text => 'No Data for Source System Display Code'
214: );

Line 242: FEM_ENGINES_PKG.Tech_Message(

238: LOOKUP_CODE = trim(l_inst_type_code);
239: EXCEPTION
240: WHEN no_data_found THEN
241: x_return_status := G_RET_STS_ERROR;
242: FEM_ENGINES_PKG.Tech_Message(
243: p_severity => C_LOG_LEVEL_2,
244: p_module => 'Validate_Inst_Type_Code',
245: p_msg_text => 'Error In Instrument Type Code'
246: );