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

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

19: and lookup_code = in_lookup_code;
20: l_meaning varchar2(200);
21:
22: --
23: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
24: --
25: BEGIN
26:
27: OPEN c_meaning;

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

138:
139: l_gen_party_number varchar2(1);
140: l_gen_contact_number varchar2(1);
141: --
142: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
143: --
144: BEGIN
145:
146: l_person_rec.person_first_name:=p_contact_first_name;

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

421: l_email hz_parties.email_address%TYPE;
422: l_create_email boolean := FALSE;
423:
424: --
425: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
426: --
427: BEGIN
428:
429:

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

610: l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
611: l_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
612:
613: --
614: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
615: --
616: BEGIN
617:
618: l_contact_points_rec.contact_point_type := in_contact_point_type;

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

756: l_msg_data Varchar2(4000);
757: l_return_status Varchar2(1);
758:
759: --
760: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
761: --
762: BEGIN
763:
764: l_location_rec.country :=p_country;

Line 824: oe_debug_pub.add('Exiting oe_oe_inline_address.create_location', 1);

820: ( p_count => x_msg_count
821: , p_data => x_msg_data
822: );
823:
824: oe_debug_pub.add('Exiting oe_oe_inline_address.create_location', 1);
825:
826: EXCEPTION
827:
828: WHEN FND_API.G_EXC_ERROR THEN

Line 832: oe_debug_pub.add( 'INSIDE CREATE_LOCATION EXC ERROR' , 1 ) ;

