APPS.HXC_ARCHIVE_RESTORE_UTILS dependencies on FND_FILE

Line 20: --fnd_file.put_line(fnd_file.LOG,'Error count exceeded '||g_error_count);

16: g_error_count := nvl(fnd_profile.value('HXC_VALIDATE_DATA_SET_MAX_ERRORS'),25);
17: END IF;
18:
19: IF p_error_count >= g_error_count THEN
20: --fnd_file.put_line(fnd_file.LOG,'Error count exceeded '||g_error_count);
21: RETURN TRUE;
22: ELSE
23: RETURN FALSE;
24: END IF;

Line 63: fnd_file.put_line(fnd_file.LOG, 'The following timecards and templates share the same time building block id');

59: FETCH c_timecard_template INTO l_dummy;
60: IF c_timecard_template%found
61: THEN
62:
63: fnd_file.put_line(fnd_file.LOG, 'The following timecards and templates share the same time building block id');
64: l_data_corruption := TRUE;
65: CLOSE c_timecard_template;
66:
67: FOR l_rec IN c_timecard_template(p_data_set_id) LOOP

Line 68: fnd_file.put_line(fnd_file.LOG,'Common id is:' ||l_rec.time_building_block_id);

64: l_data_corruption := TRUE;
65: CLOSE c_timecard_template;
66:
67: FOR l_rec IN c_timecard_template(p_data_set_id) LOOP
68: fnd_file.put_line(fnd_file.LOG,'Common id is:' ||l_rec.time_building_block_id);
69: END LOOP;
70:
71: ELSE
72: CLOSE c_timecard_template;

Line 75: fnd_file.put_line(fnd_file.LOG, 'Before returning for check_data_corruption function');

71: ELSE
72: CLOSE c_timecard_template;
73: END IF;
74:
75: fnd_file.put_line(fnd_file.LOG, 'Before returning for check_data_corruption function');
76:
77: RETURN l_data_corruption;
78:
79: END check_data_corruption;

Line 143: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');

139: select /*+ index_ffs (t HXC_TIMECARD_SUMMARY_PK ) parallel (t,4)*/ count(timecard_id)
140: into p_ts_count from hxc_timecard_summary t;
141:
142: -- Create the report
143: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
144: fnd_file.put_line(fnd_file.LOG,' Core Table Count Snapshot');
145: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
146: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks '||p_tbb_count);
147: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages '||p_tau_count);

Line 144: fnd_file.put_line(fnd_file.LOG,' Core Table Count Snapshot');

140: into p_ts_count from hxc_timecard_summary t;
141:
142: -- Create the report
143: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
144: fnd_file.put_line(fnd_file.LOG,' Core Table Count Snapshot');
145: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
146: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks '||p_tbb_count);
147: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages '||p_tau_count);
148: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes '||p_ta_count);

Line 145: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');

141:
142: -- Create the report
143: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
144: fnd_file.put_line(fnd_file.LOG,' Core Table Count Snapshot');
145: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
146: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks '||p_tbb_count);
147: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages '||p_tau_count);
148: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes '||p_ta_count);
149: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details '||p_td_count);

Line 146: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks '||p_tbb_count);

142: -- Create the report
143: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
144: fnd_file.put_line(fnd_file.LOG,' Core Table Count Snapshot');
145: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
146: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks '||p_tbb_count);
147: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages '||p_tau_count);
148: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes '||p_ta_count);
149: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details '||p_td_count);
150: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions '||p_trans_count);

Line 147: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages '||p_tau_count);

143: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
144: fnd_file.put_line(fnd_file.LOG,' Core Table Count Snapshot');
145: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
146: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks '||p_tbb_count);
147: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages '||p_tau_count);
148: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes '||p_ta_count);
149: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details '||p_td_count);
150: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions '||p_trans_count);
151: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links '||p_tal_count);

Line 148: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes '||p_ta_count);

144: fnd_file.put_line(fnd_file.LOG,' Core Table Count Snapshot');
145: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
146: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks '||p_tbb_count);
147: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages '||p_tau_count);
148: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes '||p_ta_count);
149: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details '||p_td_count);
150: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions '||p_trans_count);
151: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links '||p_tal_count);
152: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary '||p_aps_count);

Line 149: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details '||p_td_count);

145: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
146: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks '||p_tbb_count);
147: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages '||p_tau_count);
148: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes '||p_ta_count);
149: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details '||p_td_count);
150: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions '||p_trans_count);
151: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links '||p_tal_count);
152: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary '||p_aps_count);
153: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links '||p_adl_count);

Line 150: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions '||p_trans_count);

146: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks '||p_tbb_count);
147: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages '||p_tau_count);
148: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes '||p_ta_count);
149: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details '||p_td_count);
150: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions '||p_trans_count);
151: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links '||p_tal_count);
152: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary '||p_aps_count);
153: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links '||p_adl_count);
154: fnd_file.put_line(fnd_file.LOG,'-> hxc_latest_details '||p_ld_count);

Line 151: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links '||p_tal_count);

147: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages '||p_tau_count);
148: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes '||p_ta_count);
149: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details '||p_td_count);
150: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions '||p_trans_count);
151: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links '||p_tal_count);
152: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary '||p_aps_count);
153: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links '||p_adl_count);
154: fnd_file.put_line(fnd_file.LOG,'-> hxc_latest_details '||p_ld_count);
155: fnd_file.put_line(fnd_file.LOG,'-> hxc_timecard_summary '||p_ts_count);

Line 152: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary '||p_aps_count);

148: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes '||p_ta_count);
149: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details '||p_td_count);
150: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions '||p_trans_count);
151: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links '||p_tal_count);
152: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary '||p_aps_count);
153: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links '||p_adl_count);
154: fnd_file.put_line(fnd_file.LOG,'-> hxc_latest_details '||p_ld_count);
155: fnd_file.put_line(fnd_file.LOG,'-> hxc_timecard_summary '||p_ts_count);
156:

Line 153: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links '||p_adl_count);

149: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details '||p_td_count);
150: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions '||p_trans_count);
151: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links '||p_tal_count);
152: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary '||p_aps_count);
153: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links '||p_adl_count);
154: fnd_file.put_line(fnd_file.LOG,'-> hxc_latest_details '||p_ld_count);
155: fnd_file.put_line(fnd_file.LOG,'-> hxc_timecard_summary '||p_ts_count);
156:
157:

Line 154: fnd_file.put_line(fnd_file.LOG,'-> hxc_latest_details '||p_ld_count);

150: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions '||p_trans_count);
151: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links '||p_tal_count);
152: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary '||p_aps_count);
153: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links '||p_adl_count);
154: fnd_file.put_line(fnd_file.LOG,'-> hxc_latest_details '||p_ld_count);
155: fnd_file.put_line(fnd_file.LOG,'-> hxc_timecard_summary '||p_ts_count);
156:
157:
158: END core_table_count_snapshot;

Line 155: fnd_file.put_line(fnd_file.LOG,'-> hxc_timecard_summary '||p_ts_count);

151: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links '||p_tal_count);
152: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary '||p_aps_count);
153: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links '||p_adl_count);
154: fnd_file.put_line(fnd_file.LOG,'-> hxc_latest_details '||p_ld_count);
155: fnd_file.put_line(fnd_file.LOG,'-> hxc_timecard_summary '||p_ts_count);
156:
157:
158: END core_table_count_snapshot;
159:

Line 212: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');

208: into p_aps_ar_count from hxc_app_period_summary_ar t;
209:
210:
211: -- Create the report
212: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
213: fnd_file.put_line(fnd_file.LOG,' Archive Table Count Snapshot');
214: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
215: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks_ar '||p_tbb_ar_count);
216: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages_ar '||p_tau_ar_count);

Line 213: fnd_file.put_line(fnd_file.LOG,' Archive Table Count Snapshot');

209:
210:
211: -- Create the report
212: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
213: fnd_file.put_line(fnd_file.LOG,' Archive Table Count Snapshot');
214: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
215: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks_ar '||p_tbb_ar_count);
216: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages_ar '||p_tau_ar_count);
217: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes_ar '||p_ta_ar_count);

Line 214: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');

210:
211: -- Create the report
212: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
213: fnd_file.put_line(fnd_file.LOG,' Archive Table Count Snapshot');
214: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
215: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks_ar '||p_tbb_ar_count);
216: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages_ar '||p_tau_ar_count);
217: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes_ar '||p_ta_ar_count);
218: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details_ar '||p_td_ar_count);

Line 215: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks_ar '||p_tbb_ar_count);

211: -- Create the report
212: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
213: fnd_file.put_line(fnd_file.LOG,' Archive Table Count Snapshot');
214: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
215: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks_ar '||p_tbb_ar_count);
216: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages_ar '||p_tau_ar_count);
217: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes_ar '||p_ta_ar_count);
218: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details_ar '||p_td_ar_count);
219: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions_ar '||p_trans_ar_count);

Line 216: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages_ar '||p_tau_ar_count);

212: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
213: fnd_file.put_line(fnd_file.LOG,' Archive Table Count Snapshot');
214: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
215: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks_ar '||p_tbb_ar_count);
216: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages_ar '||p_tau_ar_count);
217: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes_ar '||p_ta_ar_count);
218: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details_ar '||p_td_ar_count);
219: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions_ar '||p_trans_ar_count);
220: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links_ar '||p_tal_ar_count);

Line 217: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes_ar '||p_ta_ar_count);

213: fnd_file.put_line(fnd_file.LOG,' Archive Table Count Snapshot');
214: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
215: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks_ar '||p_tbb_ar_count);
216: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages_ar '||p_tau_ar_count);
217: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes_ar '||p_ta_ar_count);
218: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details_ar '||p_td_ar_count);
219: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions_ar '||p_trans_ar_count);
220: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links_ar '||p_tal_ar_count);
221: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links_ar '||p_adl_ar_count);

Line 218: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details_ar '||p_td_ar_count);

