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 473: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

469: l_hash1_new iby_creditcard.cc_number_hash1%TYPE;
470: l_hash2_new iby_creditcard.cc_number_hash2%TYPE;
471: --12586362
472:
473: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
474:
475: BEGIN
476:
477: IF l_debug_level > 0 THEN

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

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

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

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

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

476:
477: IF l_debug_level > 0 THEN
478: oe_debug_pub.add('Entering Is_Same_Credit_Card Function...');
479: --oe_debug_pub.add('Old card number'||p_cc_num_old);
480: --oe_debug_pub.add('New card number'||p_cc_num_new);
481: oe_debug_pub.add('Old instrument id'||p_instrument_id_old);
482: oe_debug_pub.add('New instrument id2'||p_instrument_id_new);
483: END IF;
484:

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

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

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

478: oe_debug_pub.add('Entering Is_Same_Credit_Card Function...');
479: --oe_debug_pub.add('Old card number'||p_cc_num_old);
480: --oe_debug_pub.add('New card number'||p_cc_num_new);
481: oe_debug_pub.add('Old instrument id'||p_instrument_id_old);
482: oe_debug_pub.add('New instrument id2'||p_instrument_id_new);
483: END IF;
484:
485: IF p_instrument_id_old IS NOT NULL AND p_instrument_id_new IS NOT NULL THEN
486: