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

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

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

433: l_email hz_parties.email_address%TYPE;
434: l_create_email boolean := FALSE;
435:
436: --
437: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
438: --
439: BEGIN
440:
441:

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

625: l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
626: l_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;
627:
628: --
629: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
630: --
631: BEGIN
632:
633: l_contact_points_rec.contact_point_type := in_contact_point_type;

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

777: l_msg_data Varchar2(4000);
778: l_return_status Varchar2(1);
779:
780: --
781: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
782: --
783: BEGIN
784:
785: l_location_rec.country :=p_country;

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

843: ( p_count => x_msg_count
844: , p_data => x_msg_data
845: );
846:
847: oe_debug_pub.add('Exiting oe_oe_inline_address.create_location', 1);
848:
849: EXCEPTION
850:
851: WHEN FND_API.G_EXC_ERROR THEN

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

851: WHEN FND_API.G_EXC_ERROR THEN
852:
853:
854: IF l_debug_level > 0 THEN
855: oe_debug_pub.add( 'INSIDE CREATE_LOCATION EXC ERROR' , 1 ) ;
856: END IF;
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: OE_MSG_PUB.Count_And_Get
859: ( p_count => x_msg_count

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

870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
871:
872:
873: IF l_debug_level > 0 THEN
874: oe_debug_pub.add( 'INSIDE CREATE_LOCATION UNEXPECTED ERROR' , 1 ) ;
875: END IF;
876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
877: OE_MSG_PUB.Count_And_Get
878: ( p_count => x_msg_count

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

889: WHEN OTHERS THEN
890:
891:
892: IF l_debug_level > 0 THEN
893: oe_debug_pub.add( 'INSIDE CREATE_LOCATION WHEN OTHERS' , 1 ) ;
894: END IF;
895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
896: OE_MSG_PUB.Count_And_Get
897: ( p_count => x_msg_count

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

940: tmp_var1 VARCHAR2(2000);
941: x number;
942:
943: --
944: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
945: --
946: BEGIN
947: IF l_debug_level > 0 THEN
948: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER.CREATE_PARTY_SITE' , 1 ) ;

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

944: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
945: --
946: BEGIN
947: IF l_debug_level > 0 THEN
948: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER.CREATE_PARTY_SITE' , 1 ) ;
949: END IF;
950: l_party_site_rec.party_id:= p_party_id;
951: l_party_site_rec.location_id:=p_location_id;
952: -- Party Site Number Should be sent only if auto-numbering set off . Add

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

971: x_msg_data => x_msg_data
972: );
973:
974: IF l_debug_level > 0 THEN
975: oe_debug_pub.add( 'AFTER CALL HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE'||X_RETURN_STATUS , 1 ) ;
976: END IF;
977:
978: IF l_debug_level > 0 THEN
979: oe_debug_pub.add( 'AFTER CALL HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE MSG'||X_MSG_DATA , 1 ) ;

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

975: oe_debug_pub.add( 'AFTER CALL HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE'||X_RETURN_STATUS , 1 ) ;
976: END IF;
977:
978: IF l_debug_level > 0 THEN
979: oe_debug_pub.add( 'AFTER CALL HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE MSG'||X_MSG_DATA , 1 ) ;
980: END IF;
981:
982: IF x_msg_count = 1 THEN
983: --x_msg_data := x_msg_data || '**CREATE_PARTY_SITE**';

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

1100: tmp_var1 VARCHAR2(2000);
1101: x number;
1102:
1103: --
1104: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1105: --
1106: BEGIN
1107:
1108: l_account_site_rec.party_site_id:=p_party_site_id;

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

1276: l_acct_site_uses HZ_CUST_ACCOUNT_SITE_V2PUB.cust_site_use_rec_type;
1277: l_cust_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.customer_profile_rec_type;
1278:
1279: --
1280: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1281: --
1282: BEGIN
1283:
1284: l_acct_site_uses.cust_acct_site_id := p_cust_acct_site_id;

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

1424:
1425: x_profile_id NUMBER;
1426:
1427: --
1428: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1429: --
1430: BEGIN
1431:
1432: IF p_account_description IS NOT NULL THEN

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

1497: l_person_rec.tax_reference:=p_tax_reference;
1498: l_person_rec.jgzz_fiscal_code:=p_taxpayer_id;
1499: l_person_rec.person_name_suffix:=p_name_suffix;
1500: IF l_debug_level > 0 THEN
1501: oe_debug_pub.add( 'CUSTOMER PERSON TITLE='||P_TITLE ) ;
1502: END IF;
1503: l_person_rec.person_pre_name_adjunct := p_title;
1504: l_party_rec.party_number := p_party_number;
1505:

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

1582: x_party_id number;
1583: x_party_number hz_parties.party_number%TYPE;
1584:
1585: --
1586: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1587: --
1588: BEGIN
1589:
1590: -- commmented out as it is not used anywhere

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

1610:
1611: l_cust_rel_rec HZ_CUST_ACCOUNT_V2PUB.cust_acct_relate_rec_type;
1612:
1613: --
1614: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1615: --
1616: BEGIN
1617:
1618: l_cust_rel_rec.cust_account_id := p_cust_acct_id;

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

1630: x_msg_count => x_msg_count,
1631: x_msg_data => x_msg_data
1632: );
1633:
1634: oe_debug_pub.add('status='||x_return_status||
1635: ' msg_count='||x_msg_count||
1636: ' msg_data='||x_msg_data||
1637: ' cust_acct_related_id='||l_cust_rel_rec.related_cust_account_id||
1638: ' cust_acct_id='||l_cust_rel_rec.cust_account_id||

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

1647:
1648: PROCEDURE Commit_Changes IS
1649:
1650: --
1651: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1652: --
1653: BEGIN
1654:
1655: commit;

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

1660:
1661: PROCEDURE Rollback_Changes IS
1662:
1663: --
1664: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1665: --
1666: BEGIN
1667:
1668: Rollback;

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

1689:
1690: l_person_rec HZ_PARTY_V2PUB.person_rec_type;
1691:
1692: --
1693: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1694: --
1695: BEGIN
1696:
1697: l_person_rec.person_first_name:=p_first_name;

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

1730: ) IS
1731: l_organization_rec HZ_PARTY_V2PUB.organization_rec_type;
1732:
1733: --
1734: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1735: --
1736: BEGIN
1737:
1738: l_organization_rec.organization_name:=p_organization_name;

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

1761:
1762: l_role_resp_rec HZ_CUST_ACCOUNT_ROLE_V2PUB.role_responsibility_rec_type;
1763:
1764: --
1765: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1766: --
1767: BEGIN
1768:
1769: l_role_resp_rec.cust_account_role_id := p_cust_acct_role_id;