214: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
215: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks_ar '||p_tbb_ar_count);
216: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages_ar '||p_tau_ar_count);
217: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes_ar '||p_ta_ar_count);
218: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details_ar '||p_td_ar_count);
219: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions_ar '||p_trans_ar_count);
220: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links_ar '||p_tal_ar_count);
221: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links_ar '||p_adl_ar_count);
222: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary_ar '||p_aps_ar_count);

Line 219: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions_ar '||p_trans_ar_count);

215: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks_ar '||p_tbb_ar_count);
216: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages_ar '||p_tau_ar_count);
217: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes_ar '||p_ta_ar_count);
218: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details_ar '||p_td_ar_count);
219: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions_ar '||p_trans_ar_count);
220: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links_ar '||p_tal_ar_count);
221: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links_ar '||p_adl_ar_count);
222: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary_ar '||p_aps_ar_count);
223:

Line 220: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links_ar '||p_tal_ar_count);

216: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages_ar '||p_tau_ar_count);
217: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes_ar '||p_ta_ar_count);
218: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details_ar '||p_td_ar_count);
219: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions_ar '||p_trans_ar_count);
220: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links_ar '||p_tal_ar_count);
221: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links_ar '||p_adl_ar_count);
222: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary_ar '||p_aps_ar_count);
223:
224:

Line 221: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links_ar '||p_adl_ar_count);

217: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes_ar '||p_ta_ar_count);
218: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details_ar '||p_td_ar_count);
219: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions_ar '||p_trans_ar_count);
220: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links_ar '||p_tal_ar_count);
221: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links_ar '||p_adl_ar_count);
222: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary_ar '||p_aps_ar_count);
223:
224:
225: END bkup_table_count_snapshot;

Line 222: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary_ar '||p_aps_ar_count);

218: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details_ar '||p_td_ar_count);
219: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions_ar '||p_trans_ar_count);
220: fnd_file.put_line(fnd_file.LOG,'-> hxc_tc_ap_links_ar '||p_tal_ar_count);
221: fnd_file.put_line(fnd_file.LOG,'-> hxc_ap_detail_links_ar '||p_adl_ar_count);
222: fnd_file.put_line(fnd_file.LOG,'-> hxc_app_period_summary_ar '||p_aps_ar_count);
223:
224:
225: END bkup_table_count_snapshot;
226:

Line 257: fnd_file.put_line(fnd_file.LOG,' ================================= ');

253:
254:
255: BEGIN
256:
257: fnd_file.put_line(fnd_file.LOG,' ================================= ');
258: fnd_file.put_line(fnd_file.LOG,' ====== Chunk count ============== ');
259: fnd_file.put_line(fnd_file.LOG,' ================================= ');
260: fnd_file.put_line(fnd_file.LOG,' --- > p_tc_ar_count :'||p_tc_ar_count);
261: fnd_file.put_line(fnd_file.LOG,' --- > p_day_ar_count :'||p_day_ar_count );

Line 258: fnd_file.put_line(fnd_file.LOG,' ====== Chunk count ============== ');

254:
255: BEGIN
256:
257: fnd_file.put_line(fnd_file.LOG,' ================================= ');
258: fnd_file.put_line(fnd_file.LOG,' ====== Chunk count ============== ');
259: fnd_file.put_line(fnd_file.LOG,' ================================= ');
260: fnd_file.put_line(fnd_file.LOG,' --- > p_tc_ar_count :'||p_tc_ar_count);
261: fnd_file.put_line(fnd_file.LOG,' --- > p_day_ar_count :'||p_day_ar_count );
262: fnd_file.put_line(fnd_file.LOG,' --- > p_detail_ar_count :'||p_detail_ar_count);

Line 259: fnd_file.put_line(fnd_file.LOG,' ================================= ');

255: BEGIN
256:
257: fnd_file.put_line(fnd_file.LOG,' ================================= ');
258: fnd_file.put_line(fnd_file.LOG,' ====== Chunk count ============== ');
259: fnd_file.put_line(fnd_file.LOG,' ================================= ');
260: fnd_file.put_line(fnd_file.LOG,' --- > p_tc_ar_count :'||p_tc_ar_count);
261: fnd_file.put_line(fnd_file.LOG,' --- > p_day_ar_count :'||p_day_ar_count );
262: fnd_file.put_line(fnd_file.LOG,' --- > p_detail_ar_count :'||p_detail_ar_count);
263: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_ar_count :'||p_app_period_ar_count);

Line 260: fnd_file.put_line(fnd_file.LOG,' --- > p_tc_ar_count :'||p_tc_ar_count);

256:
257: fnd_file.put_line(fnd_file.LOG,' ================================= ');
258: fnd_file.put_line(fnd_file.LOG,' ====== Chunk count ============== ');
259: fnd_file.put_line(fnd_file.LOG,' ================================= ');
260: fnd_file.put_line(fnd_file.LOG,' --- > p_tc_ar_count :'||p_tc_ar_count);
261: fnd_file.put_line(fnd_file.LOG,' --- > p_day_ar_count :'||p_day_ar_count );
262: fnd_file.put_line(fnd_file.LOG,' --- > p_detail_ar_count :'||p_detail_ar_count);
263: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_ar_count :'||p_app_period_ar_count);
264: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_ar_count :'||p_tau_ar_count);

Line 261: fnd_file.put_line(fnd_file.LOG,' --- > p_day_ar_count :'||p_day_ar_count );

257: fnd_file.put_line(fnd_file.LOG,' ================================= ');
258: fnd_file.put_line(fnd_file.LOG,' ====== Chunk count ============== ');
259: fnd_file.put_line(fnd_file.LOG,' ================================= ');
260: fnd_file.put_line(fnd_file.LOG,' --- > p_tc_ar_count :'||p_tc_ar_count);
261: fnd_file.put_line(fnd_file.LOG,' --- > p_day_ar_count :'||p_day_ar_count );
262: fnd_file.put_line(fnd_file.LOG,' --- > p_detail_ar_count :'||p_detail_ar_count);
263: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_ar_count :'||p_app_period_ar_count);
264: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_ar_count :'||p_tau_ar_count);
265: fnd_file.put_line(fnd_file.LOG,' --- > p_td_ar_count :'||p_td_ar_count);

Line 262: fnd_file.put_line(fnd_file.LOG,' --- > p_detail_ar_count :'||p_detail_ar_count);

258: fnd_file.put_line(fnd_file.LOG,' ====== Chunk count ============== ');
259: fnd_file.put_line(fnd_file.LOG,' ================================= ');
260: fnd_file.put_line(fnd_file.LOG,' --- > p_tc_ar_count :'||p_tc_ar_count);
261: fnd_file.put_line(fnd_file.LOG,' --- > p_day_ar_count :'||p_day_ar_count );
262: fnd_file.put_line(fnd_file.LOG,' --- > p_detail_ar_count :'||p_detail_ar_count);
263: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_ar_count :'||p_app_period_ar_count);
264: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_ar_count :'||p_tau_ar_count);
265: fnd_file.put_line(fnd_file.LOG,' --- > p_td_ar_count :'||p_td_ar_count);
266: --fnd_file.put_line(fnd_file.LOG,' --- > p_trans_ar_count :'||p_trans_ar_count);

Line 263: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_ar_count :'||p_app_period_ar_count);

259: fnd_file.put_line(fnd_file.LOG,' ================================= ');
260: fnd_file.put_line(fnd_file.LOG,' --- > p_tc_ar_count :'||p_tc_ar_count);
261: fnd_file.put_line(fnd_file.LOG,' --- > p_day_ar_count :'||p_day_ar_count );
262: fnd_file.put_line(fnd_file.LOG,' --- > p_detail_ar_count :'||p_detail_ar_count);
263: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_ar_count :'||p_app_period_ar_count);
264: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_ar_count :'||p_tau_ar_count);
265: fnd_file.put_line(fnd_file.LOG,' --- > p_td_ar_count :'||p_td_ar_count);
266: --fnd_file.put_line(fnd_file.LOG,' --- > p_trans_ar_count :'||p_trans_ar_count);
267: fnd_file.put_line(fnd_file.LOG,' --- > p_tal_ar_count :'||p_tal_ar_count);

Line 264: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_ar_count :'||p_tau_ar_count);

260: fnd_file.put_line(fnd_file.LOG,' --- > p_tc_ar_count :'||p_tc_ar_count);
261: fnd_file.put_line(fnd_file.LOG,' --- > p_day_ar_count :'||p_day_ar_count );
262: fnd_file.put_line(fnd_file.LOG,' --- > p_detail_ar_count :'||p_detail_ar_count);
263: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_ar_count :'||p_app_period_ar_count);
264: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_ar_count :'||p_tau_ar_count);
265: fnd_file.put_line(fnd_file.LOG,' --- > p_td_ar_count :'||p_td_ar_count);
266: --fnd_file.put_line(fnd_file.LOG,' --- > p_trans_ar_count :'||p_trans_ar_count);
267: fnd_file.put_line(fnd_file.LOG,' --- > p_tal_ar_count :'||p_tal_ar_count);
268: fnd_file.put_line(fnd_file.LOG,' --- > p_adl_ar_count :'||p_adl_ar_count);

Line 265: fnd_file.put_line(fnd_file.LOG,' --- > p_td_ar_count :'||p_td_ar_count);

261: fnd_file.put_line(fnd_file.LOG,' --- > p_day_ar_count :'||p_day_ar_count );
262: fnd_file.put_line(fnd_file.LOG,' --- > p_detail_ar_count :'||p_detail_ar_count);
263: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_ar_count :'||p_app_period_ar_count);
264: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_ar_count :'||p_tau_ar_count);
265: fnd_file.put_line(fnd_file.LOG,' --- > p_td_ar_count :'||p_td_ar_count);
266: --fnd_file.put_line(fnd_file.LOG,' --- > p_trans_ar_count :'||p_trans_ar_count);
267: fnd_file.put_line(fnd_file.LOG,' --- > p_tal_ar_count :'||p_tal_ar_count);
268: fnd_file.put_line(fnd_file.LOG,' --- > p_adl_ar_count :'||p_adl_ar_count);
269: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_sum_ar_count :'||p_app_period_sum_ar_count);

Line 266: --fnd_file.put_line(fnd_file.LOG,' --- > p_trans_ar_count :'||p_trans_ar_count);

