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.OE_BULK_VALUE_TO_ID dependencies on OE_DEBUG_PUB

Line 22: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

18: RETURN NUMBER
19: IS
20: l_id NUMBER;
21: --
22: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
23: --
24: BEGIN
25:
26: SELECT /* MOAC_SQL_CHANGE */ CON.CONTACT_ID

Line 122: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

118:
119: l_id number;
120:
121: --
122: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
123: BEGIN
124:
125: IF l_debug_level > 0 THEN
126: oe_debug_pub.add(' end customer site address1: in HVOP '||p_end_customer_site_address1);

Line 126: oe_debug_pub.add(' end customer site address1: in HVOP '||p_end_customer_site_address1);

122: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
123: BEGIN
124:
125: IF l_debug_level > 0 THEN
126: oe_debug_pub.add(' end customer site address1: in HVOP '||p_end_customer_site_address1);
127: oe_debug_pub.add(' address4: in HVOP '||p_end_customer_site_address4);
128: oe_debug_pub.add(' end_customer_id:in HVOP '||p_end_customer_id );
129: END IF;
130:

Line 127: oe_debug_pub.add(' address4: in HVOP '||p_end_customer_site_address4);

123: BEGIN
124:
125: IF l_debug_level > 0 THEN
126: oe_debug_pub.add(' end customer site address1: in HVOP '||p_end_customer_site_address1);
127: oe_debug_pub.add(' address4: in HVOP '||p_end_customer_site_address4);
128: oe_debug_pub.add(' end_customer_id:in HVOP '||p_end_customer_id );
129: END IF;
130:
131: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char

Line 128: oe_debug_pub.add(' end_customer_id:in HVOP '||p_end_customer_id );

124:
125: IF l_debug_level > 0 THEN
126: oe_debug_pub.add(' end customer site address1: in HVOP '||p_end_customer_site_address1);
127: oe_debug_pub.add(' address4: in HVOP '||p_end_customer_site_address4);
128: oe_debug_pub.add(' end_customer_id:in HVOP '||p_end_customer_id );
129: END IF;
130:
131: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
132: AND nvl( p_end_customer_site_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char

Line 155: oe_Debug_pub.add(' q1');

151: CLOSE c_site_use_id;
152: return l_id;
153: ELSE
154: CLOSE c_site_use_id;
155: oe_Debug_pub.add(' q1');
156: OPEN c_site_use_id2(p_end_customer_id,'SOLD_TO');
157: FETCH c_site_use_id2
158: INTO l_id;
159: IF c_site_use_id2%FOUND then

Line 308: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

304: , p_end_customer_id IN NUMBER
305: ) RETURN NUMBER IS
306:
307: l_id NUMBER;
308: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
309: BEGIN
310:
311: IF p_end_customer_contact IS NULL
312: THEN

Line 366: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

362:
363: PROCEDURE Headers(p_batch_id IN NUMBER)
364: IS
365: --
366: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
367:
368: --bug 5620045
369: subqry_too_many_rows Exception;
370: PRAGMA EXCEPTION_INIT(subqry_too_many_rows, -01427);

Line 1139: -- OE_debug_pub.add('talking from value to id success');

1135: AND c.IB_CURRENT_LOCATION_CODE IS NULL
1136: AND c.IB_CURRENT_LOCATION IS NOT NULL;
1137:
1138:
1139: -- OE_debug_pub.add('talking from value to id success');
1140:
1141: END IF;
1142:
1143: -- SHIP_FROM_ORG_ID: No Value to ID conversion in OEXSVIDB.pls!

Line 1156: oe_debug_pub.add( 'OTHERS ERROR , OE_BULK_VALUE_TO_ID.HEADERS' ) ;

1152:
1153: EXCEPTION
1154: WHEN OTHERS THEN
1155: IF l_debug_level > 0 THEN
1156: oe_debug_pub.add( 'OTHERS ERROR , OE_BULK_VALUE_TO_ID.HEADERS' ) ;
1157: END IF;
1158: IF l_debug_level > 0 THEN
1159: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
1160: END IF;

Line 1159: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

1155: IF l_debug_level > 0 THEN
1156: oe_debug_pub.add( 'OTHERS ERROR , OE_BULK_VALUE_TO_ID.HEADERS' ) ;
1157: END IF;
1158: IF l_debug_level > 0 THEN
1159: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
1160: END IF;
1161: OE_BULK_MSG_PUB.Add_Exc_Msg
1162: ( G_PKG_NAME
1163: , 'Headers'

Line 1180: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1176:
1177: PROCEDURE Lines(p_batch_id IN NUMBER)
1178: IS
1179: --
1180: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1181:
1182: --bug 5620045
1183: subqry_too_many_rows Exception;
1184: PRAGMA EXCEPTION_INIT(subqry_too_many_rows, -01427);

Line 1959: oe_debug_pub.add( 'OTHERS ERROR , OE_BULK_VALUE_TO_ID.LINES' ) ;

1955:
1956: EXCEPTION
1957: WHEN OTHERS THEN
1958: IF l_debug_level > 0 THEN
1959: oe_debug_pub.add( 'OTHERS ERROR , OE_BULK_VALUE_TO_ID.LINES' ) ;
1960: END IF;
1961: IF l_debug_level > 0 THEN
1962: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
1963: END IF;

Line 1962: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

1958: IF l_debug_level > 0 THEN
1959: oe_debug_pub.add( 'OTHERS ERROR , OE_BULK_VALUE_TO_ID.LINES' ) ;
1960: END IF;
1961: IF l_debug_level > 0 THEN
1962: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
1963: END IF;
1964: OE_BULK_MSG_PUB.Add_Exc_Msg
1965: ( G_PKG_NAME
1966: , 'Lines'

Line 1984: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1980: PROCEDURE Adjustments(p_batch_id IN NUMBER)
1981: IS
1982: l_msg_text VARCHAR2(2000);
1983: --
1984: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1985: --
1986: BEGIN
1987:
1988: -- Value to ID conversions for adjustments

Line 2056: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

2052: IF OE_Bulk_Validate.g_error_count = 0 THEN
2053: IF SQL%ROWCOUNT > 0 THEN
2054: OE_Bulk_Validate.g_error_count := 1;
2055: IF l_debug_level > 0 THEN
2056: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
2057: END IF;
2058: END IF;
2059: END IF;
2060:

Line 2064: oe_debug_pub.add( 'OTHERS ERROR , OE_BULK_VALUE_TO_ID.ADJUSTMENTS' ) ;

2060:
2061: EXCEPTION
2062: WHEN OTHERS THEN
2063: IF l_debug_level > 0 THEN
2064: oe_debug_pub.add( 'OTHERS ERROR , OE_BULK_VALUE_TO_ID.ADJUSTMENTS' ) ;
2065: END IF;
2066: IF l_debug_level > 0 THEN
2067: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
2068: END IF;

Line 2067: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

2063: IF l_debug_level > 0 THEN
2064: oe_debug_pub.add( 'OTHERS ERROR , OE_BULK_VALUE_TO_ID.ADJUSTMENTS' ) ;
2065: END IF;
2066: IF l_debug_level > 0 THEN
2067: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
2068: END IF;
2069: OE_BULK_MSG_PUB.Add_Exc_Msg
2070: ( G_PKG_NAME
2071: , 'Adjustments'

Line 2124: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2120: l_substr VARCHAR2(3);
2121: l_msg_text VARCHAR2(2000);
2122: l_msg_data VARCHAR2(2000);
2123: --
2124: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2125: --
2126: BEGIN
2127:
2128: l_msg_data := FND_MESSAGE.GET_STRING('ONT','OE_BULK_VALUE_TO_ID_ERROR');

Line 2133: oe_debug_pub.add( 'ATTR STATUS :'||L_ERR.ATTRIBUTE_STATUS ) ;

2129:
2130: FOR l_err in C_ERR LOOP
2131:
2132: IF l_debug_level > 0 THEN
2133: oe_debug_pub.add( 'ATTR STATUS :'||L_ERR.ATTRIBUTE_STATUS ) ;
2134: END IF;
2135: l_counter := LENGTH(l_err.attribute_status)/3;
2136: IF l_counter < 1 THEN
2137: GOTO END_OF_LOOP;

Line 2239: oe_debug_pub.add( 'OTHERS ERROR , OE_BULK_VALUE_TO_ID.INSERT_ERROR_MESSAGES' ) ;

2235:
2236: EXCEPTION
2237: WHEN OTHERS THEN
2238: IF l_debug_level > 0 THEN
2239: oe_debug_pub.add( 'OTHERS ERROR , OE_BULK_VALUE_TO_ID.INSERT_ERROR_MESSAGES' ) ;
2240: END IF;
2241: IF l_debug_level > 0 THEN
2242: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
2243: END IF;

Line 2242: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

2238: IF l_debug_level > 0 THEN
2239: oe_debug_pub.add( 'OTHERS ERROR , OE_BULK_VALUE_TO_ID.INSERT_ERROR_MESSAGES' ) ;
2240: END IF;
2241: IF l_debug_level > 0 THEN
2242: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
2243: END IF;
2244: OE_BULK_MSG_PUB.Add_Exc_Msg
2245: ( G_PKG_NAME
2246: , 'INSERT_ERROR_MESSAGES'