DBA Data[Home] [Help]

APPS.FII_AR_TRX_DIST_F_C dependencies on EDW_COLLECTION_UTIL

Line 1441: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN

1437: -- --------------------------------------
1438: -- Running as parent monitoring process
1439: -- --------------------------------------
1440:
1441: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN
1442: errbuf := fnd_message.get;
1443: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
1444: END IF;
1445:

Line 1452: EDW_COLLECTION_UTIL.G_local_last_push_start_date -

1448: -- date is NULL. Note, this is necessary only
1449: -- the parent process, ie p_mode = 'INIT'
1450: -- --------------------------------------------
1451: FII_AR_TRX_DIST_F_C.g_push_from_date := nvl(l_from_date,
1452: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
1453: EDW_COLLECTION_UTIL.g_offset);
1454:
1455: FII_AR_TRX_DIST_F_C.g_push_to_date := nvl(l_to_date,
1456: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

Line 1453: EDW_COLLECTION_UTIL.g_offset);

1449: -- the parent process, ie p_mode = 'INIT'
1450: -- --------------------------------------------
1451: FII_AR_TRX_DIST_F_C.g_push_from_date := nvl(l_from_date,
1452: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
1453: EDW_COLLECTION_UTIL.g_offset);
1454:
1455: FII_AR_TRX_DIST_F_C.g_push_to_date := nvl(l_to_date,
1456: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
1457:

Line 1456: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

1452: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
1453: EDW_COLLECTION_UTIL.g_offset);
1454:
1455: FII_AR_TRX_DIST_F_C.g_push_to_date := nvl(l_to_date,
1456: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
1457:
1458: if g_debug_flag = 'Y' then
1459: edw_log.put_line( 'The collection range is from '||
1460: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||

Line 1765: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg, g_push_from_date, g_push_to_date);

1761: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1762: ' rows into the staging table');
1763: edw_log.put_line(' ');
1764: end if;
1765: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg, g_push_from_date, g_push_to_date);
1766:
1767:
1768: ELSIF (p_mode = 'AR') THEN
1769:

Line 2133: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);

2129: end if;
2130: /* Added the if condition. Wrapup should only be called by the
2131: main process not by the child processes. Bug#3077413 */
2132: if ( p_mode='INIT' ) then
2133: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);
2134: else
2135: edw_log.put_line('Failure occurred in mode : '||p_mode);
2136: end if;
2137:

Line 2152: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);

2148: end if;
2149: /* Added the if condition. Wrapup should only be called by the
2150: main process not by the child processes. Bug#3077413 */
2151: if ( p_mode='INIT' ) then
2152: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);
2153: else
2154: edw_log.put_line('Failure occurred in mode : '||p_mode);
2155: end if;
2156: /* Set the completion status to error. bug#3207823 */

Line 2174: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);

2170: end if;
2171: /* Added the if condition. Wrapup should only be called by the
2172: main process not by the child processes. Bug#3077413 */
2173: if ( p_mode='INIT' ) then
2174: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);
2175: else
2176: edw_log.put_line('Failure occurred in mode : '||p_mode);
2177: end if;
2178: /* Set the completion status to error. bug#3207823 */

Line 2194: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);

2190: end if;
2191: /* Added the if condition. Wrapup should only be called by the
2192: main process not by the child processes. Bug#3077413 */
2193: if ( p_mode='INIT' ) then
2194: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);
2195: else
2196: edw_log.put_line('Failure occurred in mode : '||p_mode);
2197: end if;
2198: /* Set the completion status to error. bug#3207823 */

Line 2215: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);

2211: end if;
2212: /* Added the if condition. Wrapup should only be called by the
2213: main process not by the child processes. Bug#3077413 */
2214: if ( p_mode='INIT' ) then
2215: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);
2216: else
2217: edw_log.put_line('Failure occurred in mode : '||p_mode);
2218: end if;
2219: /* Set the completion status to error. bug#3207823 */

Line 2239: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);

2235: end if;
2236: /* Added the if condition. Wrapup should only be called by the
2237: main process not by the child processes. Bug#3077413 */
2238: if ( p_mode='INIT' ) then
2239: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);
2240: else
2241: edw_log.put_line('Failure occurred in mode : '||p_mode);
2242: end if;
2243: /* Set the completion status to error. bug#3207823 */

Line 2258: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);

2254: end if;
2255: /* Added the if condition. Wrapup should only be called by the
2256: main process not by the child processes. Bug#3077413 */
2257: if ( p_mode='INIT' ) then
2258: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);
2259: else
2260: edw_log.put_line('Failure occurred in mode : '||p_mode);
2261: end if;
2262: /* Set the completion status to error. bug#3207823 */

Line 2284: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);

2280: end if;
2281: /* Added the if condition. Wrapup should only be called by the
2282: main process not by the child processes. Bug#3077413 */
2283: if ( p_mode='INIT' ) then
2284: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_from_date, g_push_to_date);
2285: else
2286: edw_log.put_line('Failure occurred in mode : '||p_mode);
2287: end if;
2288: /* Set the completion status to error. bug#3207823 */