262: fnd_file.put_line(fnd_file.LOG,' --- > p_detail_ar_count :'||p_detail_ar_count);
263: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_ar_count :'||p_app_period_ar_count);
264: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_ar_count :'||p_tau_ar_count);
265: fnd_file.put_line(fnd_file.LOG,' --- > p_td_ar_count :'||p_td_ar_count);
266: --fnd_file.put_line(fnd_file.LOG,' --- > p_trans_ar_count :'||p_trans_ar_count);
267: fnd_file.put_line(fnd_file.LOG,' --- > p_tal_ar_count :'||p_tal_ar_count);
268: fnd_file.put_line(fnd_file.LOG,' --- > p_adl_ar_count :'||p_adl_ar_count);
269: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_sum_ar_count :'||p_app_period_sum_ar_count);
270: fnd_file.put_line(fnd_file.LOG,' --- > p_tbb_count :'||p_tbb_count);

Line 267: fnd_file.put_line(fnd_file.LOG,' --- > p_tal_ar_count :'||p_tal_ar_count);

263: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_ar_count :'||p_app_period_ar_count);
264: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_ar_count :'||p_tau_ar_count);
265: fnd_file.put_line(fnd_file.LOG,' --- > p_td_ar_count :'||p_td_ar_count);
266: --fnd_file.put_line(fnd_file.LOG,' --- > p_trans_ar_count :'||p_trans_ar_count);
267: fnd_file.put_line(fnd_file.LOG,' --- > p_tal_ar_count :'||p_tal_ar_count);
268: fnd_file.put_line(fnd_file.LOG,' --- > p_adl_ar_count :'||p_adl_ar_count);
269: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_sum_ar_count :'||p_app_period_sum_ar_count);
270: fnd_file.put_line(fnd_file.LOG,' --- > p_tbb_count :'||p_tbb_count);
271: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_count :'||p_app_period_count);

Line 268: fnd_file.put_line(fnd_file.LOG,' --- > p_adl_ar_count :'||p_adl_ar_count);

264: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_ar_count :'||p_tau_ar_count);
265: fnd_file.put_line(fnd_file.LOG,' --- > p_td_ar_count :'||p_td_ar_count);
266: --fnd_file.put_line(fnd_file.LOG,' --- > p_trans_ar_count :'||p_trans_ar_count);
267: fnd_file.put_line(fnd_file.LOG,' --- > p_tal_ar_count :'||p_tal_ar_count);
268: fnd_file.put_line(fnd_file.LOG,' --- > p_adl_ar_count :'||p_adl_ar_count);
269: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_sum_ar_count :'||p_app_period_sum_ar_count);
270: fnd_file.put_line(fnd_file.LOG,' --- > p_tbb_count :'||p_tbb_count);
271: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_count :'||p_app_period_count);
272: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_count :'||p_tau_count);

Line 269: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_sum_ar_count :'||p_app_period_sum_ar_count);

265: fnd_file.put_line(fnd_file.LOG,' --- > p_td_ar_count :'||p_td_ar_count);
266: --fnd_file.put_line(fnd_file.LOG,' --- > p_trans_ar_count :'||p_trans_ar_count);
267: fnd_file.put_line(fnd_file.LOG,' --- > p_tal_ar_count :'||p_tal_ar_count);
268: fnd_file.put_line(fnd_file.LOG,' --- > p_adl_ar_count :'||p_adl_ar_count);
269: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_sum_ar_count :'||p_app_period_sum_ar_count);
270: fnd_file.put_line(fnd_file.LOG,' --- > p_tbb_count :'||p_tbb_count);
271: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_count :'||p_app_period_count);
272: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_count :'||p_tau_count);
273: fnd_file.put_line(fnd_file.LOG,' --- > p_td_count :'||p_td_count);

Line 270: fnd_file.put_line(fnd_file.LOG,' --- > p_tbb_count :'||p_tbb_count);

266: --fnd_file.put_line(fnd_file.LOG,' --- > p_trans_ar_count :'||p_trans_ar_count);
267: fnd_file.put_line(fnd_file.LOG,' --- > p_tal_ar_count :'||p_tal_ar_count);
268: fnd_file.put_line(fnd_file.LOG,' --- > p_adl_ar_count :'||p_adl_ar_count);
269: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_sum_ar_count :'||p_app_period_sum_ar_count);
270: fnd_file.put_line(fnd_file.LOG,' --- > p_tbb_count :'||p_tbb_count);
271: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_count :'||p_app_period_count);
272: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_count :'||p_tau_count);
273: fnd_file.put_line(fnd_file.LOG,' --- > p_td_count :'||p_td_count);
274: fnd_file.put_line(fnd_file.LOG,' --- > p_trans_count :'||p_trans_count);

Line 271: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_count :'||p_app_period_count);

267: fnd_file.put_line(fnd_file.LOG,' --- > p_tal_ar_count :'||p_tal_ar_count);
268: fnd_file.put_line(fnd_file.LOG,' --- > p_adl_ar_count :'||p_adl_ar_count);
269: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_sum_ar_count :'||p_app_period_sum_ar_count);
270: fnd_file.put_line(fnd_file.LOG,' --- > p_tbb_count :'||p_tbb_count);
271: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_count :'||p_app_period_count);
272: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_count :'||p_tau_count);
273: fnd_file.put_line(fnd_file.LOG,' --- > p_td_count :'||p_td_count);
274: fnd_file.put_line(fnd_file.LOG,' --- > p_trans_count :'||p_trans_count);
275: fnd_file.put_line(fnd_file.LOG,' --- > p_tal_count :'||p_tal_count);

Line 272: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_count :'||p_tau_count);

268: fnd_file.put_line(fnd_file.LOG,' --- > p_adl_ar_count :'||p_adl_ar_count);
269: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_sum_ar_count :'||p_app_period_sum_ar_count);
270: fnd_file.put_line(fnd_file.LOG,' --- > p_tbb_count :'||p_tbb_count);
271: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_count :'||p_app_period_count);
272: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_count :'||p_tau_count);
273: fnd_file.put_line(fnd_file.LOG,' --- > p_td_count :'||p_td_count);
274: fnd_file.put_line(fnd_file.LOG,' --- > p_trans_count :'||p_trans_count);
275: fnd_file.put_line(fnd_file.LOG,' --- > p_tal_count :'||p_tal_count);
276: fnd_file.put_line(fnd_file.LOG,' --- > p_adl_count :'||p_adl_count);

Line 273: fnd_file.put_line(fnd_file.LOG,' --- > p_td_count :'||p_td_count);

269: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_sum_ar_count :'||p_app_period_sum_ar_count);
270: fnd_file.put_line(fnd_file.LOG,' --- > p_tbb_count :'||p_tbb_count);
271: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_count :'||p_app_period_count);
272: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_count :'||p_tau_count);
273: fnd_file.put_line(fnd_file.LOG,' --- > p_td_count :'||p_td_count);
274: fnd_file.put_line(fnd_file.LOG,' --- > p_trans_count :'||p_trans_count);
275: fnd_file.put_line(fnd_file.LOG,' --- > p_tal_count :'||p_tal_count);
276: fnd_file.put_line(fnd_file.LOG,' --- > p_adl_count :'||p_adl_count);
277: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_sum_count :'||p_app_period_sum_count);

Line 274: fnd_file.put_line(fnd_file.LOG,' --- > p_trans_count :'||p_trans_count);

270: fnd_file.put_line(fnd_file.LOG,' --- > p_tbb_count :'||p_tbb_count);
271: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_count :'||p_app_period_count);
272: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_count :'||p_tau_count);
273: fnd_file.put_line(fnd_file.LOG,' --- > p_td_count :'||p_td_count);
274: fnd_file.put_line(fnd_file.LOG,' --- > p_trans_count :'||p_trans_count);
275: fnd_file.put_line(fnd_file.LOG,' --- > p_tal_count :'||p_tal_count);
276: fnd_file.put_line(fnd_file.LOG,' --- > p_adl_count :'||p_adl_count);
277: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_sum_count :'||p_app_period_sum_count);
278:

Line 275: fnd_file.put_line(fnd_file.LOG,' --- > p_tal_count :'||p_tal_count);

271: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_count :'||p_app_period_count);
272: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_count :'||p_tau_count);
273: fnd_file.put_line(fnd_file.LOG,' --- > p_td_count :'||p_td_count);
274: fnd_file.put_line(fnd_file.LOG,' --- > p_trans_count :'||p_trans_count);
275: fnd_file.put_line(fnd_file.LOG,' --- > p_tal_count :'||p_tal_count);
276: fnd_file.put_line(fnd_file.LOG,' --- > p_adl_count :'||p_adl_count);
277: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_sum_count :'||p_app_period_sum_count);
278:
279:

Line 276: fnd_file.put_line(fnd_file.LOG,' --- > p_adl_count :'||p_adl_count);

272: fnd_file.put_line(fnd_file.LOG,' --- > p_tau_count :'||p_tau_count);
273: fnd_file.put_line(fnd_file.LOG,' --- > p_td_count :'||p_td_count);
274: fnd_file.put_line(fnd_file.LOG,' --- > p_trans_count :'||p_trans_count);
275: fnd_file.put_line(fnd_file.LOG,' --- > p_tal_count :'||p_tal_count);
276: fnd_file.put_line(fnd_file.LOG,' --- > p_adl_count :'||p_adl_count);
277: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_sum_count :'||p_app_period_sum_count);
278:
279:
280: IF (p_tc_ar_count + p_day_ar_count + p_detail_ar_count) <> p_tbb_count THEN

Line 277: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_sum_count :'||p_app_period_sum_count);

273: fnd_file.put_line(fnd_file.LOG,' --- > p_td_count :'||p_td_count);
274: fnd_file.put_line(fnd_file.LOG,' --- > p_trans_count :'||p_trans_count);
275: fnd_file.put_line(fnd_file.LOG,' --- > p_tal_count :'||p_tal_count);
276: fnd_file.put_line(fnd_file.LOG,' --- > p_adl_count :'||p_adl_count);
277: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_sum_count :'||p_app_period_sum_count);
278:
279:
280: IF (p_tc_ar_count + p_day_ar_count + p_detail_ar_count) <> p_tbb_count THEN
281: fnd_file.put_line(fnd_file.LOG,'==> THE TIMECARD, DAY , DETAIL COUNT FAILED ');

Line 281: fnd_file.put_line(fnd_file.LOG,'==> THE TIMECARD, DAY , DETAIL COUNT FAILED ');

277: fnd_file.put_line(fnd_file.LOG,' --- > p_app_period_sum_count :'||p_app_period_sum_count);
278:
279:
280: IF (p_tc_ar_count + p_day_ar_count + p_detail_ar_count) <> p_tbb_count THEN
281: fnd_file.put_line(fnd_file.LOG,'==> THE TIMECARD, DAY , DETAIL COUNT FAILED ');
282: RAISE hxc_archive_restore_process.e_chunk_count;
283: END IF;
284:
285: IF p_app_period_ar_count <> p_app_period_count THEN

Line 286: fnd_file.put_line(fnd_file.LOG,'==> THE APPLICATION PERIOD COUNT FAILED');

282: RAISE hxc_archive_restore_process.e_chunk_count;
283: END IF;
284:
285: IF p_app_period_ar_count <> p_app_period_count THEN
286: fnd_file.put_line(fnd_file.LOG,'==> THE APPLICATION PERIOD COUNT FAILED');
287: RAISE hxc_archive_restore_process.e_chunk_count;
288: END IF;
289:
290: IF p_tau_ar_count <> p_tau_count THEN

Line 291: fnd_file.put_line(fnd_file.LOG,'==> THE TIME ATTRIBUTE USAGES COUNT FAILED');

287: RAISE hxc_archive_restore_process.e_chunk_count;
288: END IF;
289:
290: IF p_tau_ar_count <> p_tau_count THEN
291: fnd_file.put_line(fnd_file.LOG,'==> THE TIME ATTRIBUTE USAGES COUNT FAILED');
292: RAISE hxc_archive_restore_process.e_chunk_count;
293: END IF;
294:
295: IF p_td_ar_count <> p_td_count THEN

Line 296: fnd_file.put_line(fnd_file.LOG,'==> THE TRANSACTION DETAILS COUNT FAILED');

292: RAISE hxc_archive_restore_process.e_chunk_count;
293: END IF;
294:
295: IF p_td_ar_count <> p_td_count THEN
296: fnd_file.put_line(fnd_file.LOG,'==> THE TRANSACTION DETAILS COUNT FAILED');
297: RAISE hxc_archive_restore_process.e_chunk_count;
298: END IF;
299:
300: -- IF p_trans_ar_count <> p_trans_count THEN

Line 301: --fnd_file.put_line(fnd_file.LOG,' The Transaction count failed ');

297: RAISE hxc_archive_restore_process.e_chunk_count;
298: END IF;
299:
300: -- IF p_trans_ar_count <> p_trans_count THEN
301: --fnd_file.put_line(fnd_file.LOG,' The Transaction count failed ');
302: -- RAISE hxc_archive_restore_process.e_chunk_count;
303: -- END IF;
304:
305: IF p_tal_ar_count <> p_tal_count THEN

Line 306: fnd_file.put_line(fnd_file.LOG,'==> THE TIMECARD APPLICATION PERIODS COUNT FAILED');

302: -- RAISE hxc_archive_restore_process.e_chunk_count;
303: -- END IF;
304:
305: IF p_tal_ar_count <> p_tal_count THEN
306: fnd_file.put_line(fnd_file.LOG,'==> THE TIMECARD APPLICATION PERIODS COUNT FAILED');
307: RAISE hxc_archive_restore_process.e_chunk_count;
308: END IF;
309:
310: IF p_adl_ar_count <> p_adl_count THEN

Line 311: fnd_file.put_line(fnd_file.LOG,'==> THE APPLICATION PERIODS - DETAILS BB COUNT FAILED');

307: RAISE hxc_archive_restore_process.e_chunk_count;
308: END IF;
309:
310: IF p_adl_ar_count <> p_adl_count THEN
311: fnd_file.put_line(fnd_file.LOG,'==> THE APPLICATION PERIODS - DETAILS BB COUNT FAILED');
312: RAISE hxc_archive_restore_process.e_chunk_count;
313: END IF;
314:
315: IF p_app_period_sum_ar_count <> p_app_period_sum_count THEN

Line 316: fnd_file.put_line(fnd_file.LOG,'==> THE APPLICATION PERIOD SUMMARY COUNT FAILED');

312: RAISE hxc_archive_restore_process.e_chunk_count;
313: END IF;
314:
315: IF p_app_period_sum_ar_count <> p_app_period_sum_count THEN
316: fnd_file.put_line(fnd_file.LOG,'==> THE APPLICATION PERIOD SUMMARY COUNT FAILED');
317: RAISE hxc_archive_restore_process.e_chunk_count;
318: END IF;
319:
320: END count_chunk_check;

Line 372: fnd_file.put_line(fnd_file.LOG,'----------------------------------------');

368: l_att_diff_check NUMBER;
369:
370: BEGIN
371:
372: fnd_file.put_line(fnd_file.LOG,'----------------------------------------');
373: fnd_file.put_line(fnd_file.LOG,'------ COUNT CHECK ON SNAPSHOT --------');
374: fnd_file.put_line(fnd_file.LOG,'----------------------------------------');
375: fnd_file.put_line(fnd_file.LOG,'--- Building Blocks Table Count ------');
376: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_1 '||p_tbb_count_1);

Line 373: fnd_file.put_line(fnd_file.LOG,'------ COUNT CHECK ON SNAPSHOT --------');

369:
370: BEGIN
371:
372: fnd_file.put_line(fnd_file.LOG,'----------------------------------------');
373: fnd_file.put_line(fnd_file.LOG,'------ COUNT CHECK ON SNAPSHOT --------');
374: fnd_file.put_line(fnd_file.LOG,'----------------------------------------');
375: fnd_file.put_line(fnd_file.LOG,'--- Building Blocks Table Count ------');
376: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_1 '||p_tbb_count_1);
377: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_2 '|| p_tbb_count_2);

Line 374: fnd_file.put_line(fnd_file.LOG,'----------------------------------------');

370: BEGIN
371:
372: fnd_file.put_line(fnd_file.LOG,'----------------------------------------');
373: fnd_file.put_line(fnd_file.LOG,'------ COUNT CHECK ON SNAPSHOT --------');
374: fnd_file.put_line(fnd_file.LOG,'----------------------------------------');
375: fnd_file.put_line(fnd_file.LOG,'--- Building Blocks Table Count ------');
376: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_1 '||p_tbb_count_1);
377: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_2 '|| p_tbb_count_2);
378: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_ar_count_1 '||p_tbb_ar_count_1);

Line 375: fnd_file.put_line(fnd_file.LOG,'--- Building Blocks Table Count ------');

371:
372: fnd_file.put_line(fnd_file.LOG,'----------------------------------------');
373: fnd_file.put_line(fnd_file.LOG,'------ COUNT CHECK ON SNAPSHOT --------');
374: fnd_file.put_line(fnd_file.LOG,'----------------------------------------');
375: fnd_file.put_line(fnd_file.LOG,'--- Building Blocks Table Count ------');
376: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_1 '||p_tbb_count_1);
377: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_2 '|| p_tbb_count_2);
378: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_ar_count_1 '||p_tbb_ar_count_1);
379: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_ar_count_2 '||p_tbb_ar_count_2);

Line 376: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_1 '||p_tbb_count_1);

372: fnd_file.put_line(fnd_file.LOG,'----------------------------------------');
373: fnd_file.put_line(fnd_file.LOG,'------ COUNT CHECK ON SNAPSHOT --------');
374: fnd_file.put_line(fnd_file.LOG,'----------------------------------------');
375: fnd_file.put_line(fnd_file.LOG,'--- Building Blocks Table Count ------');
376: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_1 '||p_tbb_count_1);
377: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_2 '|| p_tbb_count_2);
378: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_ar_count_1 '||p_tbb_ar_count_1);
379: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_ar_count_2 '||p_tbb_ar_count_2);
380: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tbb_count_1 - p_tbb_count_2));

Line 377: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_2 '|| p_tbb_count_2);

373: fnd_file.put_line(fnd_file.LOG,'------ COUNT CHECK ON SNAPSHOT --------');
374: fnd_file.put_line(fnd_file.LOG,'----------------------------------------');
375: fnd_file.put_line(fnd_file.LOG,'--- Building Blocks Table Count ------');
376: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_1 '||p_tbb_count_1);
377: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_2 '|| p_tbb_count_2);
378: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_ar_count_1 '||p_tbb_ar_count_1);
379: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_ar_count_2 '||p_tbb_ar_count_2);
380: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tbb_count_1 - p_tbb_count_2));
381: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_tbb_ar_count_2 - p_tbb_ar_count_1));

Line 378: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_ar_count_1 '||p_tbb_ar_count_1);

374: fnd_file.put_line(fnd_file.LOG,'----------------------------------------');
375: fnd_file.put_line(fnd_file.LOG,'--- Building Blocks Table Count ------');
376: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_1 '||p_tbb_count_1);
377: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_2 '|| p_tbb_count_2);
378: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_ar_count_1 '||p_tbb_ar_count_1);
379: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_ar_count_2 '||p_tbb_ar_count_2);
380: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tbb_count_1 - p_tbb_count_2));
381: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_tbb_ar_count_2 - p_tbb_ar_count_1));
382:

Line 379: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_ar_count_2 '||p_tbb_ar_count_2);

375: fnd_file.put_line(fnd_file.LOG,'--- Building Blocks Table Count ------');
376: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_1 '||p_tbb_count_1);
377: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_2 '|| p_tbb_count_2);
378: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_ar_count_1 '||p_tbb_ar_count_1);
379: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_ar_count_2 '||p_tbb_ar_count_2);
380: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tbb_count_1 - p_tbb_count_2));
381: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_tbb_ar_count_2 - p_tbb_ar_count_1));
382:
383: -- we can check that all the time building block have been transfered

Line 380: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tbb_count_1 - p_tbb_count_2));

