APPS.EDW_TRD_PARTNER_M_C dependencies on EDW_COLLECTION_UTIL

Line 245: l_tmp_str1 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN',

241: edw_log.put_line('Pushing data for TP Location Staging Table...');
242:
243: l_temp_date := sysdate;
244:
245: l_tmp_str1 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN',
246: 'EDW_TRD_PARTNER_M_TPLO');
247:
248: if (l_tmp_str1 IS NULL) THEN
249: edw_log.put_line('***Warning*** : No Look Code Found From GET_LEVEL_DP in Pushing TP Location');

Line 1098: IF (Not EDW_COLLECTION_UTIL.setup('EDW_TRD_PARTNER_M')) THEN

1094:
1095: Errbuf := NULL;
1096: Retcode := 0;
1097:
1098: IF (Not EDW_COLLECTION_UTIL.setup('EDW_TRD_PARTNER_M')) THEN
1099: errbuf := fnd_message.get;
1100: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
1101: END IF;
1102:

Line 1109: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);

1105: l_from_date := fnd_date.displayDT_to_date(p_from_date);
1106: l_to_date := fnd_date.displayDT_to_date(p_to_date);
1107:
1108: L_PUSH_DATE_RANGE1 := nvl (l_from_date,
1109: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
1110: L_PUSH_DATE_RANGE2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
1111: edw_log.put_line('The collection range is from ' ||
1112: to_char(l_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to ' ||
1113: to_char(l_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));

Line 1110: L_PUSH_DATE_RANGE2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

1106: l_to_date := fnd_date.displayDT_to_date(p_to_date);
1107:
1108: L_PUSH_DATE_RANGE1 := nvl (l_from_date,
1109: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
1110: L_PUSH_DATE_RANGE2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
1111: edw_log.put_line('The collection range is from ' ||
1112: to_char(l_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to ' ||
1113: to_char(l_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
1114: edw_log.put_line(' ');

Line 1151: EDW_COLLECTION_UTIL.wrapup(TRUE, EDW_TRD_PARTNER_M_C.g_row_count_m,

1147: Retcode,
1148: L_PUSH_DATE_RANGE1,
1149: L_PUSH_DATE_RANGE2);
1150:
1151: EDW_COLLECTION_UTIL.wrapup(TRUE, EDW_TRD_PARTNER_M_C.g_row_count_m,
1152: EDW_TRD_PARTNER_M_C.g_exception_message,
1153: L_PUSH_DATE_RANGE1, L_PUSH_DATE_RANGE2);
1154:
1155:

Line 1165: EDW_COLLECTION_UTIL.wrapup(FALSE,0,EDW_TRD_PARTNER_M_C.g_exception_message,

1161: EDW_TRD_PARTNER_M_C.g_exception_message :=
1162: EDW_TRD_PARTNER_M_C.g_exception_message || ' <> ' || Retcode ||
1163: ' : ' || Errbuf;
1164:
1165: EDW_COLLECTION_UTIL.wrapup(FALSE,0,EDW_TRD_PARTNER_M_C.g_exception_message,
1166: l_push_date_range1, l_push_date_range2);
1167:
1168: FND_FILE.PUT_LINE(FND_FILE.LOG, l_proc_name || ' failed');
1169: