DBA Data[Home] [Help]

APPS.OE_GLOBALS dependencies on OE_DEBUG_PUB

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

15: PROCEDURE Get_Entities_Tbl
16: IS
17: I NUMBER:=0;
18: --
19: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
20: --
21: BEGIN
22:
23: FND_API.g_entity_tbl.DELETE;

Line 247: IF oe_debug_pub.g_debug_level > 0 THEN

243: IF NOT (( p_attribute1 IS NULL AND p_attribute2 IS NULL ) OR
244: ( p_attribute1 IS NOT NULL AND
245: p_attribute2 IS NOT NULL AND
246: p_attribute1 = p_attribute2 )) THEN
247: IF oe_debug_pub.g_debug_level > 0 THEN
248: oe_debug_pub.add( 'LOCK COMPARISON FAILED: '|| G_LOCK_CONST , 1 ) ;
249: END IF;
250: END IF;
251: RETURN TRUE;

Line 248: oe_debug_pub.add( 'LOCK COMPARISON FAILED: '|| G_LOCK_CONST , 1 ) ;

244: ( p_attribute1 IS NOT NULL AND
245: p_attribute2 IS NOT NULL AND
246: p_attribute1 = p_attribute2 )) THEN
247: IF oe_debug_pub.g_debug_level > 0 THEN
248: oe_debug_pub.add( 'LOCK COMPARISON FAILED: '|| G_LOCK_CONST , 1 ) ;
249: END IF;
250: END IF;
251: RETURN TRUE;
252:

Line 287: IF oe_debug_pub.g_debug_level > 0 THEN

283: IF NOT (( p_attribute1 IS NULL AND p_attribute2 IS NULL ) OR
284: ( p_attribute1 IS NOT NULL AND
285: p_attribute2 IS NOT NULL AND
286: p_attribute1 = p_attribute2 )) THEN
287: IF oe_debug_pub.g_debug_level > 0 THEN
288: oe_debug_pub.add( 'LOCK COMPARISON FAILED: '|| G_LOCK_CONST , 1 ) ;
289: END IF;
290: END IF;
291: RETURN TRUE;

Line 288: oe_debug_pub.add( 'LOCK COMPARISON FAILED: '|| G_LOCK_CONST , 1 ) ;

284: ( p_attribute1 IS NOT NULL AND
285: p_attribute2 IS NOT NULL AND
286: p_attribute1 = p_attribute2 )) THEN
287: IF oe_debug_pub.g_debug_level > 0 THEN
288: oe_debug_pub.add( 'LOCK COMPARISON FAILED: '|| G_LOCK_CONST , 1 ) ;
289: END IF;
290: END IF;
291: RETURN TRUE;
292:

Line 327: IF oe_debug_pub.g_debug_level > 0 THEN

323: IF NOT (( p_attribute1 IS NULL AND p_attribute2 IS NULL ) OR
324: ( p_attribute1 IS NOT NULL AND
325: p_attribute2 IS NOT NULL AND
326: p_attribute1 = p_attribute2 )) THEN
327: IF oe_debug_pub.g_debug_level > 0 THEN
328: oe_debug_pub.add( 'LOCK COMPARISON FAILED: '|| G_LOCK_CONST , 1 ) ;
329: END IF;
330: END IF;
331: RETURN TRUE;

Line 328: oe_debug_pub.add( 'LOCK COMPARISON FAILED: '|| G_LOCK_CONST , 1 ) ;

324: ( p_attribute1 IS NOT NULL AND
325: p_attribute2 IS NOT NULL AND
326: p_attribute1 = p_attribute2 )) THEN
327: IF oe_debug_pub.g_debug_level > 0 THEN
328: oe_debug_pub.add( 'LOCK COMPARISON FAILED: '|| G_LOCK_CONST , 1 ) ;
329: END IF;
330: END IF;
331: RETURN TRUE;
332:

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

351: PROCEDURE Set_Context IS
352: l_org_id NUMBER;
353:
354: --
355: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
356: --
357: BEGIN
358:
359: /*SELECT NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,

Line 371: OE_DEBUG_PUB.ADD('OEXSGLBB.pls- Org ID could not be fetched from MO API',5);

367: IF l_org_id IS NOT NULL THEN
368: OE_GLOBALS.G_ORG_ID := l_org_id;
369: ELSE
370: IF l_debug_level > 0 THEN
371: OE_DEBUG_PUB.ADD('OEXSGLBB.pls- Org ID could not be fetched from MO API',5);
372: END IF;
373: fnd_message.set_name('FND', 'MO_ORG_REQUIRED');
374: OE_MSG_PUB.ADD;
375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

392: l_industry VARCHAR2(1);
393: l_return_val VARCHAR2(1);
394:
395: --
396: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
397: --
398: BEGIN
399:
400: IF (fnd_installation.get(p_application_id,p_application_id

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

425: l_default_appl_id NUMBER := 660;
426: l_appl_id NUMBER;
427:
428: --
429: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
430: --
431: BEGIN
432:
433: SELECT APPLICATION_ID

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

465: l_hash1_old VARCHAR2(30);
466: l_hash2_old VARCHAR2(30);
467: l_hash1_new VARCHAR2(30);
468: l_hash2_new VARCHAR2(30);
469: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
470:
471: BEGIN
472:
473: IF l_debug_level > 0 THEN

Line 474: oe_debug_pub.add('Entering Is_Same_Credit_Card Function...');

470:
471: BEGIN
472:
473: IF l_debug_level > 0 THEN
474: oe_debug_pub.add('Entering Is_Same_Credit_Card Function...');
475: oe_debug_pub.add('Old card number'||p_cc_num_old);
476: oe_debug_pub.add('New card number'||p_cc_num_new);
477: oe_debug_pub.add('Old instrument id'||p_instrument_id_old);
478: oe_debug_pub.add('New instrument id2'||p_instrument_id_new);

Line 475: oe_debug_pub.add('Old card number'||p_cc_num_old);

471: BEGIN
472:
473: IF l_debug_level > 0 THEN
474: oe_debug_pub.add('Entering Is_Same_Credit_Card Function...');
475: oe_debug_pub.add('Old card number'||p_cc_num_old);
476: oe_debug_pub.add('New card number'||p_cc_num_new);
477: oe_debug_pub.add('Old instrument id'||p_instrument_id_old);
478: oe_debug_pub.add('New instrument id2'||p_instrument_id_new);
479: END IF;

Line 476: oe_debug_pub.add('New card number'||p_cc_num_new);

472:
473: IF l_debug_level > 0 THEN
474: oe_debug_pub.add('Entering Is_Same_Credit_Card Function...');
475: oe_debug_pub.add('Old card number'||p_cc_num_old);
476: oe_debug_pub.add('New card number'||p_cc_num_new);
477: oe_debug_pub.add('Old instrument id'||p_instrument_id_old);
478: oe_debug_pub.add('New instrument id2'||p_instrument_id_new);
479: END IF;
480:

Line 477: oe_debug_pub.add('Old instrument id'||p_instrument_id_old);

473: IF l_debug_level > 0 THEN
474: oe_debug_pub.add('Entering Is_Same_Credit_Card Function...');
475: oe_debug_pub.add('Old card number'||p_cc_num_old);
476: oe_debug_pub.add('New card number'||p_cc_num_new);
477: oe_debug_pub.add('Old instrument id'||p_instrument_id_old);
478: oe_debug_pub.add('New instrument id2'||p_instrument_id_new);
479: END IF;
480:
481: IF p_instrument_id_old IS NOT NULL AND p_instrument_id_new IS NOT NULL THEN

Line 478: oe_debug_pub.add('New instrument id2'||p_instrument_id_new);

474: oe_debug_pub.add('Entering Is_Same_Credit_Card Function...');
475: oe_debug_pub.add('Old card number'||p_cc_num_old);
476: oe_debug_pub.add('New card number'||p_cc_num_new);
477: oe_debug_pub.add('Old instrument id'||p_instrument_id_old);
478: oe_debug_pub.add('New instrument id2'||p_instrument_id_new);
479: END IF;
480:
481: IF p_instrument_id_old IS NOT NULL AND p_instrument_id_new IS NOT NULL THEN
482: