APPS.WMS_LABEL_FORMATS_PKG dependencies on FND_PROFILE

Line 43: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

39: ) is
40: cursor C is select ROWID from WMS_LABEL_FORMATS
41: where LABEL_FORMAT_ID = X_LABEL_FORMAT_ID
42: ;
43: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
44: begin
45: insert into WMS_LABEL_FORMATS (
46: LABEL_FORMAT_ID,
47: LABEL_FORMAT_NAME ,

Line 181: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

177: where LABEL_FORMAT_ID = X_LABEL_FORMAT_ID
178: for update of LABEL_FORMAT_ID nowait;
179: recinfo c%rowtype;
180:
181: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
182: begin
183: open c;
184: fetch c into recinfo;
185: if (c%notfound) then

Line 278: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

274: X_ATTRIBUTE14 in VARCHAR2,
275: X_ATTRIBUTE15 in VARCHAR2
276: ) is
277: l_msg varchar2(2000);
278: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
279: begin
280: IF (l_debug = 1) THEN
281: INV_LOG_UTIL.trace(' X_LABEL_FORMAT_ID: '||X_LABEL_FORMAT_ID , TRACE_PROMPT, TRACE_LEVEL);
282: END IF;

Line 321: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

317:
318: procedure DELETE_ROW (
319: X_LABEL_FORMAT_ID in NUMBER
320: ) is
321: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
322: begin
323: delete from WMS_LABEL_FORMATS
324: where LABEL_FORMAT_ID = X_LABEL_FORMAT_ID;
325:

Line 334: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

330: end DELETE_ROW;
331:
332: procedure ADD_LANGUAGE
333: is
334: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
335: begin
336: null;
337: end ADD_LANGUAGE;
338:

Line 345: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

341: X_OWNER in VARCHAR2 ,
342: X_LABEL_FORMAT_NAME in VARCHAR2 ,
343: X_FORMAT_DESCRIPTION in VARCHAR2
344: ) IS
345: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
346: BEGIN
347: NULL;
348: END translate_row;
349:

Line 376: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

372: X_ATTRIBUTE14 in VARCHAR2,
373: X_ATTRIBUTE15 in VARCHAR2
374:
375: ) IS
376: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
377: BEGIN
378: DECLARE
379: l_label_format_id NUMBER;
380: l_document_id NUMBER;