eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_MV_REFRESH dependencies on BIS_BIA_RSG_CUSTOM_API_MGMNT

Line 364: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Retrieving Parameters');

360: l_retcode VARCHAR2(50) := '0';
361: l_index_exception EXCEPTION;
362: BEGIN
363:
364: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Retrieving Parameters');
365:
366: l_api_type := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
367: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_API_TYPE);
368: l_mode := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,

Line 366: l_api_type := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,

362: BEGIN
363:
364: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Retrieving Parameters');
365:
366: l_api_type := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
367: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_API_TYPE);
368: l_mode := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
369: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MODE);
370: l_obj_name := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,

Line 367: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_API_TYPE);

363:
364: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Retrieving Parameters');
365:
366: l_api_type := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
367: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_API_TYPE);
368: l_mode := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
369: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MODE);
370: l_obj_name := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
371: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_OBJECT_NAME);

Line 368: l_mode := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,

364: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Retrieving Parameters');
365:
366: l_api_type := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
367: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_API_TYPE);
368: l_mode := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
369: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MODE);
370: l_obj_name := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
371: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_OBJECT_NAME);
372: l_obj_type := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,

Line 369: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MODE);

365:
366: l_api_type := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
367: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_API_TYPE);
368: l_mode := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
369: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MODE);
370: l_obj_name := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
371: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_OBJECT_NAME);
372: l_obj_type := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
373: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_OBJECT_TYPE);

Line 370: l_obj_name := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,

366: l_api_type := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
367: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_API_TYPE);
368: l_mode := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
369: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MODE);
370: l_obj_name := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
371: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_OBJECT_NAME);
372: l_obj_type := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
373: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_OBJECT_TYPE);
374:

Line 371: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_OBJECT_NAME);

367: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_API_TYPE);
368: l_mode := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
369: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MODE);
370: l_obj_name := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
371: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_OBJECT_NAME);
372: l_obj_type := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
373: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_OBJECT_TYPE);
374:
375:

Line 372: l_obj_type := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,

368: l_mode := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
369: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MODE);
370: l_obj_name := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
371: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_OBJECT_NAME);
372: l_obj_type := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
373: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_OBJECT_TYPE);
374:
375:
376: IF l_api_type = BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_INDEX_MGT THEN

Line 373: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_OBJECT_TYPE);

369: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MODE);
370: l_obj_name := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
371: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_OBJECT_NAME);
372: l_obj_type := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
373: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_OBJECT_TYPE);
374:
375:
376: IF l_api_type = BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_INDEX_MGT THEN
377: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('API Type is MV Index Management');

Line 376: IF l_api_type = BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_INDEX_MGT THEN

372: l_obj_type := BIS_BIA_RSG_CUSTOM_API_MGMNT.GET_PARAM(p_param,
373: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_OBJECT_TYPE);
374:
375:
376: IF l_api_type = BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_INDEX_MGT THEN
377: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('API Type is MV Index Management');
378: IF l_mode = BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE THEN
379: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Dropping indexes on object ' || l_obj_name);
380: FII_INDEX_UTIL.Drop_Index(l_obj_name, g_apps_schema_name, l_retcode);

Line 377: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('API Type is MV Index Management');

373: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_OBJECT_TYPE);
374:
375:
376: IF l_api_type = BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_INDEX_MGT THEN
377: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('API Type is MV Index Management');
378: IF l_mode = BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE THEN
379: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Dropping indexes on object ' || l_obj_name);
380: FII_INDEX_UTIL.Drop_Index(l_obj_name, g_apps_schema_name, l_retcode);
381: IF l_retcode <> '0' THEN

Line 378: IF l_mode = BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE THEN

374:
375:
376: IF l_api_type = BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_INDEX_MGT THEN
377: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('API Type is MV Index Management');
378: IF l_mode = BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE THEN
379: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Dropping indexes on object ' || l_obj_name);
380: FII_INDEX_UTIL.Drop_Index(l_obj_name, g_apps_schema_name, l_retcode);
381: IF l_retcode <> '0' THEN
382: RAISE l_index_exception;

Line 379: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Dropping indexes on object ' || l_obj_name);

