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
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)
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
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;
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.
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:
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
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;
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;
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:
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)
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)))
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)
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 );
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 );
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');
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;