DBA Data[Home] [Help]

APPS.QP_PRICE_LIST_UTIL dependencies on OE_DEBUG_PUB

Line 746: oe_debug_pub.add('QPXUPLHB - list_header_id = ' || p_PRICE_LIST_rec.list_header_id);

742: THEN
743: NULL;
744: END IF;
745:
746: oe_debug_pub.add('QPXUPLHB - list_header_id = ' || p_PRICE_LIST_rec.list_header_id);
747: oe_debug_pub.add('QPXUPLHB - currency_header_id = ' || p_PRICE_LIST_rec.currency_header_id);
748: oe_debug_pub.add('QPXUPLHB - old currency_header_id = ' || p_old_PRICE_LIST_rec.currency_header_id);
749: oe_debug_pub.add('QPXUPLHB - rounding_factor = ' || p_PRICE_LIST_rec.rounding_factor);
750: -- Multi-Currency SunilPandey

Line 747: oe_debug_pub.add('QPXUPLHB - currency_header_id = ' || p_PRICE_LIST_rec.currency_header_id);

743: NULL;
744: END IF;
745:
746: oe_debug_pub.add('QPXUPLHB - list_header_id = ' || p_PRICE_LIST_rec.list_header_id);
747: oe_debug_pub.add('QPXUPLHB - currency_header_id = ' || p_PRICE_LIST_rec.currency_header_id);
748: oe_debug_pub.add('QPXUPLHB - old currency_header_id = ' || p_old_PRICE_LIST_rec.currency_header_id);
749: oe_debug_pub.add('QPXUPLHB - rounding_factor = ' || p_PRICE_LIST_rec.rounding_factor);
750: -- Multi-Currency SunilPandey
751: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_header_id,p_old_PRICE_LIST_rec.currency_header_id)

Line 748: oe_debug_pub.add('QPXUPLHB - old currency_header_id = ' || p_old_PRICE_LIST_rec.currency_header_id);

744: END IF;
745:
746: oe_debug_pub.add('QPXUPLHB - list_header_id = ' || p_PRICE_LIST_rec.list_header_id);
747: oe_debug_pub.add('QPXUPLHB - currency_header_id = ' || p_PRICE_LIST_rec.currency_header_id);
748: oe_debug_pub.add('QPXUPLHB - old currency_header_id = ' || p_old_PRICE_LIST_rec.currency_header_id);
749: oe_debug_pub.add('QPXUPLHB - rounding_factor = ' || p_PRICE_LIST_rec.rounding_factor);
750: -- Multi-Currency SunilPandey
751: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_header_id,p_old_PRICE_LIST_rec.currency_header_id)
752: THEN

Line 749: oe_debug_pub.add('QPXUPLHB - rounding_factor = ' || p_PRICE_LIST_rec.rounding_factor);

745:
746: oe_debug_pub.add('QPXUPLHB - list_header_id = ' || p_PRICE_LIST_rec.list_header_id);
747: oe_debug_pub.add('QPXUPLHB - currency_header_id = ' || p_PRICE_LIST_rec.currency_header_id);
748: oe_debug_pub.add('QPXUPLHB - old currency_header_id = ' || p_old_PRICE_LIST_rec.currency_header_id);
749: oe_debug_pub.add('QPXUPLHB - rounding_factor = ' || p_PRICE_LIST_rec.rounding_factor);
750: -- Multi-Currency SunilPandey
751: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_rec.currency_header_id,p_old_PRICE_LIST_rec.currency_header_id)
752: THEN
753: NULL;

Line 2121: oe_debug_pub.add('success 1');

2117:
2118: x_return_status := FND_API.G_RET_STS_SUCCESS;
2119: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2120:
2121: oe_debug_pub.add('success 1');
2122:
2123: ELSE
2124: if not QP_GLOBALS.EQUAL(p_PRICE_LIST_rec.list_source_code,l_PRICE_LIST_rec.list_source_code) then
2125: -- Row has changed by another user.

Line 2126: oe_debug_pub.add('Passed Value: LSC'||p_PRICE_LIST_rec.list_source_code);

2122:
2123: ELSE
2124: if not QP_GLOBALS.EQUAL(p_PRICE_LIST_rec.list_source_code,l_PRICE_LIST_rec.list_source_code) then
2125: -- Row has changed by another user.
2126: oe_debug_pub.add('Passed Value: LSC'||p_PRICE_LIST_rec.list_source_code);
2127: oe_debug_pub.add('DB Value: LSC'||l_PRICE_LIST_rec.list_source_code);
2128:
2129: end if ;
2130:

