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_CNCL_VALUE_TO_ID dependencies on OE_DEBUG_PUB

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

22: IS
23: l_id NUMBER;
24: l_segment_array FND_FLEX_EXT.SegmentArray;
25: --
26: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
27: --
28: BEGIN
29:
30: IF l_debug_level > 0 THEN

Line 31: oe_debug_pub.add( 'ENTERING OE_CNCL_VALUE_TO_ID.KEY_FLEX' , 1 ) ;

27: --
28: BEGIN
29:
30: IF l_debug_level > 0 THEN
31: oe_debug_pub.add( 'ENTERING OE_CNCL_VALUE_TO_ID.KEY_FLEX' , 1 ) ;
32: END IF;
33: l_segment_array := p_segment_array;
34:
35: -- Convert any missing values to NULL

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

382: --AND STATUS = 'A';
383:
384: l_org varchar2(100);
385: --
386: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
387: --
388: BEGIN
389:
390: IF nvl( p_deliver_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char

Line 403: oe_debug_pub.add( 'CUSTOMER RELATIONS='||LCUSTOMER_RELATIONS ) ;

399:
400:
401: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
402: IF l_debug_level > 0 THEN
403: oe_debug_pub.add( 'CUSTOMER RELATIONS='||LCUSTOMER_RELATIONS ) ;
404: END IF;
405:
406: IF lcustomer_relations = 'N' THEN
407:

Line 444: oe_debug_pub.add( 'FOUND' ) ;

440: INTO l_id;
441:
442: IF C1%FOUND then
443: IF l_debug_level > 0 THEN
444: oe_debug_pub.add( 'FOUND' ) ;
445: END IF;
446: CLOSE C1;
447: return l_id;
448: ELSE

Line 450: oe_debug_pub.add( 'NOT FOUND' ) ;

446: CLOSE C1;
447: return l_id;
448: ELSE
449: IF l_debug_level > 0 THEN
450: oe_debug_pub.add( 'NOT FOUND' ) ;
451: END IF;
452: -- select userenv('CLIENT_INFO') into l_org from dual;
453: l_org := MO_GLOBAL.Get_Current_Org_Id; --moac
454: IF l_debug_level > 0 THEN

Line 455: oe_debug_pub.add( 'ORG='||L_ORG ) ;

451: END IF;
452: -- select userenv('CLIENT_INFO') into l_org from dual;
453: l_org := MO_GLOBAL.Get_Current_Org_Id; --moac
454: IF l_debug_level > 0 THEN
455: oe_debug_pub.add( 'ORG='||L_ORG ) ;
456: END IF;
457:
458: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
459: INTO l_id

Line 480: oe_debug_pub.add( 'AFTER SELECT FOUND='||L_ID ) ;

476: HZ_CUST_ACCT_RELATE WHERE
477: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
478: and ship_to_flag = 'Y');
479: IF l_debug_level > 0 THEN
480: oe_debug_pub.add( 'AFTER SELECT FOUND='||L_ID ) ;
481: END IF;
482: END IF;
483:
484: CLOSE C1;

Line 486: oe_debug_pub.add( 'RETURNING FROM THE FUNCTION' ) ;

482: END IF;
483:
484: CLOSE C1;
485: IF l_debug_level > 0 THEN
486: oe_debug_pub.add( 'RETURNING FROM THE FUNCTION' ) ;
487: END IF;
488: RETURN l_id;
489:
490:

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

1058: AND nvl(COUNTRY,fnd_api.g_miss_char) =
1059: nvl( p_invoice_to_country, fnd_api.g_miss_char)
1060: AND STATUS = 'A';
1061: --
1062: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1063: --
1064: BEGIN
1065:
1066: IF l_debug_level > 0 THEN

Line 1067: oe_debug_pub.add( 'INVOICE_TO_ORG VALUES ARE SOLD_TO_ORG_ID='||P_SOLD_TO_ORG_ID||' ADDRESS1='||P_INVOICE_TO_ADDRESS1||' ADDRESS4='||P_INVOICE_TO_ADDRESS4 ) ;

1063: --
1064: BEGIN
1065:
1066: IF l_debug_level > 0 THEN
1067: oe_debug_pub.add( 'INVOICE_TO_ORG VALUES ARE SOLD_TO_ORG_ID='||P_SOLD_TO_ORG_ID||' ADDRESS1='||P_INVOICE_TO_ADDRESS1||' ADDRESS4='||P_INVOICE_TO_ADDRESS4 ) ;
1068: END IF;
1069: IF p_invoice_to_address1 IS NULL
1070: OR p_invoice_to_address2 IS NULL
1071: OR p_invoice_to_address3 IS NULL

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

5344: ) RETURN NUMBER
5345: IS
5346: l_id NUMBER;
5347: --
5348: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5349: --
5350: BEGIN
5351:
5352: IF l_debug_level > 0 THEN

Line 5353: oe_debug_pub.add( 'SOLD_TO_LOCATION_ADDRESS1='||P_SOLD_TO_LOCATION_ADDRESS1||' ADDRESS4='||P_SOLD_TO_LOCATION_ADDRESS4||' sold_to_org_id='||p_sold_to_org_id ) ;

5349: --
5350: BEGIN
5351:
5352: IF l_debug_level > 0 THEN
5353: oe_debug_pub.add( 'SOLD_TO_LOCATION_ADDRESS1='||P_SOLD_TO_LOCATION_ADDRESS1||' ADDRESS4='||P_SOLD_TO_LOCATION_ADDRESS4||' sold_to_org_id='||p_sold_to_org_id ) ;
5354: oe_debug_pub.add( 'SOLD_TO_LOCATION_ADDRESS2='||P_SOLD_TO_LOCATION_ADDRESS2||' ADDRESS3='||P_SOLD_TO_LOCATION_ADDRESS3);
5355: END IF;
5356:
5357: IF nvl( p_sold_to_location_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char

Line 5354: oe_debug_pub.add( 'SOLD_TO_LOCATION_ADDRESS2='||P_SOLD_TO_LOCATION_ADDRESS2||' ADDRESS3='||P_SOLD_TO_LOCATION_ADDRESS3);

5350: BEGIN
5351:
5352: IF l_debug_level > 0 THEN
5353: oe_debug_pub.add( 'SOLD_TO_LOCATION_ADDRESS1='||P_SOLD_TO_LOCATION_ADDRESS1||' ADDRESS4='||P_SOLD_TO_LOCATION_ADDRESS4||' sold_to_org_id='||p_sold_to_org_id ) ;
5354: oe_debug_pub.add( 'SOLD_TO_LOCATION_ADDRESS2='||P_SOLD_TO_LOCATION_ADDRESS2||' ADDRESS3='||P_SOLD_TO_LOCATION_ADDRESS3);
5355: END IF;
5356:
5357: IF nvl( p_sold_to_location_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
5358: AND nvl( p_sold_to_location_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char

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

5431: IS
5432:
5433: l_id NUMBER;
5434: --
5435: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5436:
5437: BEGIN
5438: oe_Debug_pub.add('entereing end customer value to id in cancel order'||p_end_customer||p_end_customer_number);
5439: IF nvl(p_end_customer,fnd_api.g_miss_char) = fnd_api.g_miss_char

Line 5438: oe_Debug_pub.add('entereing end customer value to id in cancel order'||p_end_customer||p_end_customer_number);

5434: --
5435: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5436:
5437: BEGIN
5438: oe_Debug_pub.add('entereing end customer value to id in cancel order'||p_end_customer||p_end_customer_number);
5439: IF nvl(p_end_customer,fnd_api.g_miss_char) = fnd_api.g_miss_char
5440: AND nvl(p_end_customer_number,fnd_api.g_miss_char) = fnd_api.g_miss_char
5441: THEN
5442: RETURN NULL;

Line 5459: oe_Debug_pub.add('End custoemr id is'||l_id);

5455: where Cust_Acct.Party_id = Party.party_id
5456: and Party.Party_name = p_end_customer;
5457:
5458: END IF;
5459: oe_Debug_pub.add('End custoemr id is'||l_id);
5460:
5461: RETURN l_id;
5462:
5463: EXCEPTION

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

5495: , p_end_customer_id IN NUMBER
5496: ) RETURN NUMBER IS
5497:
5498: l_id NUMBER;
5499: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5500: BEGIN
5501:
5502: IF p_end_customer_contact IS NULL
5503: THEN

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

5616:
5617: l_id number;
5618:
5619: --
5620: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5621: BEGIN
5622:
5623: IF l_debug_level > 0 THEN
5624: oe_debug_pub.add(' end customer site address1: '||p_end_customer_site_address1);

Line 5624: oe_debug_pub.add(' end customer site address1: '||p_end_customer_site_address1);

5620: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5621: BEGIN
5622:
5623: IF l_debug_level > 0 THEN
5624: oe_debug_pub.add(' end customer site address1: '||p_end_customer_site_address1);
5625: oe_debug_pub.add(' address4: '||p_end_customer_site_address4);
5626: oe_debug_pub.add(' end_customer_id: '||p_end_customer_id );
5627: END IF;
5628:

Line 5625: oe_debug_pub.add(' address4: '||p_end_customer_site_address4);

5621: BEGIN
5622:
5623: IF l_debug_level > 0 THEN
5624: oe_debug_pub.add(' end customer site address1: '||p_end_customer_site_address1);
5625: oe_debug_pub.add(' address4: '||p_end_customer_site_address4);
5626: oe_debug_pub.add(' end_customer_id: '||p_end_customer_id );
5627: END IF;
5628:
5629: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char

Line 5626: oe_debug_pub.add(' end_customer_id: '||p_end_customer_id );

5622:
5623: IF l_debug_level > 0 THEN
5624: oe_debug_pub.add(' end customer site address1: '||p_end_customer_site_address1);
5625: oe_debug_pub.add(' address4: '||p_end_customer_site_address4);
5626: oe_debug_pub.add(' end_customer_id: '||p_end_customer_id );
5627: END IF;
5628:
5629: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
5630: AND nvl( p_end_customer_site_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char

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

5802: l_lookup_type1 VARCHAR2(80) :='ITEM_OWNER';
5803: l_lookup_type2 VARCHAR2(80) :='ONT_INSTALL_BASE';
5804:
5805: --
5806: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5807: --
5808: BEGIN
5809: oe_Debug_pub.add('owner');
5810: IF p_ib_owner IS NULL

Line 5809: oe_Debug_pub.add('owner');

5805: --
5806: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5807: --
5808: BEGIN
5809: oe_Debug_pub.add('owner');
5810: IF p_ib_owner IS NULL
5811: THEN
5812: RETURN NULL;
5813: END IF;

Line 5820: oe_Debug_pub.add('Code value found is'||l_code);

5816: INTO l_code
5817: FROM OE_LOOKUPS
5818: WHERE MEANING = p_ib_owner
5819: AND LOOKUP_TYPE = l_lookup_type1;-- or LOOKUP_TYPE = l_lookup_type1);
5820: oe_Debug_pub.add('Code value found is'||l_code);
5821: RETURN l_code;
5822:
5823: EXCEPTION
5824:

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

5857: l_lookup_type1 VARCHAR2(80) :='ITEM_INSTALL_LOCATION';
5858: l_lookup_type2 VARCHAR2(80) :='ONT_INSTALL_BASE';
5859:
5860: --
5861: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5862: --
5863: BEGIN
5864:
5865: IF p_ib_installed_at_location IS NULL

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

5912: l_lookup_type1 VARCHAR2(80) :='ITEM_CURRENT_LOCATION';
5913: l_lookup_type2 VARCHAR2(80) :='ONT_INSTALL_BASE';
5914:
5915: --
5916: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5917: --
5918: BEGIN
5919:
5920: IF p_ib_current_location IS NULL