1: Package Body FII_AP_INV_PAYMTS_F_C AS
2: /* $Header: FIIAP10B.pls 120.13 2004/11/19 06:09:49 sgautam ship $ */
3: G_PUSH_DATE_RANGE1 Date:=Null;
4: G_PUSH_DATE_RANGE2 Date:=Null;
5: g_row_count Number:=0;
833: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN
834: errbuf := fnd_message.get;
835: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
836: END IF;
837: FII_AP_INV_PAYMTS_F_C.g_push_date_range1 := nvl(l_from_date,
838: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
839: FII_AP_INV_PAYMTS_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
840: l_date1 := g_push_date_range1;
841: l_date2 := g_push_date_range2;
835: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
836: END IF;
837: FII_AP_INV_PAYMTS_F_C.g_push_date_range1 := nvl(l_from_date,
838: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
839: FII_AP_INV_PAYMTS_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
840: l_date1 := g_push_date_range1;
841: l_date2 := g_push_date_range2;
842: edw_log.put_line( 'The collection range is from '||
843: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
1168: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
1169: --raise;
1170:
1171: End;
1172: End FII_AP_INV_PAYMTS_F_C;