Line 2127: oe_debug_pub.add('DB Value: LSC'||l_PRICE_LIST_rec.list_source_code);

2123: ELSE
2124: if not QP_GLOBALS.EQUAL(p_PRICE_LIST_rec.list_source_code,l_PRICE_LIST_rec.list_source_code) then
2125: -- Row has changed by another user.
2126: oe_debug_pub.add('Passed Value: LSC'||p_PRICE_LIST_rec.list_source_code);
2127: oe_debug_pub.add('DB Value: LSC'||l_PRICE_LIST_rec.list_source_code);
2128:
2129: end if ;
2130:
2131: if not QP_GLOBALS.EQUAL(p_PRICE_LIST_rec.orig_system_header_ref,l_PRICE_LIST_rec.orig_system_header_ref) then

Line 2133: oe_debug_pub.add('Passed Value: OSHR'||p_PRICE_LIST_rec.orig_system_header_ref);

2129: end if ;
2130:
2131: if not QP_GLOBALS.EQUAL(p_PRICE_LIST_rec.orig_system_header_ref,l_PRICE_LIST_rec.orig_system_header_ref) then
2132:
2133: oe_debug_pub.add('Passed Value: OSHR'||p_PRICE_LIST_rec.orig_system_header_ref);
2134:
2135:
2136: oe_debug_pub.add('DB Value: OSHR'||l_PRICE_LIST_rec.orig_system_header_ref);
2137: end if;

Line 2136: oe_debug_pub.add('DB Value: OSHR'||l_PRICE_LIST_rec.orig_system_header_ref);

2132:
2133: oe_debug_pub.add('Passed Value: OSHR'||p_PRICE_LIST_rec.orig_system_header_ref);
2134:
2135:
2136: oe_debug_pub.add('DB Value: OSHR'||l_PRICE_LIST_rec.orig_system_header_ref);
2137: end if;
2138: oe_debug_pub.add('failed 1');
2139:
2140: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2138: oe_debug_pub.add('failed 1');

2134:
2135:
2136: oe_debug_pub.add('DB Value: OSHR'||l_PRICE_LIST_rec.orig_system_header_ref);
2137: end if;
2138: oe_debug_pub.add('failed 1');
2139:
2140: x_return_status := FND_API.G_RET_STS_ERROR;
2141: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2142:

Line 2155: oe_debug_pub.add('DB Value: name'||tlinfo.NAME||' Passed Value: '|| p_PRICE_LIST_rec.NAME);