828: WHEN FND_API.G_EXC_ERROR THEN
829:
830:
831: IF l_debug_level > 0 THEN
832: oe_debug_pub.add( 'INSIDE CREATE_LOCATION EXC ERROR' , 1 ) ;
833: END IF;
834: x_return_status := FND_API.G_RET_STS_ERROR;
835: OE_MSG_PUB.Count_And_Get
836: ( p_count => x_msg_count

Line 851: oe_debug_pub.add( 'INSIDE CREATE_LOCATION UNEXPECTED ERROR' , 1 ) ;

847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
848:
849:
850: IF l_debug_level > 0 THEN
851: oe_debug_pub.add( 'INSIDE CREATE_LOCATION UNEXPECTED ERROR' , 1 ) ;
852: END IF;
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
854: OE_MSG_PUB.Count_And_Get
855: ( p_count => x_msg_count

Line 870: oe_debug_pub.add( 'INSIDE CREATE_LOCATION WHEN OTHERS' , 1 ) ;

866: WHEN OTHERS THEN
867:
868:
869: IF l_debug_level > 0 THEN
870: oe_debug_pub.add( 'INSIDE CREATE_LOCATION WHEN OTHERS' , 1 ) ;
871: END IF;
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
873: OE_MSG_PUB.Count_And_Get
874: ( p_count => x_msg_count

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

914: tmp_var1 VARCHAR2(2000);
915: x number;
916:
917: --
918: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
919: --
920: BEGIN
921: IF l_debug_level > 0 THEN
922: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER.CREATE_PARTY_SITE' , 1 ) ;

Line 922: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER.CREATE_PARTY_SITE' , 1 ) ;

918: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
919: --
920: BEGIN
921: IF l_debug_level > 0 THEN
922: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER.CREATE_PARTY_SITE' , 1 ) ;
923: END IF;
924: l_party_site_rec.party_id:= p_party_id;
925: l_party_site_rec.location_id:=p_location_id;
926: -- Party Site Number Should be sent only if auto-numbering set off . Add

Line 945: oe_debug_pub.add( 'AFTER CALL HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE'||X_RETURN_STATUS , 1 ) ;

941: x_msg_data => x_msg_data
942: );
943:
944: IF l_debug_level > 0 THEN
945: oe_debug_pub.add( 'AFTER CALL HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE'||X_RETURN_STATUS , 1 ) ;
946: END IF;
947:
948: IF l_debug_level > 0 THEN
949: oe_debug_pub.add( 'AFTER CALL HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE MSG'||X_MSG_DATA , 1 ) ;

Line 949: oe_debug_pub.add( 'AFTER CALL HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE MSG'||X_MSG_DATA , 1 ) ;

945: oe_debug_pub.add( 'AFTER CALL HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE'||X_RETURN_STATUS , 1 ) ;
946: END IF;
947:
948: IF l_debug_level > 0 THEN
949: oe_debug_pub.add( 'AFTER CALL HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE MSG'||X_MSG_DATA , 1 ) ;
950: END IF;
951:
952: IF x_msg_count = 1 THEN
953: --x_msg_data := x_msg_data || '**CREATE_PARTY_SITE**';

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

1068: tmp_var1 VARCHAR2(2000);
1069: x number;
1070:
1071: --
1072: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1073: --
1074: BEGIN
1075:
1076: l_account_site_rec.party_site_id:=p_party_site_id;

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

1242: l_acct_site_uses HZ_CUST_ACCOUNT_SITE_V2PUB.cust_site_use_rec_type;
1243: l_cust_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.customer_profile_rec_type;
1244:
1245: --
1246: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1247: --
1248: BEGIN
1249:
1250: l_acct_site_uses.cust_acct_site_id := p_cust_acct_site_id;

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

1387:
1388: x_profile_id NUMBER;
1389:
1390: --
1391: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1392: --
1393: BEGIN
1394:
1395: l_account_rec.account_number := x_cust_account_number;

Line 1459: oe_debug_pub.add( 'CUSTOMER PERSON TITLE='||P_TITLE ) ;

1455: l_person_rec.tax_reference:=p_tax_reference;
1456: l_person_rec.jgzz_fiscal_code:=p_taxpayer_id;
1457: l_person_rec.person_name_suffix:=p_name_suffix;
1458: IF l_debug_level > 0 THEN
1459: oe_debug_pub.add( 'CUSTOMER PERSON TITLE='||P_TITLE ) ;
1460: END IF;
1461: l_person_rec.person_pre_name_adjunct := p_title;
1462: l_party_rec.party_number := p_party_number;
1463:

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

1540: x_party_id number;
1541: x_party_number hz_parties.party_number%TYPE;
1542:
1543: --
1544: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1545: --
1546: BEGIN
1547:
1548: -- commmented out as it is not used anywhere

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

1567:
1568: l_cust_rel_rec HZ_CUST_ACCOUNT_V2PUB.cust_acct_relate_rec_type;
1569:
1570: --
1571: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1572: --
1573: BEGIN
1574:
1575: l_cust_rel_rec.cust_account_id := p_cust_acct_id;

Line 1590: oe_debug_pub.add('status='||x_return_status||

1586: x_msg_count => x_msg_count,
1587: x_msg_data => x_msg_data
1588: );
1589:
1590: oe_debug_pub.add('status='||x_return_status||
1591: ' msg_count='||x_msg_count||
1592: ' msg_data='||x_msg_data||
1593: ' cust_acct_related_id='||l_cust_rel_rec.related_cust_account_id||
1594: ' cust_acct_id='||l_cust_rel_rec.cust_account_id||

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

1603:
1604: PROCEDURE Commit_Changes IS
1605:
1606: --
1607: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1608: --
1609: BEGIN
1610:
1611: commit;

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

1616:
1617: PROCEDURE Rollback_Changes IS
1618:
1619: --
1620: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1621: --
1622: BEGIN
1623:
1624: Rollback;

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

1645:
1646: l_person_rec HZ_PARTY_V2PUB.person_rec_type;
1647:
1648: --
1649: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1650: --
1651: BEGIN
1652:
1653: l_person_rec.person_first_name:=p_first_name;

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

1686: ) IS
1687: l_organization_rec HZ_PARTY_V2PUB.organization_rec_type;
1688:
1689: --
1690: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1691: --
1692: BEGIN
1693:
1694: l_organization_rec.organization_name:=p_organization_name;

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

1717:
1718: l_role_resp_rec HZ_CUST_ACCOUNT_ROLE_V2PUB.role_responsibility_rec_type;
1719:
1720: --
1721: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1722: --
1723: BEGIN
1724:
1725: l_role_resp_rec.cust_account_role_id := p_cust_acct_role_id;