376: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_1 '||p_tbb_count_1);
377: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_2 '|| p_tbb_count_2);
378: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_ar_count_1 '||p_tbb_ar_count_1);
379: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_ar_count_2 '||p_tbb_ar_count_2);
380: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tbb_count_1 - p_tbb_count_2));
381: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_tbb_ar_count_2 - p_tbb_ar_count_1));
382:
383: -- we can check that all the time building block have been transfered
384: IF (p_tbb_count_1 - p_tbb_count_2) <> (p_tbb_ar_count_2 - p_tbb_ar_count_1)

Line 381: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_tbb_ar_count_2 - p_tbb_ar_count_1));

377: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_count_2 '|| p_tbb_count_2);
378: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_ar_count_1 '||p_tbb_ar_count_1);
379: fnd_file.put_line(fnd_file.LOG,'--- > p_tbb_ar_count_2 '||p_tbb_ar_count_2);
380: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tbb_count_1 - p_tbb_count_2));
381: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_tbb_ar_count_2 - p_tbb_ar_count_1));
382:
383: -- we can check that all the time building block have been transfered
384: IF (p_tbb_count_1 - p_tbb_count_2) <> (p_tbb_ar_count_2 - p_tbb_ar_count_1)
385: THEN

Line 387: fnd_file.put_line(fnd_file.LOG,'=== > COPY FAILED ON THE TIME BUILDING BLOCK');

383: -- we can check that all the time building block have been transfered
384: IF (p_tbb_count_1 - p_tbb_count_2) <> (p_tbb_ar_count_2 - p_tbb_ar_count_1)
385: THEN
386: --error
387: fnd_file.put_line(fnd_file.LOG,'=== > COPY FAILED ON THE TIME BUILDING BLOCK');
388: retcode := 2;
389: --RETURN;
390: END IF;
391:

Line 392: fnd_file.put_line(fnd_file.LOG,'-----------------------------------');

388: retcode := 2;
389: --RETURN;
390: END IF;
391:
392: fnd_file.put_line(fnd_file.LOG,'-----------------------------------');
393: fnd_file.put_line(fnd_file.LOG,'--- Attribute Usages Count ------');
394: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_count_1 '||p_tau_count_1);
395: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_count_2 '||p_tau_count_2);
396: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_ar_count_1 '||p_tau_ar_count_1);

Line 393: fnd_file.put_line(fnd_file.LOG,'--- Attribute Usages Count ------');

389: --RETURN;
390: END IF;
391:
392: fnd_file.put_line(fnd_file.LOG,'-----------------------------------');
393: fnd_file.put_line(fnd_file.LOG,'--- Attribute Usages Count ------');
394: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_count_1 '||p_tau_count_1);
395: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_count_2 '||p_tau_count_2);
396: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_ar_count_1 '||p_tau_ar_count_1);
397: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_ar_count_2 '||p_tau_ar_count_2);

Line 394: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_count_1 '||p_tau_count_1);

390: END IF;
391:
392: fnd_file.put_line(fnd_file.LOG,'-----------------------------------');
393: fnd_file.put_line(fnd_file.LOG,'--- Attribute Usages Count ------');
394: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_count_1 '||p_tau_count_1);
395: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_count_2 '||p_tau_count_2);
396: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_ar_count_1 '||p_tau_ar_count_1);
397: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_ar_count_2 '||p_tau_ar_count_2);
398: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tau_count_1 - p_tau_count_2));

Line 395: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_count_2 '||p_tau_count_2);

391:
392: fnd_file.put_line(fnd_file.LOG,'-----------------------------------');
393: fnd_file.put_line(fnd_file.LOG,'--- Attribute Usages Count ------');
394: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_count_1 '||p_tau_count_1);
395: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_count_2 '||p_tau_count_2);
396: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_ar_count_1 '||p_tau_ar_count_1);
397: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_ar_count_2 '||p_tau_ar_count_2);
398: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tau_count_1 - p_tau_count_2));
399: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_tau_ar_count_2 - p_tau_ar_count_1));

Line 396: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_ar_count_1 '||p_tau_ar_count_1);

392: fnd_file.put_line(fnd_file.LOG,'-----------------------------------');
393: fnd_file.put_line(fnd_file.LOG,'--- Attribute Usages Count ------');
394: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_count_1 '||p_tau_count_1);
395: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_count_2 '||p_tau_count_2);
396: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_ar_count_1 '||p_tau_ar_count_1);
397: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_ar_count_2 '||p_tau_ar_count_2);
398: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tau_count_1 - p_tau_count_2));
399: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_tau_ar_count_2 - p_tau_ar_count_1));
400:

Line 397: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_ar_count_2 '||p_tau_ar_count_2);

393: fnd_file.put_line(fnd_file.LOG,'--- Attribute Usages Count ------');
394: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_count_1 '||p_tau_count_1);
395: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_count_2 '||p_tau_count_2);
396: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_ar_count_1 '||p_tau_ar_count_1);
397: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_ar_count_2 '||p_tau_ar_count_2);
398: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tau_count_1 - p_tau_count_2));
399: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_tau_ar_count_2 - p_tau_ar_count_1));
400:
401: -- we can check that all the attributes usages have been transfered

Line 398: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tau_count_1 - p_tau_count_2));

394: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_count_1 '||p_tau_count_1);
395: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_count_2 '||p_tau_count_2);
396: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_ar_count_1 '||p_tau_ar_count_1);
397: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_ar_count_2 '||p_tau_ar_count_2);
398: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tau_count_1 - p_tau_count_2));
399: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_tau_ar_count_2 - p_tau_ar_count_1));
400:
401: -- we can check that all the attributes usages have been transfered
402: IF (p_tau_count_1 - p_tau_count_2) <> (p_tau_ar_count_2 - p_tau_ar_count_1)

Line 399: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_tau_ar_count_2 - p_tau_ar_count_1));

395: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_count_2 '||p_tau_count_2);
396: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_ar_count_1 '||p_tau_ar_count_1);
397: fnd_file.put_line(fnd_file.LOG,'--- > p_tau_ar_count_2 '||p_tau_ar_count_2);
398: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tau_count_1 - p_tau_count_2));
399: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_tau_ar_count_2 - p_tau_ar_count_1));
400:
401: -- we can check that all the attributes usages have been transfered
402: IF (p_tau_count_1 - p_tau_count_2) <> (p_tau_ar_count_2 - p_tau_ar_count_1)
403: THEN

Line 405: fnd_file.put_line(fnd_file.LOG,'=== > COPY FAILED ON THE ATTRIBUTE USAGES BLOCK');

401: -- we can check that all the attributes usages have been transfered
402: IF (p_tau_count_1 - p_tau_count_2) <> (p_tau_ar_count_2 - p_tau_ar_count_1)
403: THEN
404: --error
405: fnd_file.put_line(fnd_file.LOG,'=== > COPY FAILED ON THE ATTRIBUTE USAGES BLOCK');
406: retcode := 2;
407: --RETURN;
408: END IF;
409:

Line 410: fnd_file.put_line(fnd_file.LOG,'-----------------------------');

406: retcode := 2;
407: --RETURN;
408: END IF;
409:
410: fnd_file.put_line(fnd_file.LOG,'-----------------------------');
411: fnd_file.put_line(fnd_file.LOG,'--- Attribute Count ------');
412: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_count_1 '||p_ta_count_1);
413: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_count_2 '||p_ta_count_2);
414: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_ar_count_1 '||p_ta_ar_count_1);

Line 411: fnd_file.put_line(fnd_file.LOG,'--- Attribute Count ------');

407: --RETURN;
408: END IF;
409:
410: fnd_file.put_line(fnd_file.LOG,'-----------------------------');
411: fnd_file.put_line(fnd_file.LOG,'--- Attribute Count ------');
412: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_count_1 '||p_ta_count_1);
413: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_count_2 '||p_ta_count_2);
414: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_ar_count_1 '||p_ta_ar_count_1);
415: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_ar_count_2 '||p_ta_ar_count_2);

Line 412: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_count_1 '||p_ta_count_1);

408: END IF;
409:
410: fnd_file.put_line(fnd_file.LOG,'-----------------------------');
411: fnd_file.put_line(fnd_file.LOG,'--- Attribute Count ------');
412: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_count_1 '||p_ta_count_1);
413: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_count_2 '||p_ta_count_2);
414: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_ar_count_1 '||p_ta_ar_count_1);
415: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_ar_count_2 '||p_ta_ar_count_2);
416: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_ta_count_1 - p_ta_count_2));

Line 413: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_count_2 '||p_ta_count_2);

409:
410: fnd_file.put_line(fnd_file.LOG,'-----------------------------');
411: fnd_file.put_line(fnd_file.LOG,'--- Attribute Count ------');
412: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_count_1 '||p_ta_count_1);
413: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_count_2 '||p_ta_count_2);
414: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_ar_count_1 '||p_ta_ar_count_1);
415: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_ar_count_2 '||p_ta_ar_count_2);
416: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_ta_count_1 - p_ta_count_2));
417: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_ta_ar_count_2 - p_ta_ar_count_1));

Line 414: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_ar_count_1 '||p_ta_ar_count_1);

410: fnd_file.put_line(fnd_file.LOG,'-----------------------------');
411: fnd_file.put_line(fnd_file.LOG,'--- Attribute Count ------');
412: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_count_1 '||p_ta_count_1);
413: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_count_2 '||p_ta_count_2);
414: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_ar_count_1 '||p_ta_ar_count_1);
415: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_ar_count_2 '||p_ta_ar_count_2);
416: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_ta_count_1 - p_ta_count_2));
417: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_ta_ar_count_2 - p_ta_ar_count_1));
418:

Line 415: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_ar_count_2 '||p_ta_ar_count_2);

411: fnd_file.put_line(fnd_file.LOG,'--- Attribute Count ------');
412: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_count_1 '||p_ta_count_1);
413: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_count_2 '||p_ta_count_2);
414: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_ar_count_1 '||p_ta_ar_count_1);
415: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_ar_count_2 '||p_ta_ar_count_2);
416: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_ta_count_1 - p_ta_count_2));
417: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_ta_ar_count_2 - p_ta_ar_count_1));
418:
419: -- for the attributes we need to check more if the attributes count is different

Line 416: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_ta_count_1 - p_ta_count_2));