375:
376: IF l_api_type = BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_INDEX_MGT THEN
377: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('API Type is MV Index Management');
378: IF l_mode = BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE THEN
379: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Dropping indexes on object ' || l_obj_name);
380: FII_INDEX_UTIL.Drop_Index(l_obj_name, g_apps_schema_name, l_retcode);
381: IF l_retcode <> '0' THEN
382: RAISE l_index_exception;
383: END IF;

Line 385: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Recreating indexes on object ' || l_obj_name);

381: IF l_retcode <> '0' THEN
382: RAISE l_index_exception;
383: END IF;
384: ELSE --AFTER Mode
385: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Recreating indexes on object ' || l_obj_name);
386: FII_INDEX_UTIL.Create_Index(l_obj_name, g_apps_schema_name, l_retcode);
387: IF l_retcode <> '0' THEN
388: RAISE l_index_exception;
389: END IF;

Line 391: ELSIF l_api_type = BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_LOG_MGT THEN

387: IF l_retcode <> '0' THEN
388: RAISE l_index_exception;
389: END IF;
390: END IF;
391: ELSIF l_api_type = BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_LOG_MGT THEN
392: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('API Type is MV Log Management');
393: IF l_mode = BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE THEN
394: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Dropping MV Log on object ' || l_obj_name);
395: BIS_BIA_RSG_LOG_MGMNT.base_sum_mlog_capture_and_drop(l_obj_name);

Line 392: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('API Type is MV Log Management');

388: RAISE l_index_exception;
389: END IF;
390: END IF;
391: ELSIF l_api_type = BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_LOG_MGT THEN
392: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('API Type is MV Log Management');
393: IF l_mode = BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE THEN
394: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Dropping MV Log on object ' || l_obj_name);
395: BIS_BIA_RSG_LOG_MGMNT.base_sum_mlog_capture_and_drop(l_obj_name);
396: ELSE --AFTER Mode

Line 393: IF l_mode = BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE THEN

389: END IF;
390: END IF;
391: ELSIF l_api_type = BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_LOG_MGT THEN
392: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('API Type is MV Log Management');
393: IF l_mode = BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE THEN
394: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Dropping MV Log on object ' || l_obj_name);
395: BIS_BIA_RSG_LOG_MGMNT.base_sum_mlog_capture_and_drop(l_obj_name);
396: ELSE --AFTER Mode
397: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Recreating MV Log for object ' || l_obj_name);

Line 394: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Dropping MV Log on object ' || l_obj_name);

390: END IF;
391: ELSIF l_api_type = BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_LOG_MGT THEN
392: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('API Type is MV Log Management');
393: IF l_mode = BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE THEN
394: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Dropping MV Log on object ' || l_obj_name);
395: BIS_BIA_RSG_LOG_MGMNT.base_sum_mlog_capture_and_drop(l_obj_name);
396: ELSE --AFTER Mode
397: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Recreating MV Log for object ' || l_obj_name);
398: BIS_BIA_RSG_LOG_MGMNT.base_sum_mlog_recreate(l_obj_name);

Line 397: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Recreating MV Log for object ' || l_obj_name);

393: IF l_mode = BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE THEN
394: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Dropping MV Log on object ' || l_obj_name);
395: BIS_BIA_RSG_LOG_MGMNT.base_sum_mlog_capture_and_drop(l_obj_name);
396: ELSE --AFTER Mode
397: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Recreating MV Log for object ' || l_obj_name);
398: BIS_BIA_RSG_LOG_MGMNT.base_sum_mlog_recreate(l_obj_name);
399: END IF;
400: ELSE
401: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('API Type is NOT MV Index Management or MV Log Managment');

Line 401: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('API Type is NOT MV Index Management or MV Log Managment');

397: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Recreating MV Log for object ' || l_obj_name);
398: BIS_BIA_RSG_LOG_MGMNT.base_sum_mlog_recreate(l_obj_name);
399: END IF;
400: ELSE
401: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('API Type is NOT MV Index Management or MV Log Managment');
402: END IF;
403:
404: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
405: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,

Line 404: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,

400: ELSE
401: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('API Type is NOT MV Index Management or MV Log Managment');
402: END IF;
403:
404: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
405: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,
406: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_SUCCESS);
407: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
408: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, 'Succeeded');

