58: end if;
59: else
60: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
61: -- ========================= FND LOG ===========================
62: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
63: -- ========================= FND LOG ===========================
64: app_exception.raise_exception;
65: end if;
66: insert into PSA_MF_TRX_DIST_ALL (
181: fetch c1 into tlinfo;
182: if (c1%notfound) then
183: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
184: -- ========================= FND LOG ===========================
185: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
186: -- ========================= FND LOG ===========================
187: app_exception.raise_exception;
188: close c1;
189: return;
249: null;
250: else
251: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
252: -- ========================= FND LOG ===========================
253: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
254: -- ========================= FND LOG ===========================
255: app_exception.raise_exception;
256: end if;
257: return;
302: end if;
303: else
304: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
305: -- ========================= FND LOG ===========================
306: psa_utils.debug_other_msg(g_error_level,l_full_path,FALSE);
307: -- ========================= FND LOG ===========================
308: app_exception.raise_exception;
309: end if;
310: update PSA_MF_TRX_DIST_ALL set