412: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_count_1 '||p_ta_count_1);
413: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_count_2 '||p_ta_count_2);
414: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_ar_count_1 '||p_ta_ar_count_1);
415: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_ar_count_2 '||p_ta_ar_count_2);
416: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_ta_count_1 - p_ta_count_2));
417: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_ta_ar_count_2 - p_ta_ar_count_1));
418:
419: -- for the attributes we need to check more if the attributes count is different
420: -- since we can copy consolidated attributes without deleting them from the core

Line 417: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_ta_ar_count_2 - p_ta_ar_count_1));

413: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_count_2 '||p_ta_count_2);
414: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_ar_count_1 '||p_ta_ar_count_1);
415: fnd_file.put_line(fnd_file.LOG,'--- > p_ta_ar_count_2 '||p_ta_ar_count_2);
416: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_ta_count_1 - p_ta_count_2));
417: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_ta_ar_count_2 - p_ta_ar_count_1));
418:
419: -- for the attributes we need to check more if the attributes count is different
420: -- since we can copy consolidated attributes without deleting them from the core
421: -- table

Line 425: fnd_file.put_line(fnd_file.LOG,'=== > SOME ATTRIBUTES WERE SHARED ');

421: -- table
422: IF (p_ta_count_1 - p_ta_count_2) <> (p_ta_ar_count_2 - p_ta_ar_count_1)
423: THEN
424: -- warning
425: fnd_file.put_line(fnd_file.LOG,'=== > SOME ATTRIBUTES WERE SHARED ');
426: retcode := 1;
427:
428: SELECT /*+ index_ffs (t HXC_TIME_ATTRIBUTES_PK ) parallel (4)*/ count(ta.time_attribute_id)
429: INTO l_att_diff_check

Line 438: fnd_file.put_line(fnd_file.LOG,'--- > Difference core - backup '||((p_ta_count_1 - p_ta_count_2) - (p_ta_ar_count_2 - p_ta_ar_count_1)));

434: WHERE tau.time_attribute_id = ta.time_attribute_id);
435:
436: --l_att_diff_check := sql%rowcount;
437:
438: fnd_file.put_line(fnd_file.LOG,'--- > Difference core - backup '||((p_ta_count_1 - p_ta_count_2) - (p_ta_ar_count_2 - p_ta_ar_count_1)));
439: fnd_file.put_line(fnd_file.LOG,'--- > l_att_diff_check '||l_att_diff_check);
440:
441: IF (abs((p_ta_ar_count_2 - p_ta_ar_count_1)-(p_ta_count_1 - p_ta_count_2)) <> abs(l_att_diff_check))
442: THEN

Line 439: fnd_file.put_line(fnd_file.LOG,'--- > l_att_diff_check '||l_att_diff_check);

435:
436: --l_att_diff_check := sql%rowcount;
437:
438: fnd_file.put_line(fnd_file.LOG,'--- > Difference core - backup '||((p_ta_count_1 - p_ta_count_2) - (p_ta_ar_count_2 - p_ta_ar_count_1)));
439: fnd_file.put_line(fnd_file.LOG,'--- > l_att_diff_check '||l_att_diff_check);
440:
441: IF (abs((p_ta_ar_count_2 - p_ta_ar_count_1)-(p_ta_count_1 - p_ta_count_2)) <> abs(l_att_diff_check))
442: THEN
443: fnd_file.put_line(fnd_file.LOG,'===> > IF THE PROCESS IS ARCHIVE THEN BAD TRANSFER OF ATTRIBUTES');

Line 443: fnd_file.put_line(fnd_file.LOG,'===> > IF THE PROCESS IS ARCHIVE THEN BAD TRANSFER OF ATTRIBUTES');

439: fnd_file.put_line(fnd_file.LOG,'--- > l_att_diff_check '||l_att_diff_check);
440:
441: IF (abs((p_ta_ar_count_2 - p_ta_ar_count_1)-(p_ta_count_1 - p_ta_count_2)) <> abs(l_att_diff_check))
442: THEN
443: fnd_file.put_line(fnd_file.LOG,'===> > IF THE PROCESS IS ARCHIVE THEN BAD TRANSFER OF ATTRIBUTES');
444:
445: -- we need to add another check to see if the difference is legitimate.
446: /****************** SET TO 2 *****************************/
447: retcode := 1;

Line 454: fnd_file.put_line(fnd_file.LOG,'---------------------------------------');

450:
451: END IF;
452:
453:
454: fnd_file.put_line(fnd_file.LOG,'---------------------------------------');
455: fnd_file.put_line(fnd_file.LOG,'--- Transaction Details Count ------');
456: fnd_file.put_line(fnd_file.LOG,'--- > p_td_count_1 '||p_td_count_1);
457: fnd_file.put_line(fnd_file.LOG,'--- > p_td_count_2 '||p_td_count_2);
458: fnd_file.put_line(fnd_file.LOG,'--- > p_td_ar_count_1 '||p_td_ar_count_1);

Line 455: fnd_file.put_line(fnd_file.LOG,'--- Transaction Details Count ------');

451: END IF;
452:
453:
454: fnd_file.put_line(fnd_file.LOG,'---------------------------------------');
455: fnd_file.put_line(fnd_file.LOG,'--- Transaction Details Count ------');
456: fnd_file.put_line(fnd_file.LOG,'--- > p_td_count_1 '||p_td_count_1);
457: fnd_file.put_line(fnd_file.LOG,'--- > p_td_count_2 '||p_td_count_2);
458: fnd_file.put_line(fnd_file.LOG,'--- > p_td_ar_count_1 '||p_td_ar_count_1);
459: fnd_file.put_line(fnd_file.LOG,'--- > p_td_ar_count_2 '||p_td_ar_count_2);

Line 456: fnd_file.put_line(fnd_file.LOG,'--- > p_td_count_1 '||p_td_count_1);

452:
453:
454: fnd_file.put_line(fnd_file.LOG,'---------------------------------------');
455: fnd_file.put_line(fnd_file.LOG,'--- Transaction Details Count ------');
456: fnd_file.put_line(fnd_file.LOG,'--- > p_td_count_1 '||p_td_count_1);
457: fnd_file.put_line(fnd_file.LOG,'--- > p_td_count_2 '||p_td_count_2);
458: fnd_file.put_line(fnd_file.LOG,'--- > p_td_ar_count_1 '||p_td_ar_count_1);
459: fnd_file.put_line(fnd_file.LOG,'--- > p_td_ar_count_2 '||p_td_ar_count_2);
460: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_td_count_1 - p_td_count_2));

Line 457: fnd_file.put_line(fnd_file.LOG,'--- > p_td_count_2 '||p_td_count_2);

453:
454: fnd_file.put_line(fnd_file.LOG,'---------------------------------------');
455: fnd_file.put_line(fnd_file.LOG,'--- Transaction Details Count ------');
456: fnd_file.put_line(fnd_file.LOG,'--- > p_td_count_1 '||p_td_count_1);
457: fnd_file.put_line(fnd_file.LOG,'--- > p_td_count_2 '||p_td_count_2);
458: fnd_file.put_line(fnd_file.LOG,'--- > p_td_ar_count_1 '||p_td_ar_count_1);
459: fnd_file.put_line(fnd_file.LOG,'--- > p_td_ar_count_2 '||p_td_ar_count_2);
460: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_td_count_1 - p_td_count_2));
461: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_td_ar_count_2 - p_td_ar_count_1));

Line 458: fnd_file.put_line(fnd_file.LOG,'--- > p_td_ar_count_1 '||p_td_ar_count_1);

454: fnd_file.put_line(fnd_file.LOG,'---------------------------------------');
455: fnd_file.put_line(fnd_file.LOG,'--- Transaction Details Count ------');
456: fnd_file.put_line(fnd_file.LOG,'--- > p_td_count_1 '||p_td_count_1);
457: fnd_file.put_line(fnd_file.LOG,'--- > p_td_count_2 '||p_td_count_2);
458: fnd_file.put_line(fnd_file.LOG,'--- > p_td_ar_count_1 '||p_td_ar_count_1);
459: fnd_file.put_line(fnd_file.LOG,'--- > p_td_ar_count_2 '||p_td_ar_count_2);
460: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_td_count_1 - p_td_count_2));
461: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_td_ar_count_2 - p_td_ar_count_1));
462:

Line 459: fnd_file.put_line(fnd_file.LOG,'--- > p_td_ar_count_2 '||p_td_ar_count_2);

455: fnd_file.put_line(fnd_file.LOG,'--- Transaction Details Count ------');
456: fnd_file.put_line(fnd_file.LOG,'--- > p_td_count_1 '||p_td_count_1);
457: fnd_file.put_line(fnd_file.LOG,'--- > p_td_count_2 '||p_td_count_2);
458: fnd_file.put_line(fnd_file.LOG,'--- > p_td_ar_count_1 '||p_td_ar_count_1);
459: fnd_file.put_line(fnd_file.LOG,'--- > p_td_ar_count_2 '||p_td_ar_count_2);
460: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_td_count_1 - p_td_count_2));
461: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_td_ar_count_2 - p_td_ar_count_1));
462:
463: -- we can check that all the transaction details have been transfered

Line 460: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_td_count_1 - p_td_count_2));

456: fnd_file.put_line(fnd_file.LOG,'--- > p_td_count_1 '||p_td_count_1);
457: fnd_file.put_line(fnd_file.LOG,'--- > p_td_count_2 '||p_td_count_2);
458: fnd_file.put_line(fnd_file.LOG,'--- > p_td_ar_count_1 '||p_td_ar_count_1);
459: fnd_file.put_line(fnd_file.LOG,'--- > p_td_ar_count_2 '||p_td_ar_count_2);
460: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_td_count_1 - p_td_count_2));
461: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_td_ar_count_2 - p_td_ar_count_1));
462:
463: -- we can check that all the transaction details have been transfered
464: IF (p_td_count_1 - p_td_count_2) <> (p_td_ar_count_2 - p_td_ar_count_1)

Line 461: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_td_ar_count_2 - p_td_ar_count_1));

457: fnd_file.put_line(fnd_file.LOG,'--- > p_td_count_2 '||p_td_count_2);
458: fnd_file.put_line(fnd_file.LOG,'--- > p_td_ar_count_1 '||p_td_ar_count_1);
459: fnd_file.put_line(fnd_file.LOG,'--- > p_td_ar_count_2 '||p_td_ar_count_2);
460: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_td_count_1 - p_td_count_2));
461: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_td_ar_count_2 - p_td_ar_count_1));
462:
463: -- we can check that all the transaction details have been transfered
464: IF (p_td_count_1 - p_td_count_2) <> (p_td_ar_count_2 - p_td_ar_count_1)
465: THEN

