APPS.FII_CCC_SEC_UPL_PKG dependencies on FII_UTIL

Line 19: fii_util.put_line(text);

15: PROCEDURE dbg(text IN VARCHAR2)
16: IS
17: BEGIN
18: IF (g_debug_flag = 'Y') THEN
19: fii_util.put_line(text);
20: END IF;
21: END dbg;
22:
23:

Line 186: fii_util.put_line(fnd_message.get_string('FII', 'FII_CCC_SEC_DIFF_DATES'));

182: EXIT WHEN v1_csr%NOTFOUND;
183: l_violations_found := TRUE;
184:
185: IF (NOT l_diff_date_header) then
186: fii_util.put_line(fnd_message.get_string('FII', 'FII_CCC_SEC_DIFF_DATES'));
187: fii_util.put_line(' Grant To (GRANTEE_KEY)' || g_indenting ||
188: ' Role (MENU_NAME)' || g_indenting ||
189: 'Start Date' || g_indenting ||
190: ' End Date' || g_indenting);

Line 187: fii_util.put_line(' Grant To (GRANTEE_KEY)' || g_indenting ||

183: l_violations_found := TRUE;
184:
185: IF (NOT l_diff_date_header) then
186: fii_util.put_line(fnd_message.get_string('FII', 'FII_CCC_SEC_DIFF_DATES'));
187: fii_util.put_line(' Grant To (GRANTEE_KEY)' || g_indenting ||
188: ' Role (MENU_NAME)' || g_indenting ||
189: 'Start Date' || g_indenting ||
190: ' End Date' || g_indenting);
191: fii_util.put_line( g_long_line || g_indenting || g_long_line || g_indenting ||

Line 191: fii_util.put_line( g_long_line || g_indenting || g_long_line || g_indenting ||

187: fii_util.put_line(' Grant To (GRANTEE_KEY)' || g_indenting ||
188: ' Role (MENU_NAME)' || g_indenting ||
189: 'Start Date' || g_indenting ||
190: ' End Date' || g_indenting);
191: fii_util.put_line( g_long_line || g_indenting || g_long_line || g_indenting ||
192: g_short_line|| g_indenting || g_short_line);
193: l_diff_date_header := TRUE;
194:
195: END IF;

Line 222: fii_util.put_line(substr(g_space, 1, l_msg_length - length(l_msg1)) || substr(l_msg1,1,42) ||

218:
219: -- print out the records that violate the validation 1 in the log file
220: l_msg1 := substr(l_grant_to_name,1,30) || ' (' || l_grantee_key || ')';
221: l_msg2 := substr(l_role_user_name,1,30) || ' (' || l_menu_name || ')';
222: fii_util.put_line(substr(g_space, 1, l_msg_length - length(l_msg1)) || substr(l_msg1,1,42) ||
223: g_indenting ||
224: substr(g_space, 1, l_msg_length - length(l_msg2)) || substr(l_msg2,1,42) ||
225: g_indenting ||
226: substr(g_space, 1, l_date_length - length(to_char(get_sd_ed_rec.start_date))) ||

Line 566: fii_util.truncate_table('FII_CCC_SEC_INTERFACE', 'FII', l_trunc_retcode);

562: --
563: -- purge fii_ccc_sec_interface table
564: --
565: dbg('purge_interface: truncate fii_ccc_sec_interface table.');
566: fii_util.truncate_table('FII_CCC_SEC_INTERFACE', 'FII', l_trunc_retcode);
567:
568:
569: IF l_trunc_retcode = -1 THEN
570: dbg('purge_interface: purge interface table failed. Exit.');