Line 405: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,

401: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('API Type is NOT MV Index Management or MV Log Managment');
402: END IF;
403:
404: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
405: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,
406: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_SUCCESS);
407: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
408: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, 'Succeeded');
409:

Line 406: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_SUCCESS);

402: END IF;
403:
404: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
405: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,
406: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_SUCCESS);
407: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
408: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, 'Succeeded');
409:
410: EXCEPTION

Line 407: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,

403:
404: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
405: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,
406: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_SUCCESS);
407: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
408: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, 'Succeeded');
409:
410: EXCEPTION
411: WHEN l_index_exception THEN

Line 408: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, 'Succeeded');

404: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
405: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,
406: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_SUCCESS);
407: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
408: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, 'Succeeded');
409:
410: EXCEPTION
411: WHEN l_index_exception THEN
412: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Index Exception in FII_MV_REFRESH.RSG_CALLOUT_API');

Line 412: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Index Exception in FII_MV_REFRESH.RSG_CALLOUT_API');

408: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, 'Succeeded');
409:
410: EXCEPTION
411: WHEN l_index_exception THEN
412: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Index Exception in FII_MV_REFRESH.RSG_CALLOUT_API');
413: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
414: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,
415: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_FAILURE);
416: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,

Line 413: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,

409:
410: EXCEPTION
411: WHEN l_index_exception THEN
412: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Index Exception in FII_MV_REFRESH.RSG_CALLOUT_API');
413: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
414: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,
415: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_FAILURE);
416: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
417: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, sqlerrm);

Line 414: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,

410: EXCEPTION
411: WHEN l_index_exception THEN
412: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Index Exception in FII_MV_REFRESH.RSG_CALLOUT_API');
413: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
414: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,
415: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_FAILURE);
416: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
417: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, sqlerrm);
418: WHEN OTHERS THEN

Line 415: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_FAILURE);

411: WHEN l_index_exception THEN
412: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Index Exception in FII_MV_REFRESH.RSG_CALLOUT_API');
413: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
414: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,
415: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_FAILURE);
416: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
417: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, sqlerrm);
418: WHEN OTHERS THEN
419: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,

Line 416: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,

412: BIS_BIA_RSG_CUSTOM_API_MGMNT.LOG('Index Exception in FII_MV_REFRESH.RSG_CALLOUT_API');
413: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
414: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,
415: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_FAILURE);
416: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
417: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, sqlerrm);
418: WHEN OTHERS THEN
419: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
420: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,

Line 417: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, sqlerrm);

413: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
414: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,
415: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_FAILURE);
416: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
417: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, sqlerrm);
418: WHEN OTHERS THEN
419: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
420: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,
421: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_FAILURE);

Line 419: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,

415: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_FAILURE);
416: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
417: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, sqlerrm);
418: WHEN OTHERS THEN
419: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
420: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,
421: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_FAILURE);
422: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
423: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, sqlerrm);

Line 420: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,

416: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
417: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, sqlerrm);
418: WHEN OTHERS THEN
419: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
420: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,
421: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_FAILURE);
422: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
423: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, sqlerrm);
424: END RSG_CALLOUT_API;

Line 421: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_FAILURE);

417: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, sqlerrm);
418: WHEN OTHERS THEN
419: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
420: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,
421: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_FAILURE);
422: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
423: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, sqlerrm);
424: END RSG_CALLOUT_API;
425:

Line 422: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,

418: WHEN OTHERS THEN
419: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
420: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,
421: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_FAILURE);
422: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
423: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, sqlerrm);
424: END RSG_CALLOUT_API;
425:
426:

Line 423: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, sqlerrm);

419: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
420: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_COMPLETE_STATUS,
421: BIS_BIA_RSG_CUSTOM_API_MGMNT.STATUS_FAILURE);
422: BIS_BIA_RSG_CUSTOM_API_MGMNT.SET_PARAM(p_param,
423: BIS_BIA_RSG_CUSTOM_API_MGMNT.PARA_MESSAGE, sqlerrm);
424: END RSG_CALLOUT_API;
425:
426:
427: END FII_MV_REFRESH;