Line 467: fnd_file.put_line(fnd_file.LOG,'=== > COPY FAILED ON THE TRANSACTION DETAILS');

463: -- we can check that all the transaction details have been transfered
464: IF (p_td_count_1 - p_td_count_2) <> (p_td_ar_count_2 - p_td_ar_count_1)
465: THEN
466: --error
467: fnd_file.put_line(fnd_file.LOG,'=== > COPY FAILED ON THE TRANSACTION DETAILS');
468: retcode := 2;
469: --RETURN;
470: END IF;
471:

Line 472: fnd_file.put_line(fnd_file.LOG,'------------------------------');

468: retcode := 2;
469: --RETURN;
470: END IF;
471:
472: fnd_file.put_line(fnd_file.LOG,'------------------------------');
473: fnd_file.put_line(fnd_file.LOG,'--- Transaction Count ------');
474: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_count_1 '||p_trans_count_1);
475: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_count_2 '||p_trans_count_2);
476: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_ar_count_1 '||p_trans_ar_count_1);

Line 473: fnd_file.put_line(fnd_file.LOG,'--- Transaction Count ------');

469: --RETURN;
470: END IF;
471:
472: fnd_file.put_line(fnd_file.LOG,'------------------------------');
473: fnd_file.put_line(fnd_file.LOG,'--- Transaction Count ------');
474: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_count_1 '||p_trans_count_1);
475: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_count_2 '||p_trans_count_2);
476: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_ar_count_1 '||p_trans_ar_count_1);
477: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_ar_count_2 '||p_trans_ar_count_2);

Line 474: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_count_1 '||p_trans_count_1);

470: END IF;
471:
472: fnd_file.put_line(fnd_file.LOG,'------------------------------');
473: fnd_file.put_line(fnd_file.LOG,'--- Transaction Count ------');
474: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_count_1 '||p_trans_count_1);
475: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_count_2 '||p_trans_count_2);
476: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_ar_count_1 '||p_trans_ar_count_1);
477: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_ar_count_2 '||p_trans_ar_count_2);
478: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_trans_count_1 - p_trans_count_2));

Line 475: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_count_2 '||p_trans_count_2);

471:
472: fnd_file.put_line(fnd_file.LOG,'------------------------------');
473: fnd_file.put_line(fnd_file.LOG,'--- Transaction Count ------');
474: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_count_1 '||p_trans_count_1);
475: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_count_2 '||p_trans_count_2);
476: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_ar_count_1 '||p_trans_ar_count_1);
477: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_ar_count_2 '||p_trans_ar_count_2);
478: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_trans_count_1 - p_trans_count_2));
479: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_trans_ar_count_2 - p_trans_ar_count_1));

Line 476: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_ar_count_1 '||p_trans_ar_count_1);

472: fnd_file.put_line(fnd_file.LOG,'------------------------------');
473: fnd_file.put_line(fnd_file.LOG,'--- Transaction Count ------');
474: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_count_1 '||p_trans_count_1);
475: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_count_2 '||p_trans_count_2);
476: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_ar_count_1 '||p_trans_ar_count_1);
477: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_ar_count_2 '||p_trans_ar_count_2);
478: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_trans_count_1 - p_trans_count_2));
479: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_trans_ar_count_2 - p_trans_ar_count_1));
480:

Line 477: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_ar_count_2 '||p_trans_ar_count_2);

473: fnd_file.put_line(fnd_file.LOG,'--- Transaction Count ------');
474: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_count_1 '||p_trans_count_1);
475: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_count_2 '||p_trans_count_2);
476: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_ar_count_1 '||p_trans_ar_count_1);
477: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_ar_count_2 '||p_trans_ar_count_2);
478: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_trans_count_1 - p_trans_count_2));
479: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_trans_ar_count_2 - p_trans_ar_count_1));
480:
481: -- we can check that all the transactions have been transfered

Line 478: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_trans_count_1 - p_trans_count_2));

474: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_count_1 '||p_trans_count_1);
475: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_count_2 '||p_trans_count_2);
476: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_ar_count_1 '||p_trans_ar_count_1);
477: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_ar_count_2 '||p_trans_ar_count_2);
478: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_trans_count_1 - p_trans_count_2));
479: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_trans_ar_count_2 - p_trans_ar_count_1));
480:
481: -- we can check that all the transactions have been transfered
482: IF (p_trans_count_1 - p_trans_count_2) <> (p_trans_ar_count_2 - p_trans_ar_count_1)

Line 479: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_trans_ar_count_2 - p_trans_ar_count_1));

475: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_count_2 '||p_trans_count_2);
476: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_ar_count_1 '||p_trans_ar_count_1);
477: fnd_file.put_line(fnd_file.LOG,'--- > p_trans_ar_count_2 '||p_trans_ar_count_2);
478: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_trans_count_1 - p_trans_count_2));
479: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_trans_ar_count_2 - p_trans_ar_count_1));
480:
481: -- we can check that all the transactions have been transfered
482: IF (p_trans_count_1 - p_trans_count_2) <> (p_trans_ar_count_2 - p_trans_ar_count_1)
483: THEN

Line 485: fnd_file.put_line(fnd_file.LOG,'=== > COPY TRANSACTIONS WERE SHARED');

481: -- we can check that all the transactions have been transfered
482: IF (p_trans_count_1 - p_trans_count_2) <> (p_trans_ar_count_2 - p_trans_ar_count_1)
483: THEN
484: --error
485: fnd_file.put_line(fnd_file.LOG,'=== > COPY TRANSACTIONS WERE SHARED');
486: retcode := 1;
487: --RETURN;
488: END IF;
489:

Line 490: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------');

486: retcode := 1;
487: --RETURN;
488: END IF;
489:
490: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------');
491: fnd_file.put_line(fnd_file.LOG,'--- Timecard Application Period Links Count ------');
492: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_count_1 '||p_tal_count_1);
493: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_count_2 '||p_tal_count_2);
494: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_ar_count_1 '||p_tal_ar_count_1);

Line 491: fnd_file.put_line(fnd_file.LOG,'--- Timecard Application Period Links Count ------');

487: --RETURN;
488: END IF;
489:
490: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------');
491: fnd_file.put_line(fnd_file.LOG,'--- Timecard Application Period Links Count ------');
492: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_count_1 '||p_tal_count_1);
493: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_count_2 '||p_tal_count_2);
494: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_ar_count_1 '||p_tal_ar_count_1);
495: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_ar_count_2 '||p_tal_ar_count_2);

Line 492: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_count_1 '||p_tal_count_1);

488: END IF;
489:
490: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------');
491: fnd_file.put_line(fnd_file.LOG,'--- Timecard Application Period Links Count ------');
492: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_count_1 '||p_tal_count_1);
493: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_count_2 '||p_tal_count_2);
494: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_ar_count_1 '||p_tal_ar_count_1);
495: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_ar_count_2 '||p_tal_ar_count_2);
496: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tal_count_1 - p_tal_count_2));

Line 493: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_count_2 '||p_tal_count_2);

489:
490: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------');
491: fnd_file.put_line(fnd_file.LOG,'--- Timecard Application Period Links Count ------');
492: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_count_1 '||p_tal_count_1);
493: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_count_2 '||p_tal_count_2);
494: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_ar_count_1 '||p_tal_ar_count_1);
495: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_ar_count_2 '||p_tal_ar_count_2);
496: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tal_count_1 - p_tal_count_2));
497: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_tal_ar_count_2 - p_tal_ar_count_1));

Line 494: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_ar_count_1 '||p_tal_ar_count_1);

490: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------');
491: fnd_file.put_line(fnd_file.LOG,'--- Timecard Application Period Links Count ------');
492: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_count_1 '||p_tal_count_1);
493: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_count_2 '||p_tal_count_2);
494: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_ar_count_1 '||p_tal_ar_count_1);
495: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_ar_count_2 '||p_tal_ar_count_2);
496: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tal_count_1 - p_tal_count_2));
497: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_tal_ar_count_2 - p_tal_ar_count_1));
498:

Line 495: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_ar_count_2 '||p_tal_ar_count_2);

491: fnd_file.put_line(fnd_file.LOG,'--- Timecard Application Period Links Count ------');
492: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_count_1 '||p_tal_count_1);
493: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_count_2 '||p_tal_count_2);
494: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_ar_count_1 '||p_tal_ar_count_1);
495: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_ar_count_2 '||p_tal_ar_count_2);
496: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tal_count_1 - p_tal_count_2));
497: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_tal_ar_count_2 - p_tal_ar_count_1));
498:
499: -- we can check that all the timecard application links have been transfered

Line 496: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tal_count_1 - p_tal_count_2));

492: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_count_1 '||p_tal_count_1);
493: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_count_2 '||p_tal_count_2);
494: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_ar_count_1 '||p_tal_ar_count_1);
495: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_ar_count_2 '||p_tal_ar_count_2);
496: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tal_count_1 - p_tal_count_2));
497: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_tal_ar_count_2 - p_tal_ar_count_1));
498:
499: -- we can check that all the timecard application links have been transfered
500: IF (p_tal_count_1 - p_tal_count_2) <> (p_tal_ar_count_2 - p_tal_ar_count_1)

Line 497: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_tal_ar_count_2 - p_tal_ar_count_1));

493: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_count_2 '||p_tal_count_2);
494: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_ar_count_1 '||p_tal_ar_count_1);
495: fnd_file.put_line(fnd_file.LOG,'--- > p_tal_ar_count_2 '||p_tal_ar_count_2);
496: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_tal_count_1 - p_tal_count_2));
497: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_tal_ar_count_2 - p_tal_ar_count_1));
498:
499: -- we can check that all the timecard application links have been transfered
500: IF (p_tal_count_1 - p_tal_count_2) <> (p_tal_ar_count_2 - p_tal_ar_count_1)
501: THEN

Line 503: fnd_file.put_line(fnd_file.LOG,'=== > COPY FAILED ON THE TIMECARD APPLICATION PERIOD LINKS');

