APPS.AP_SUPPLIER_INFO_PKG dependencies on FND_LOG

Line 6: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2: /* $Header: apsupinfb.pls 120.1.12010000.3 2008/11/18 10:49:48 anarun noship $ */
3: ------------------------------------------------------------------------------
4: -- Global Variables --
5: ------------------------------------------------------------------------------
6: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
8: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP_SUPPLIER_INFO_PKG';
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10:

Line 7: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

3: ------------------------------------------------------------------------------
4: -- Global Variables --
5: ------------------------------------------------------------------------------
6: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
8: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP_SUPPLIER_INFO_PKG';
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10:
11: -- Procedure Definitions

Line 9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

5: ------------------------------------------------------------------------------
6: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
8: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP_SUPPLIER_INFO_PKG';
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10:
11: -- Procedure Definitions
12:
13: ------------------------------------------------------------------------------

Line 93: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_api_name,

89: || to_char(i_vendor_id) || ', i_vendor_site_id = '
90: || to_char(i_vendor_site_id) || ', i_vendor_contact_id = '
91: || to_char(i_vendor_contact_id);
92: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
93: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_api_name,
94: l_debug_info);
95: END IF;
96:
97: /* ========= Validation Check and query string begin ==========

Line 115: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_api_name,

111: IF l_check_vid = 0 THEN
112: o_success := FALSE;
113: l_debug_info := 'Invalid vendor_id';
114: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
115: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_api_name,
116: l_debug_info);
117: END IF;
118: ELSE
119: IF i_vendor_site_id IS NOT NULL THEN

Line 131: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME ||

127: o_success := FALSE;
128: l_debug_info := 'Invalid combination of (vendor_id, '
129: || 'vendor_site_id)';
130: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
131: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME ||
132: l_api_name, l_debug_info);
133: END IF;
134: ELSE
135: l_site_where := l_site_where

Line 153: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME

149: o_success := FALSE;
150: l_debug_info := 'Invalid combination of (vendor_id, '
151: || 'vendor_site_id, vendor_contact_id)';
152: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME
154: || l_api_name, l_debug_info);
155: END IF;
156: ELSE
157: l_contact_where := l_contact_where

Line 175: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME

171: o_success := FALSE;
172: l_debug_info := 'Invalid combination of (vendor_id, '
173: || 'vendor_contact_id)';
174: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
175: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME
176: || l_api_name, l_debug_info);
177: END IF;
178: ELSE
179: l_site_where := l_site_where

Line 201: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_api_name,

197: /* ============ Validation Check and query string end ============= */
198:
199: l_debug_info := 'l_site_where = ' || l_site_where ;
200: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
201: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_api_name,
202: l_debug_info);
203: END IF;
204:
205: l_debug_info := 'l_contact_where = ' || l_contact_where ;

Line 207: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_api_name,

203: END IF;
204:
205: l_debug_info := 'l_contact_where = ' || l_contact_where ;
206: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
207: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_api_name,
208: l_debug_info);
209: END IF;
210:
211: SELECT *

Line 259: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || l_api_name,

255: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
256: END IF;
257:
258: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
259: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || l_api_name,
260: SQLERRM);
261: END IF;
262:
263: APP_EXCEPTION.RAISE_EXCEPTION;

Line 331: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_api_name,

327: l_debug_info := 'Called with parameters : i_from_vendor_id = '
328: || to_char(i_from_vendor_id) || ', i_to_vendor_id = '
329: || to_char(i_to_vendor_id) ;
330: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
331: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_api_name,
332: l_debug_info);
333: END IF;
334:
335: SELECT count(1)

Line 344: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME ||

340: IF l_check_vid = 0 THEN
341: o_success := FALSE;
342: l_debug_info := 'No vendor exists within this range of vendor_id';
343: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
344: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME ||
345: l_api_name, l_debug_info);
346: END IF;
347: ELSE
348: OPEN c_supplier;

Line 416: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || l_api_name,

412: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
413: END IF;
414:
415: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
416: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || l_api_name,
417: SQLERRM);
418: END IF;
419:
420: APP_EXCEPTION.RAISE_EXCEPTION;