2151: END IF;
2152:
2153: for tlinfo in c1 loop
2154: if (tlinfo.BASELANG = 'Y') then
2155: oe_debug_pub.add('DB Value: name'||tlinfo.NAME||' Passed Value: '|| p_PRICE_LIST_rec.NAME);
2156: oe_debug_pub.add('DB Value: description'||tlinfo.description||' Passed Value: '|| p_PRICE_LIST_rec.description);
2157: oe_debug_pub.add('DB Value: version_no'||tlinfo.version_no||' Passed Value: '|| p_PRICE_LIST_rec.version_no);
2158: if ( 1=1 -- (tlinfo.NAME = p_PRICE_LIST_rec.NAME)
2159: AND ((tlinfo.DESCRIPTION = p_PRICE_LIST_rec.DESCRIPTION)

Line 2156: oe_debug_pub.add('DB Value: description'||tlinfo.description||' Passed Value: '|| p_PRICE_LIST_rec.description);

2152:
2153: for tlinfo in c1 loop
2154: if (tlinfo.BASELANG = 'Y') then
2155: oe_debug_pub.add('DB Value: name'||tlinfo.NAME||' Passed Value: '|| p_PRICE_LIST_rec.NAME);
2156: oe_debug_pub.add('DB Value: description'||tlinfo.description||' Passed Value: '|| p_PRICE_LIST_rec.description);
2157: oe_debug_pub.add('DB Value: version_no'||tlinfo.version_no||' Passed Value: '|| p_PRICE_LIST_rec.version_no);
2158: if ( 1=1 -- (tlinfo.NAME = p_PRICE_LIST_rec.NAME)
2159: AND ((tlinfo.DESCRIPTION = p_PRICE_LIST_rec.DESCRIPTION)
2160: OR ((tlinfo.DESCRIPTION is null) AND (p_PRICE_LIST_rec.DESCRIPTION is null)))

Line 2157: oe_debug_pub.add('DB Value: version_no'||tlinfo.version_no||' Passed Value: '|| p_PRICE_LIST_rec.version_no);

2153: for tlinfo in c1 loop
2154: if (tlinfo.BASELANG = 'Y') then
2155: oe_debug_pub.add('DB Value: name'||tlinfo.NAME||' Passed Value: '|| p_PRICE_LIST_rec.NAME);
2156: oe_debug_pub.add('DB Value: description'||tlinfo.description||' Passed Value: '|| p_PRICE_LIST_rec.description);
2157: oe_debug_pub.add('DB Value: version_no'||tlinfo.version_no||' Passed Value: '|| p_PRICE_LIST_rec.version_no);
2158: if ( 1=1 -- (tlinfo.NAME = p_PRICE_LIST_rec.NAME)
2159: AND ((tlinfo.DESCRIPTION = p_PRICE_LIST_rec.DESCRIPTION)
2160: OR ((tlinfo.DESCRIPTION is null) AND (p_PRICE_LIST_rec.DESCRIPTION is null)))
2161: AND ((tlinfo.VERSION_NO = p_PRICE_LIST_rec.VERSION_NO)

Line 2168: oe_debug_pub.add('failed 2');

2164: x_PRICE_LIST_rec.NAME := tlinfo.NAME;
2165: x_PRICE_LIST_rec.VERSION_NO := tlinfo.VERSION_NO;
2166: x_PRICE_LIST_rec.DESCRIPTION := tlinfo.DESCRIPTION;
2167: else
2168: oe_debug_pub.add('failed 2');
2169:
2170: oe_debug_pub.add('tlinfo.name - rec.name ' || tlinfo.name || ' - ' || p_PRICE_LIST_rec.name );
2171:
2172: oe_debug_pub.add('tlinfo.description - rec.desc ' || tlinfo.description || ' - ' || p_PRICE_LIST_rec.description );

Line 2170: oe_debug_pub.add('tlinfo.name - rec.name ' || tlinfo.name || ' - ' || p_PRICE_LIST_rec.name );

2166: x_PRICE_LIST_rec.DESCRIPTION := tlinfo.DESCRIPTION;
2167: else
2168: oe_debug_pub.add('failed 2');
2169:
2170: oe_debug_pub.add('tlinfo.name - rec.name ' || tlinfo.name || ' - ' || p_PRICE_LIST_rec.name );
2171:
2172: oe_debug_pub.add('tlinfo.description - rec.desc ' || tlinfo.description || ' - ' || p_PRICE_LIST_rec.description );
2173:
2174: oe_debug_pub.add('tlinfo.ver_no - rec.ver_no ' || tlinfo.version_no || ' - ' || p_PRICE_LIST_rec.version_no );

Line 2172: oe_debug_pub.add('tlinfo.description - rec.desc ' || tlinfo.description || ' - ' || p_PRICE_LIST_rec.description );

2168: oe_debug_pub.add('failed 2');
2169:
2170: oe_debug_pub.add('tlinfo.name - rec.name ' || tlinfo.name || ' - ' || p_PRICE_LIST_rec.name );
2171:
2172: oe_debug_pub.add('tlinfo.description - rec.desc ' || tlinfo.description || ' - ' || p_PRICE_LIST_rec.description );
2173:
2174: oe_debug_pub.add('tlinfo.ver_no - rec.ver_no ' || tlinfo.version_no || ' - ' || p_PRICE_LIST_rec.version_no );
2175:
2176: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

Line 2174: oe_debug_pub.add('tlinfo.ver_no - rec.ver_no ' || tlinfo.version_no || ' - ' || p_PRICE_LIST_rec.version_no );

2170: oe_debug_pub.add('tlinfo.name - rec.name ' || tlinfo.name || ' - ' || p_PRICE_LIST_rec.name );
2171:
2172: oe_debug_pub.add('tlinfo.description - rec.desc ' || tlinfo.description || ' - ' || p_PRICE_LIST_rec.description );
2173:
2174: oe_debug_pub.add('tlinfo.ver_no - rec.ver_no ' || tlinfo.version_no || ' - ' || p_PRICE_LIST_rec.version_no );
2175:
2176: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
2177: app_exception.raise_exception;
2178: end if;