6:
7: --Global variable used in print_debug utility
8: G_VERSION_PRINTED BOOLEAN := FALSE;
9:
10: G_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
11:
12: PROCEDURE print_debug
13: (
14: p_err_msg VARCHAR2
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: IF p_entity_in_rec.entity_id_tbl.count > 0 AND p_entity_in_rec.ENTITY_TYPE = 'ORG_LOC' THEN --{
70:
71: FND_PROFILE.Get('WSH_OTM_DOMAIN_NAME', l_domain_name);
72: FND_PROFILE.Get('WSH_OTM_USER_ID', x_username);
73: FND_PROFILE.Get('WSH_OTM_PASSWORD', x_password);
74:
75: IF g_debug = 1 THEN
68:
69: IF p_entity_in_rec.entity_id_tbl.count > 0 AND p_entity_in_rec.ENTITY_TYPE = 'ORG_LOC' THEN --{
70:
71: FND_PROFILE.Get('WSH_OTM_DOMAIN_NAME', l_domain_name);
72: FND_PROFILE.Get('WSH_OTM_USER_ID', x_username);
73: FND_PROFILE.Get('WSH_OTM_PASSWORD', x_password);
74:
75: IF g_debug = 1 THEN
76: print_debug('OTM Domain : ' || l_domain_name || ' , OTM User : ' || x_username
69: IF p_entity_in_rec.entity_id_tbl.count > 0 AND p_entity_in_rec.ENTITY_TYPE = 'ORG_LOC' THEN --{
70:
71: FND_PROFILE.Get('WSH_OTM_DOMAIN_NAME', l_domain_name);
72: FND_PROFILE.Get('WSH_OTM_USER_ID', x_username);
73: FND_PROFILE.Get('WSH_OTM_PASSWORD', x_password);
74:
75: IF g_debug = 1 THEN
76: print_debug('OTM Domain : ' || l_domain_name || ' , OTM User : ' || x_username
77: || ' , OTM Password : ' || x_password