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.EDW_COLLECTION_UTIL dependencies on GLOBAL_NAME

Line 1553: /* l_stmt := ' ALTER SESSION SET global_names = false';

1549: BEGIN
1550: put_debug_msg ('********** Start Function : get_last_push_date');
1551:
1552:
1553: /* l_stmt := ' ALTER SESSION SET global_names = false';
1554: l_cid := DBMS_SQL.OPEN_CURSOR;
1555: DBMS_SQL.PARSE(l_cid, l_stmt, DBMS_SQL.NATIVE);
1556: l_dummy := DBMS_SQL.EXECUTE(l_cid);
1557: DBMS_SQL.CLOSE_CURSOR(l_cid); */

Line 1602: CURSOR c_global_names_opt

1598: x_source_link OUT NOCOPY VARCHAR2,
1599: x_target_link OUT NOCOPY VARCHAR2
1600: )
1601: IS
1602: CURSOR c_global_names_opt
1603: IS
1604: SELECT param.VALUE
1605: FROM v$parameter param
1606: WHERE param.NAME = 'global_names';

Line 1606: WHERE param.NAME = 'global_names';

1602: CURSOR c_global_names_opt
1603: IS
1604: SELECT param.VALUE
1605: FROM v$parameter param
1606: WHERE param.NAME = 'global_names';
1607:
1608: CURSOR c_global_names_val
1609: IS
1610: SELECT GLOBAL_NAME val

Line 1608: CURSOR c_global_names_val

1604: SELECT param.VALUE
1605: FROM v$parameter param
1606: WHERE param.NAME = 'global_names';
1607:
1608: CURSOR c_global_names_val
1609: IS
1610: SELECT GLOBAL_NAME val
1611: FROM GLOBAL_NAME;
1612:

Line 1610: SELECT GLOBAL_NAME val

1606: WHERE param.NAME = 'global_names';
1607:
1608: CURSOR c_global_names_val
1609: IS
1610: SELECT GLOBAL_NAME val
1611: FROM GLOBAL_NAME;
1612:
1613: l_gname_set v$parameter.VALUE%TYPE;
1614: l_gname_val GLOBAL_NAME.GLOBAL_NAME%TYPE;

Line 1611: FROM GLOBAL_NAME;

1607:
1608: CURSOR c_global_names_val
1609: IS
1610: SELECT GLOBAL_NAME val
1611: FROM GLOBAL_NAME;
1612:
1613: l_gname_set v$parameter.VALUE%TYPE;
1614: l_gname_val GLOBAL_NAME.GLOBAL_NAME%TYPE;
1615: l_source_link VARCHAR2 (128);

Line 1614: l_gname_val GLOBAL_NAME.GLOBAL_NAME%TYPE;

1610: SELECT GLOBAL_NAME val
1611: FROM GLOBAL_NAME;
1612:
1613: l_gname_set v$parameter.VALUE%TYPE;
1614: l_gname_val GLOBAL_NAME.GLOBAL_NAME%TYPE;
1615: l_source_link VARCHAR2 (128);
1616: l_target_link VARCHAR2 (128);
1617: BEGIN
1618: put_debug_msg ('********** Start Procedure : get_dblink_names');

Line 1620: OPEN c_global_names_opt;

1616: l_target_link VARCHAR2 (128);
1617: BEGIN
1618: put_debug_msg ('********** Start Procedure : get_dblink_names');
1619: put_debug_msg ('Profile Options EDW_APPS_TO_APPS and EDW_APPS_TO_WH');
1620: OPEN c_global_names_opt;
1621: FETCH c_global_names_opt INTO l_gname_set;
1622: CLOSE c_global_names_opt;
1623: l_source_link := fnd_profile.VALUE ('EDW_APPS_TO_APPS');
1624: l_target_link := fnd_profile.VALUE ('EDW_APPS_TO_WH');

Line 1621: FETCH c_global_names_opt INTO l_gname_set;

1617: BEGIN
1618: put_debug_msg ('********** Start Procedure : get_dblink_names');
1619: put_debug_msg ('Profile Options EDW_APPS_TO_APPS and EDW_APPS_TO_WH');
1620: OPEN c_global_names_opt;
1621: FETCH c_global_names_opt INTO l_gname_set;
1622: CLOSE c_global_names_opt;
1623: l_source_link := fnd_profile.VALUE ('EDW_APPS_TO_APPS');
1624: l_target_link := fnd_profile.VALUE ('EDW_APPS_TO_WH');
1625:

Line 1622: CLOSE c_global_names_opt;

1618: put_debug_msg ('********** Start Procedure : get_dblink_names');
1619: put_debug_msg ('Profile Options EDW_APPS_TO_APPS and EDW_APPS_TO_WH');
1620: OPEN c_global_names_opt;
1621: FETCH c_global_names_opt INTO l_gname_set;
1622: CLOSE c_global_names_opt;
1623: l_source_link := fnd_profile.VALUE ('EDW_APPS_TO_APPS');
1624: l_target_link := fnd_profile.VALUE ('EDW_APPS_TO_WH');
1625:
1626: IF l_gname_set = 'TRUE'

Line 1628: OPEN c_global_names_val;

1624: l_target_link := fnd_profile.VALUE ('EDW_APPS_TO_WH');
1625:
1626: IF l_gname_set = 'TRUE'
1627: THEN
1628: OPEN c_global_names_val;
1629: FETCH c_global_names_val INTO l_gname_val;
1630: CLOSE c_global_names_val;
1631: put_debug_msg ('l_source_link='||l_source_link);
1632: put_debug_msg ('l_target_link='||l_target_link);

Line 1629: FETCH c_global_names_val INTO l_gname_val;

1625:
1626: IF l_gname_set = 'TRUE'
1627: THEN
1628: OPEN c_global_names_val;
1629: FETCH c_global_names_val INTO l_gname_val;
1630: CLOSE c_global_names_val;
1631: put_debug_msg ('l_source_link='||l_source_link);
1632: put_debug_msg ('l_target_link='||l_target_link);
1633: put_debug_msg ('l_gname_val='||l_gname_val);

Line 1630: CLOSE c_global_names_val;

1626: IF l_gname_set = 'TRUE'
1627: THEN
1628: OPEN c_global_names_val;
1629: FETCH c_global_names_val INTO l_gname_val;
1630: CLOSE c_global_names_val;
1631: put_debug_msg ('l_source_link='||l_source_link);
1632: put_debug_msg ('l_target_link='||l_target_link);
1633: put_debug_msg ('l_gname_val='||l_gname_val);
1634: --bug 3358820

Line 1669: 'GLOBAL NAMES option is enabled.

1665: EXCEPTION
1666: WHEN g_push_remote_failure
1667: THEN
1668: g_errbuf :=
1669: 'GLOBAL NAMES option is enabled.
1670: Database Link Names are not set corretly in Application Profile Option.
1671: EDW: Loop back link name is'
1672: || l_source_link
1673: || '. '

Line 1676: || '. Database Global Name is '

1672: || l_source_link
1673: || '. '
1674: || 'EDW: Runtime link name is '
1675: || l_target_link
1676: || '. Database Global Name is '
1677: || l_gname_val;
1678: g_retcode := 'EDW: ';
1679: edw_log.put_line ( 'error '
1680: || g_retcode