499: -- we can check that all the timecard application links have been transfered
500: IF (p_tal_count_1 - p_tal_count_2) <> (p_tal_ar_count_2 - p_tal_ar_count_1)
501: THEN
502: --error
503: fnd_file.put_line(fnd_file.LOG,'=== > COPY FAILED ON THE TIMECARD APPLICATION PERIOD LINKS');
504: retcode := 2;
505: --RETURN;
506: END IF;
507:

Line 509: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------');

505: --RETURN;
506: END IF;
507:
508:
509: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------');
510: fnd_file.put_line(fnd_file.LOG,'--- Application Period Detail BB Links Count ------');
511: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_count_1 '||p_adl_count_1);
512: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_count_2 '||p_adl_count_2);
513: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_ar_count_1 '||p_adl_ar_count_1);

Line 510: fnd_file.put_line(fnd_file.LOG,'--- Application Period Detail BB Links Count ------');

506: END IF;
507:
508:
509: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------');
510: fnd_file.put_line(fnd_file.LOG,'--- Application Period Detail BB Links Count ------');
511: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_count_1 '||p_adl_count_1);
512: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_count_2 '||p_adl_count_2);
513: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_ar_count_1 '||p_adl_ar_count_1);
514: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_ar_count_2 '||p_adl_ar_count_2);

Line 511: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_count_1 '||p_adl_count_1);

507:
508:
509: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------');
510: fnd_file.put_line(fnd_file.LOG,'--- Application Period Detail BB Links Count ------');
511: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_count_1 '||p_adl_count_1);
512: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_count_2 '||p_adl_count_2);
513: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_ar_count_1 '||p_adl_ar_count_1);
514: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_ar_count_2 '||p_adl_ar_count_2);
515: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_adl_count_1 - p_adl_count_2));

Line 512: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_count_2 '||p_adl_count_2);

508:
509: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------');
510: fnd_file.put_line(fnd_file.LOG,'--- Application Period Detail BB Links Count ------');
511: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_count_1 '||p_adl_count_1);
512: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_count_2 '||p_adl_count_2);
513: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_ar_count_1 '||p_adl_ar_count_1);
514: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_ar_count_2 '||p_adl_ar_count_2);
515: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_adl_count_1 - p_adl_count_2));
516: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_adl_ar_count_2 - p_adl_ar_count_1));

Line 513: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_ar_count_1 '||p_adl_ar_count_1);

509: fnd_file.put_line(fnd_file.LOG,'----------------------------------------------------');
510: fnd_file.put_line(fnd_file.LOG,'--- Application Period Detail BB Links Count ------');
511: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_count_1 '||p_adl_count_1);
512: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_count_2 '||p_adl_count_2);
513: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_ar_count_1 '||p_adl_ar_count_1);
514: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_ar_count_2 '||p_adl_ar_count_2);
515: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_adl_count_1 - p_adl_count_2));
516: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_adl_ar_count_2 - p_adl_ar_count_1));
517:

Line 514: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_ar_count_2 '||p_adl_ar_count_2);

510: fnd_file.put_line(fnd_file.LOG,'--- Application Period Detail BB Links Count ------');
511: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_count_1 '||p_adl_count_1);
512: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_count_2 '||p_adl_count_2);
513: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_ar_count_1 '||p_adl_ar_count_1);
514: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_ar_count_2 '||p_adl_ar_count_2);
515: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_adl_count_1 - p_adl_count_2));
516: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_adl_ar_count_2 - p_adl_ar_count_1));
517:
518: -- we can check that all the timecard application links have been transfered

Line 515: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_adl_count_1 - p_adl_count_2));

511: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_count_1 '||p_adl_count_1);
512: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_count_2 '||p_adl_count_2);
513: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_ar_count_1 '||p_adl_ar_count_1);
514: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_ar_count_2 '||p_adl_ar_count_2);
515: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_adl_count_1 - p_adl_count_2));
516: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_adl_ar_count_2 - p_adl_ar_count_1));
517:
518: -- we can check that all the timecard application links have been transfered
519: IF (p_adl_count_1 - p_adl_count_2) <> (p_adl_ar_count_2 - p_adl_ar_count_1)

Line 516: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_adl_ar_count_2 - p_adl_ar_count_1));

512: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_count_2 '||p_adl_count_2);
513: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_ar_count_1 '||p_adl_ar_count_1);
514: fnd_file.put_line(fnd_file.LOG,'--- > p_adl_ar_count_2 '||p_adl_ar_count_2);
515: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_adl_count_1 - p_adl_count_2));
516: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_adl_ar_count_2 - p_adl_ar_count_1));
517:
518: -- we can check that all the timecard application links have been transfered
519: IF (p_adl_count_1 - p_adl_count_2) <> (p_adl_ar_count_2 - p_adl_ar_count_1)
520: THEN

Line 522: fnd_file.put_line(fnd_file.LOG,'=== > COPY FAILED ON THE APPLICATION PERIOD DETAIL BB LINKS');

518: -- we can check that all the timecard application links have been transfered
519: IF (p_adl_count_1 - p_adl_count_2) <> (p_adl_ar_count_2 - p_adl_ar_count_1)
520: THEN
521: --error
522: fnd_file.put_line(fnd_file.LOG,'=== > COPY FAILED ON THE APPLICATION PERIOD DETAIL BB LINKS');
523: retcode := 2;
524: --RETURN;
525: END IF;
526:

Line 528: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------');

524: --RETURN;
525: END IF;
526:
527:
528: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------');
529: fnd_file.put_line(fnd_file.LOG,'--- Application Period Summary Count ------');
530: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_count_1 '||p_aps_count_1);
531: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_count_2 '||p_aps_count_2);
532: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_ar_count_1 '||p_aps_ar_count_1);

Line 529: fnd_file.put_line(fnd_file.LOG,'--- Application Period Summary Count ------');

525: END IF;
526:
527:
528: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------');
529: fnd_file.put_line(fnd_file.LOG,'--- Application Period Summary Count ------');
530: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_count_1 '||p_aps_count_1);
531: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_count_2 '||p_aps_count_2);
532: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_ar_count_1 '||p_aps_ar_count_1);
533: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_ar_count_2 '||p_aps_ar_count_2);

Line 530: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_count_1 '||p_aps_count_1);

526:
527:
528: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------');
529: fnd_file.put_line(fnd_file.LOG,'--- Application Period Summary Count ------');
530: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_count_1 '||p_aps_count_1);
531: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_count_2 '||p_aps_count_2);
532: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_ar_count_1 '||p_aps_ar_count_1);
533: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_ar_count_2 '||p_aps_ar_count_2);
534: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_aps_count_1 - p_aps_count_2));

Line 531: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_count_2 '||p_aps_count_2);

527:
528: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------');
529: fnd_file.put_line(fnd_file.LOG,'--- Application Period Summary Count ------');
530: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_count_1 '||p_aps_count_1);
531: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_count_2 '||p_aps_count_2);
532: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_ar_count_1 '||p_aps_ar_count_1);
533: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_ar_count_2 '||p_aps_ar_count_2);
534: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_aps_count_1 - p_aps_count_2));
535: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_aps_ar_count_2 - p_aps_ar_count_1));

Line 532: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_ar_count_1 '||p_aps_ar_count_1);

528: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------');
529: fnd_file.put_line(fnd_file.LOG,'--- Application Period Summary Count ------');
530: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_count_1 '||p_aps_count_1);
531: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_count_2 '||p_aps_count_2);
532: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_ar_count_1 '||p_aps_ar_count_1);
533: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_ar_count_2 '||p_aps_ar_count_2);
534: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_aps_count_1 - p_aps_count_2));
535: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_aps_ar_count_2 - p_aps_ar_count_1));
536:

Line 533: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_ar_count_2 '||p_aps_ar_count_2);

529: fnd_file.put_line(fnd_file.LOG,'--- Application Period Summary Count ------');
530: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_count_1 '||p_aps_count_1);
531: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_count_2 '||p_aps_count_2);
532: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_ar_count_1 '||p_aps_ar_count_1);
533: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_ar_count_2 '||p_aps_ar_count_2);
534: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_aps_count_1 - p_aps_count_2));
535: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_aps_ar_count_2 - p_aps_ar_count_1));
536:
537: -- we can check that all the application period summary have been transfered

Line 534: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_aps_count_1 - p_aps_count_2));

530: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_count_1 '||p_aps_count_1);
531: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_count_2 '||p_aps_count_2);
532: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_ar_count_1 '||p_aps_ar_count_1);
533: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_ar_count_2 '||p_aps_ar_count_2);
534: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_aps_count_1 - p_aps_count_2));
535: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_aps_ar_count_2 - p_aps_ar_count_1));
536:
537: -- we can check that all the application period summary have been transfered
538: IF (p_aps_count_1 - p_aps_count_2) <> (p_aps_ar_count_2 - p_aps_ar_count_1)

Line 535: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_aps_ar_count_2 - p_aps_ar_count_1));

531: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_count_2 '||p_aps_count_2);
532: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_ar_count_1 '||p_aps_ar_count_1);
533: fnd_file.put_line(fnd_file.LOG,'--- > p_aps_ar_count_2 '||p_aps_ar_count_2);
534: fnd_file.put_line(fnd_file.LOG,'--- > Difference core '||(p_aps_count_1 - p_aps_count_2));
535: fnd_file.put_line(fnd_file.LOG,'--- > Difference backup '||(p_aps_ar_count_2 - p_aps_ar_count_1));
536:
537: -- we can check that all the application period summary have been transfered
538: IF (p_aps_count_1 - p_aps_count_2) <> (p_aps_ar_count_2 - p_aps_ar_count_1)
539: THEN

Line 541: fnd_file.put_line(fnd_file.LOG,'=== > COPY FAILED ON THE APPLICATION PERIOD SUMMARY');

537: -- we can check that all the application period summary have been transfered
538: IF (p_aps_count_1 - p_aps_count_2) <> (p_aps_ar_count_2 - p_aps_ar_count_1)
539: THEN
540: --error
541: fnd_file.put_line(fnd_file.LOG,'=== > COPY FAILED ON THE APPLICATION PERIOD SUMMARY');
542: retcode := 2;
543: --RETURN;
544: END IF;
545: