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.QP_BULK_VALUE_TO_ID dependencies on QP_BULK_LOADER_PUB

Line 10: qp_bulk_loader_pub.write_log( 'Entering Value to ID Header');

6:
7: IS
8: BEGIN
9:
10: qp_bulk_loader_pub.write_log( 'Entering Value to ID Header');
11:
12: -- 1. Currency Header
13:
14: -- If Multi Currency Option is Set to Yes then process_status_flag should be set to 'E'

Line 34: and ih.currency_header <> QP_BULK_LOADER_PUB.G_NULL_CHAR

30: and ih.process_status_flag = 'P' --IS NOT NULL
31: and ih.currency_header is not null
32: --Bug# 5412029
33: --Don't do conversion if Value is G_NULL_CHAR
34: and ih.currency_header <> QP_BULK_LOADER_PUB.G_NULL_CHAR
35: and ih.currency_header_id is null
36: and ih.interface_action_code in ('INSERT','UPDATE');
37: End If;
38:

Line 57: and ih.freight_terms <> QP_BULK_LOADER_PUB.G_NULL_CHAR

53: and ih.process_status_flag = 'P' --IS NOT NULL
54: and ih.freight_terms is not null
55: --Bug# 5412029
56: --Don't do conversion if Value is G_NULL_CHAR
57: and ih.freight_terms <> QP_BULK_LOADER_PUB.G_NULL_CHAR
58: and ih.freight_terms_code is null
59: and ih.interface_action_code in ('INSERT','UPDATE');
60:
61: -- 3. Ship Method Code

Line 81: and ih.ship_method <> QP_BULK_LOADER_PUB.G_NULL_CHAR

77: and ih.process_status_flag = 'P' --IS NOT NULL
78: and ih.ship_method is not null
79: --Bug# 5412029
80: --Don't do conversion if Value is G_NULL_CHAR
81: and ih.ship_method <> QP_BULK_LOADER_PUB.G_NULL_CHAR
82: and ih.ship_method_code is null
83: and ih.interface_action_code in ('INSERT','UPDATE');
84:
85: -- 4. Terms Id

Line 104: and ih.terms <> QP_BULK_LOADER_PUB.G_NULL_CHAR

100: and ih.process_status_flag = 'P' --IS NOT NULL
101: and ih.terms is not null
102: --Bug# 5412029
103: --Don't do conversion if Value is G_NULL_CHAR
104: and ih.terms <> QP_BULK_LOADER_PUB.G_NULL_CHAR
105: and ih.terms_id is null
106: and ih.interface_action_code in ('INSERT','UPDATE');
107:
108: qp_bulk_loader_pub.write_log( 'Leaving Value to ID Header');

Line 108: qp_bulk_loader_pub.write_log( 'Leaving Value to ID Header');

104: and ih.terms <> QP_BULK_LOADER_PUB.G_NULL_CHAR
105: and ih.terms_id is null
106: and ih.interface_action_code in ('INSERT','UPDATE');
107:
108: qp_bulk_loader_pub.write_log( 'Leaving Value to ID Header');
109:
110: EXCEPTION
111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
112: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.HEADER:'||sqlerrm);

Line 112: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.HEADER:'||sqlerrm);

108: qp_bulk_loader_pub.write_log( 'Leaving Value to ID Header');
109:
110: EXCEPTION
111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
112: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.HEADER:'||sqlerrm);
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114: WHEN OTHERS THEN
115: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.HEADER:'||sqlerrm);
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 115: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.HEADER:'||sqlerrm);

111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
112: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.HEADER:'||sqlerrm);
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114: WHEN OTHERS THEN
115: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.HEADER:'||sqlerrm);
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117:
118: END HEADER;
119:

Line 126: qp_bulk_loader_pub.write_log( 'Entering Value to ID Qualifier');

122: IS
123:
124: BEGIN
125:
126: qp_bulk_loader_pub.write_log( 'Entering Value to ID Qualifier');
127: -- 1. CREATED_FROM_RULE
128: UPDATE QP_INTERFACE_QUALIFIERS a
129: SET(CREATED_FROM_RULE_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
130: (SELECT b.QUALIFIER_RULE_ID,

Line 142: AND a.CREATED_FROM_RULE <> QP_BULK_LOADER_PUB.G_NULL_CHAR

138: and a.process_status_flag = 'P' --IS NOT NULL
139: AND a.CREATED_FROM_RULE_ID IS NULL
140: --Bug# 5456164
141: --Don't do conversion if Value is G_NULL_CHAR
142: AND a.CREATED_FROM_RULE <> QP_BULK_LOADER_PUB.G_NULL_CHAR
143: AND a.CREATED_FROM_RULE IS NOT NULL
144: AND a.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
145:
146: -- 2.QUALIFIER_RULE

Line 162: AND a.QUALIFIER_RULE <> QP_BULK_LOADER_PUB.G_NULL_CHAR

158: and a.process_status_flag = 'P' --IS NOT NULL
159: AND a.QUALIFIER_RULE_ID IS NULL
160: --Bug# 5456164
161: --Don't do conversion if Value is G_NULL_CHAR
162: AND a.QUALIFIER_RULE <> QP_BULK_LOADER_PUB.G_NULL_CHAR
163: AND a.QUALIFIER_RULE IS NOT NULL
164: AND a.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
165:
166: --3.Qualifier Attribute

Line 184: AND qiq.QUALIFIER_ATTRIBUTE_CODE <> QP_BULK_LOADER_PUB.G_NULL_CHAR

180: and qiq.process_status_flag = 'P' --IS NOT NULL
181: AND qiq.QUALIFIER_ATTRIBUTE IS NULL
182: --Bug# 5456164
183: --Don't do conversion if Value is G_NULL_CHAR
184: AND qiq.QUALIFIER_ATTRIBUTE_CODE <> QP_BULK_LOADER_PUB.G_NULL_CHAR
185: AND qiq.QUALIFIER_ATTRIBUTE_CODE IS NOT NULL
186: AND qiq.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
187:
188:

Line 189: qp_bulk_loader_pub.write_log( 'Leaving Value to ID Qualifier');

185: AND qiq.QUALIFIER_ATTRIBUTE_CODE IS NOT NULL
186: AND qiq.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
187:
188:
189: qp_bulk_loader_pub.write_log( 'Leaving Value to ID Qualifier');
190:
191: EXCEPTION
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.QUALIFIER:'||sqlerrm);

Line 193: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.QUALIFIER:'||sqlerrm);

189: qp_bulk_loader_pub.write_log( 'Leaving Value to ID Qualifier');
190:
191: EXCEPTION
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.QUALIFIER:'||sqlerrm);
194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
195: WHEN OTHERS THEN
196: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.QUALIFIER:'||sqlerrm);
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 196: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.QUALIFIER:'||sqlerrm);

192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.QUALIFIER:'||sqlerrm);
194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
195: WHEN OTHERS THEN
196: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.QUALIFIER:'||sqlerrm);
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198:
199:
200: END QUALIFIER;

Line 254: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines');

250: x_vsid NUMBER;
251: x_validation_type VARCHAR2(1);
252:
253: BEGIN
254: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines');
255: -- 1.PRICE_BY_FORMULA
256:
257: UPDATE QP_INTERFACE_LIST_LINES a
258: SET(PRICE_BY_FORMULA_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=

Line 271: and a.PRICE_BY_FORMULA <> QP_BULK_LOADER_PUB.G_NULL_CHAR

267: AND a.PRICE_BY_FORMULA_ID IS NULL
268: AND a.PRICE_BY_FORMULA IS NOT NULL
269: --Bug# 5412029
270: --Don't do conversion if Value is G_NULL_CHAR
271: and a.PRICE_BY_FORMULA <> QP_BULK_LOADER_PUB.G_NULL_CHAR
272: AND a.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
273:
274: -- 2.GENERATE_USING_FORMULA
275: UPDATE QP_INTERFACE_LIST_LINES a

Line 289: and a.GENERATE_USING_FORMULA <> QP_BULK_LOADER_PUB.G_NULL_CHAR

285: AND a.GENERATE_USING_FORMULA_ID IS NULL
286: AND a.GENERATE_USING_FORMULA IS NOT NULL
287: --Bug# 5412029
288: --Don't do conversion if Value is G_NULL_CHAR
289: and a.GENERATE_USING_FORMULA <> QP_BULK_LOADER_PUB.G_NULL_CHAR
290: AND a.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
291:
292: -- 3.Product Attribute
293: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Product Attribute');

Line 293: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Product Attribute');

289: and a.GENERATE_USING_FORMULA <> QP_BULK_LOADER_PUB.G_NULL_CHAR
290: AND a.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
291:
292: -- 3.Product Attribute
293: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Product Attribute');
294: UPDATE QP_INTERFACE_PRICING_ATTRIBS qipa
295: SET (PRODUCT_ATTRIBUTE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
296: (SELECT a.segment_mapping_column,
297: DECODE(a.segment_mapping_column, NULL, null, 'P'),

Line 310: AND qipa.PRODUCT_ATTR_CODE <> QP_BULK_LOADER_PUB.G_NULL_CHAR

306: AND qipa.process_status_flag = 'P' --IS NOT NULL
307: AND qipa.PRODUCT_ATTRIBUTE IS NULL
308: --Bug# 5456164
309: --Don't do conversion if Value is G_NULL_CHAR
310: AND qipa.PRODUCT_ATTR_CODE <> QP_BULK_LOADER_PUB.G_NULL_CHAR
311: AND qipa.PRODUCT_ATTR_CODE IS NOT NULL
312: AND qipa.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
313:
314: -- 5.Product Precedence.

Line 315: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Product Precedence');

311: AND qipa.PRODUCT_ATTR_CODE IS NOT NULL
312: AND qipa.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
313:
314: -- 5.Product Precedence.
315: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Product Precedence');
316: UPDATE QP_INTERFACE_LIST_LINES qill
317: SET PRODUCT_PRECEDENCE=
318: (SELECT NVL(a.USER_PRECEDENCE, a.SEEDED_PRECEDENCE)
319: FROM qp_segments_v a, qp_prc_contexts_b b, qp_interface_pricing_attribs c

Line 336: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Pricing Attribute');

332: AND qill.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
333:
334:
335: -- 4.Pricing Attribute
336: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Pricing Attribute');
337: UPDATE QP_INTERFACE_PRICING_ATTRIBS qipa
338: SET (PRICING_ATTRIBUTE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
339: (SELECT a.segment_mapping_column,
340: DECODE(a.segment_mapping_column, NULL, null, 'P'),

Line 353: AND qipa.PRICING_ATTR_CODE <> QP_BULK_LOADER_PUB.G_NULL_CHAR

349: AND qipa.process_status_flag = 'P' --IS NOT NULL
350: AND qipa.PRICING_ATTRIBUTE IS NULL
351: --Bug# 5456164
352: --Don't do conversion if Value is G_NULL_CHAR
353: AND qipa.PRICING_ATTR_CODE <> QP_BULK_LOADER_PUB.G_NULL_CHAR
354: AND qipa.PRICING_ATTR_CODE IS NOT NULL
355: AND qipa.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
356:
357: --5. Product_Attr_Value

Line 358: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Product Attribute Value1');

354: AND qipa.PRICING_ATTR_CODE IS NOT NULL
355: AND qipa.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
356:
357: --5. Product_Attr_Value
358: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Product Attribute Value1');
359: UPDATE /*+ index(qipa QP_INTERFACE_PRCNG_ATTRIBS_N1) */ QP_INTERFACE_PRICING_ATTRIBS qipa --7323577
360: SET (PRODUCT_ATTR_VALUE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
361: (SELECT a.inventory_item_id,
362: DECODE(a.inventory_item_id, NULL, null, 'P'),

Line 378: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Product Attribute Value2');

374: AND qipa.product_attribute = 'PRICING_ATTRIBUTE1'
375: AND qipa.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
376:
377: --6. Product_Attr_Value
378: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Product Attribute Value2');
379: UPDATE QP_INTERFACE_PRICING_ATTRIBS qipa
380: SET (PRODUCT_ATTR_VALUE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
381: (SELECT a.category_id,
382: DECODE(a.category_id, NULL, null, 'P'),

Line 399: qp_bulk_loader_pub.write_log('In the Pricing attr value to id loop');

395: AND qipa.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
396:
397: FOR rec IN c_price_attr
398: LOOP
399: qp_bulk_loader_pub.write_log('In the Pricing attr value to id loop');
400: qp_bulk_loader_pub.write_log('product_attr_code: '|| rec.product_attr_code);
401: qp_bulk_loader_pub.write_log('product_attribute: '|| rec.product_attribute);
402: --PRODUCT_ATTRIBUTE
403: --PRODUCT_ATTR_VALUE

Line 400: qp_bulk_loader_pub.write_log('product_attr_code: '|| rec.product_attr_code);

396:
397: FOR rec IN c_price_attr
398: LOOP
399: qp_bulk_loader_pub.write_log('In the Pricing attr value to id loop');
400: qp_bulk_loader_pub.write_log('product_attr_code: '|| rec.product_attr_code);
401: qp_bulk_loader_pub.write_log('product_attribute: '|| rec.product_attribute);
402: --PRODUCT_ATTRIBUTE
403: --PRODUCT_ATTR_VALUE
404:

Line 401: qp_bulk_loader_pub.write_log('product_attribute: '|| rec.product_attribute);

397: FOR rec IN c_price_attr
398: LOOP
399: qp_bulk_loader_pub.write_log('In the Pricing attr value to id loop');
400: qp_bulk_loader_pub.write_log('product_attr_code: '|| rec.product_attr_code);
401: qp_bulk_loader_pub.write_log('product_attribute: '|| rec.product_attribute);
402: --PRODUCT_ATTRIBUTE
403: --PRODUCT_ATTR_VALUE
404:
405: l_product_attr_value := null; --bug7315184

Line 407: qp_bulk_loader_pub.write_log('Product_attribute_context/product attribute'||rec.product_attribute_context||l_product_attribute);

403: --PRODUCT_ATTR_VALUE
404:
405: l_product_attr_value := null; --bug7315184
406:
407: qp_bulk_loader_pub.write_log('Product_attribute_context/product attribute'||rec.product_attribute_context||l_product_attribute);
408: IF rec.product_attribute_context='ITEM'
409: and rec.product_attribute='PRICING_ATTRIBUTE1' THEN
410: NULL;
411: ELSIF rec.product_attribute_context='ITEM'

Line 415: qp_bulk_loader_pub.write_log('Product context/attribute is not Item nor category');

411: ELSIF rec.product_attribute_context='ITEM'
412: and rec.product_attribute='PRICING_ATTRIBUTE2' THEN
413: NULL;
414: ELSE
415: qp_bulk_loader_pub.write_log('Product context/attribute is not Item nor category');
416: if rec.product_attr_val_disp is not NULL and
417: rec.product_attr_value is NULL then
418: BEGIN
419: l_segment_name :=QP_PRICE_LIST_LINE_UTIL.Get_Segment_Name

Line 424: qp_bulk_loader_pub.write_log('getting segment name'||l_segment_name);

420: ('QP_ATTR_DEFNS_PRICING',
421: rec.product_attribute_context,
422: rec.product_attribute);
423:
424: qp_bulk_loader_pub.write_log('getting segment name'||l_segment_name);
425: /*
426: QP_Value_To_ID.Flex_Meaning_To_Value_Id(
427: p_flexfield_name => 'QP_ATTR_DEFNS_PRICING',
428: p_context => rec.product_attribute_context,

Line 439: qp_bulk_loader_pub.write_log('vsid: '||to_char(x_vsid));

435: QP_UTIL.Get_Valueset_Id('QP_ATTR_DEFNS_PRICING',
436: rec.product_attribute_context,
437: l_segment_name,
438: x_vsid, x_format_type, x_validation_type);
439: qp_bulk_loader_pub.write_log('vsid: '||to_char(x_vsid));
440: FND_VSET.get_valueset(x_vsid, vset, fmt);
441: FND_VSET.get_value_init(vset, TRUE);
442: FND_VSET.get_value(vset, row, found, value);
443:

Line 445: qp_bulk_loader_pub.write_log('meaning: '||value.meaning);

441: FND_VSET.get_value_init(vset, TRUE);
442: FND_VSET.get_value(vset, row, found, value);
443:
444: WHILE (found) LOOP
445: qp_bulk_loader_pub.write_log('meaning: '||value.meaning);
446: IF (fmt.has_meaning AND
447: ltrim(rtrim(value.meaning))=ltrim(rtrim(rec.product_attr_val_disp))
448: ) OR
449: ltrim(rtrim(value.value)) = ltrim(rtrim(rec.product_attr_val_disp))

Line 451: qp_bulk_loader_pub.write_log('success: ');

447: ltrim(rtrim(value.meaning))=ltrim(rtrim(rec.product_attr_val_disp))
448: ) OR
449: ltrim(rtrim(value.value)) = ltrim(rtrim(rec.product_attr_val_disp))
450: THEN
451: qp_bulk_loader_pub.write_log('success: ');
452:
453: IF fmt.has_id THEN
454: qp_bulk_loader_pub.write_log('fmt.has_id');
455: x_id := value.id;

Line 454: qp_bulk_loader_pub.write_log('fmt.has_id');

450: THEN
451: qp_bulk_loader_pub.write_log('success: ');
452:
453: IF fmt.has_id THEN
454: qp_bulk_loader_pub.write_log('fmt.has_id');
455: x_id := value.id;
456: x_value := value.value;
457: ELSE
458: x_value := value.value;

Line 470: qp_bulk_loader_pub.write_log('x_value/x_id: ' || x_value || '/' || x_id);

466: END LOOP;
467:
468: FND_VSET.get_value_end(vset);
469:
470: qp_bulk_loader_pub.write_log('x_value/x_id: ' || x_value || '/' || x_id);
471: if x_value is NULL then
472: x_value := rec.product_attr_val_disp;
473: --If a match is not found in the valueset.
474: end if;

Line 476: qp_bulk_loader_pub.write_log('getting product_attr_value using flex_meaning_to_value_id');

472: x_value := rec.product_attr_val_disp;
473: --If a match is not found in the valueset.
474: end if;
475:
476: qp_bulk_loader_pub.write_log('getting product_attr_value using flex_meaning_to_value_id');
477: qp_bulk_loader_pub.write_log('product_attr_val_disp '||rec.product_attr_val_disp);
478:
479: IF x_id IS NOT NULL THEN
480: l_product_attr_value := x_id;

Line 477: qp_bulk_loader_pub.write_log('product_attr_val_disp '||rec.product_attr_val_disp);

473: --If a match is not found in the valueset.
474: end if;
475:
476: qp_bulk_loader_pub.write_log('getting product_attr_value using flex_meaning_to_value_id');
477: qp_bulk_loader_pub.write_log('product_attr_val_disp '||rec.product_attr_val_disp);
478:
479: IF x_id IS NOT NULL THEN
480: l_product_attr_value := x_id;
481: ELSE

Line 485: qp_bulk_loader_pub.write_log('product_attr_value is '||l_product_attr_value);

481: ELSE
482: l_product_attr_value := x_value;
483: END IF;
484:
485: qp_bulk_loader_pub.write_log('product_attr_value is '||l_product_attr_value);
486: IF l_product_attr_value IS NULL THEN
487: qp_bulk_loader_pub.write_log('product_attr_value is NULL - ERROR');
488: UPDATE QP_INTERFACE_PRICING_ATTRIBS
489: SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'004'

Line 487: qp_bulk_loader_pub.write_log('product_attr_value is NULL - ERROR');

483: END IF;
484:
485: qp_bulk_loader_pub.write_log('product_attr_value is '||l_product_attr_value);
486: IF l_product_attr_value IS NULL THEN
487: qp_bulk_loader_pub.write_log('product_attr_value is NULL - ERROR');
488: UPDATE QP_INTERFACE_PRICING_ATTRIBS
489: SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'004'
490: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
491: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF

Line 507: qp_bulk_loader_pub.write_log('Exception Error caused'||sqlerrm);

503: SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'004'
504: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
505: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
506: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
507: qp_bulk_loader_pub.write_log('Exception Error caused'||sqlerrm);
508: END;
509: END IF; -- product_attr_val is NULL
510: END IF;
511:

Line 525: qp_bulk_loader_pub.write_log('default line precedence once for a line');

521: end if;
522: if l_orig_sys_line_ref IS NULL or
523: l_orig_sys_line_ref <> REC.orig_sys_line_ref then
524: l_orig_sys_line_ref := REC.ORIG_SYS_LINE_REF;
525: qp_bulk_loader_pub.write_log('default line precedence once for a line');
526: qp_bulk_loader_pub.write_log('Context/Attribute/Value'||rec.product_attribute_context||'/'||l_product_attribute||'/'||l_product_attr_value);
527: QP_UTIL.validate_qp_flexfield(
528: flexfield_name=> 'QP_ATTR_DEFNS_PRICING'
529: ,context =>rec.product_attribute_context

Line 526: qp_bulk_loader_pub.write_log('Context/Attribute/Value'||rec.product_attribute_context||'/'||l_product_attribute||'/'||l_product_attr_value);

522: if l_orig_sys_line_ref IS NULL or
523: l_orig_sys_line_ref <> REC.orig_sys_line_ref then
524: l_orig_sys_line_ref := REC.ORIG_SYS_LINE_REF;
525: qp_bulk_loader_pub.write_log('default line precedence once for a line');
526: qp_bulk_loader_pub.write_log('Context/Attribute/Value'||rec.product_attribute_context||'/'||l_product_attribute||'/'||l_product_attr_value);
527: QP_UTIL.validate_qp_flexfield(
528: flexfield_name=> 'QP_ATTR_DEFNS_PRICING'
529: ,context =>rec.product_attribute_context
530: ,attribute =>rec.product_attribute

Line 541: qp_bulk_loader_pub.write_log('line ref'||rec.orig_sys_line_ref||'error_code'||to_char(l_error_code));

537: ,precedence =>l_precedence
538: ,error_code =>l_error_code
539: );
540:
541: qp_bulk_loader_pub.write_log('line ref'||rec.orig_sys_line_ref||'error_code'||to_char(l_error_code));
542: If l_error_code = 0 Then
543: UPDATE QP_INTERFACE_LIST_LINES
544: SET PRODUCT_PRECEDENCE = l_precedence
545: WHERE ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF

Line 558: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attribute');

554: end if;
555: end if;
556: end if;
557: --PRICING_ATTRIBUTE
558: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attribute');
559: qp_bulk_loader_pub.write_log('Pricing_attr_code: '|| rec.pricing_attr_code);
560: qp_bulk_loader_pub.write_log('Pricing_attribute: '|| rec.pricing_attribute);
561: --PRICING_ATTR_VALUE_FROM
562: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value from');

Line 559: qp_bulk_loader_pub.write_log('Pricing_attr_code: '|| rec.pricing_attr_code);

555: end if;
556: end if;
557: --PRICING_ATTRIBUTE
558: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attribute');
559: qp_bulk_loader_pub.write_log('Pricing_attr_code: '|| rec.pricing_attr_code);
560: qp_bulk_loader_pub.write_log('Pricing_attribute: '|| rec.pricing_attribute);
561: --PRICING_ATTR_VALUE_FROM
562: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value from');
563: qp_bulk_loader_pub.write_log('Pricing_attr_value_from : '|| rec.pricing_attr_value_from);

Line 560: qp_bulk_loader_pub.write_log('Pricing_attribute: '|| rec.pricing_attribute);

556: end if;
557: --PRICING_ATTRIBUTE
558: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attribute');
559: qp_bulk_loader_pub.write_log('Pricing_attr_code: '|| rec.pricing_attr_code);
560: qp_bulk_loader_pub.write_log('Pricing_attribute: '|| rec.pricing_attribute);
561: --PRICING_ATTR_VALUE_FROM
562: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value from');
563: qp_bulk_loader_pub.write_log('Pricing_attr_value_from : '|| rec.pricing_attr_value_from);
564: qp_bulk_loader_pub.write_log('Pricing_attr_value_from_disp: '|| rec.pricing_attr_value_from_disp);

Line 562: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value from');

558: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attribute');
559: qp_bulk_loader_pub.write_log('Pricing_attr_code: '|| rec.pricing_attr_code);
560: qp_bulk_loader_pub.write_log('Pricing_attribute: '|| rec.pricing_attribute);
561: --PRICING_ATTR_VALUE_FROM
562: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value from');
563: qp_bulk_loader_pub.write_log('Pricing_attr_value_from : '|| rec.pricing_attr_value_from);
564: qp_bulk_loader_pub.write_log('Pricing_attr_value_from_disp: '|| rec.pricing_attr_value_from_disp);
565: IF rec.pricing_attr_value_from IS NULL and
566: rec.pricing_attr_value_from_disp IS NOT NULL THEN

Line 563: qp_bulk_loader_pub.write_log('Pricing_attr_value_from : '|| rec.pricing_attr_value_from);

559: qp_bulk_loader_pub.write_log('Pricing_attr_code: '|| rec.pricing_attr_code);
560: qp_bulk_loader_pub.write_log('Pricing_attribute: '|| rec.pricing_attribute);
561: --PRICING_ATTR_VALUE_FROM
562: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value from');
563: qp_bulk_loader_pub.write_log('Pricing_attr_value_from : '|| rec.pricing_attr_value_from);
564: qp_bulk_loader_pub.write_log('Pricing_attr_value_from_disp: '|| rec.pricing_attr_value_from_disp);
565: IF rec.pricing_attr_value_from IS NULL and
566: rec.pricing_attr_value_from_disp IS NOT NULL THEN
567: BEGIN

Line 564: qp_bulk_loader_pub.write_log('Pricing_attr_value_from_disp: '|| rec.pricing_attr_value_from_disp);

560: qp_bulk_loader_pub.write_log('Pricing_attribute: '|| rec.pricing_attribute);
561: --PRICING_ATTR_VALUE_FROM
562: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value from');
563: qp_bulk_loader_pub.write_log('Pricing_attr_value_from : '|| rec.pricing_attr_value_from);
564: qp_bulk_loader_pub.write_log('Pricing_attr_value_from_disp: '|| rec.pricing_attr_value_from_disp);
565: IF rec.pricing_attr_value_from IS NULL and
566: rec.pricing_attr_value_from_disp IS NOT NULL THEN
567: BEGIN
568: l_segment_name :=QP_PRICE_LIST_LINE_UTIL.Get_Segment_Name

Line 572: qp_bulk_loader_pub.write_log('getting segment name'||l_segment_name);

568: l_segment_name :=QP_PRICE_LIST_LINE_UTIL.Get_Segment_Name
569: ('QP_ATTR_DEFNS_PRICING',
570: rec.pricing_attribute_context,
571: rec.pricing_attribute);
572: qp_bulk_loader_pub.write_log('getting segment name'||l_segment_name);
573:
574: qp_bulk_loader_pub.write_log('getting pricing_attr_value_from_disp using flex_meaning_to_value_id');
575: QP_Value_To_ID.Flex_Meaning_To_Value_Id(
576: p_flexfield_name => 'QP_ATTR_DEFNS_PRICING',

Line 574: qp_bulk_loader_pub.write_log('getting pricing_attr_value_from_disp using flex_meaning_to_value_id');

570: rec.pricing_attribute_context,
571: rec.pricing_attribute);
572: qp_bulk_loader_pub.write_log('getting segment name'||l_segment_name);
573:
574: qp_bulk_loader_pub.write_log('getting pricing_attr_value_from_disp using flex_meaning_to_value_id');
575: QP_Value_To_ID.Flex_Meaning_To_Value_Id(
576: p_flexfield_name => 'QP_ATTR_DEFNS_PRICING',
577: p_context => rec.pricing_attribute_context,
578: p_segment => l_segment_name,

Line 591: qp_bulk_loader_pub.write_log('pricing_attr_value_from is '||l_pricing_attr_value_from);

587: ELSE
588: l_pricing_attr_value_from := x_value;
589: END IF;
590:
591: qp_bulk_loader_pub.write_log('pricing_attr_value_from is '||l_pricing_attr_value_from);
592: UPDATE QP_INTERFACE_PRICING_ATTRIBS
593: SET PRICING_ATTR_VALUE_FROM = l_pricing_attr_value_from
594: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
595: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF

Line 605: qp_bulk_loader_pub.write_log('Exception Error caused'||sqlerrm);

601: SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'006'
602: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
603: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
604: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
605: qp_bulk_loader_pub.write_log('Exception Error caused'||sqlerrm);
606: END;
607: END IF;
608:
609: --PRICING_ATTR_VALUE_TO

Line 610: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value to');

606: END;
607: END IF;
608:
609: --PRICING_ATTR_VALUE_TO
610: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value to');
611: qp_bulk_loader_pub.write_log('Pricing_attr_value_to : '|| rec.pricing_attr_value_to);
612: qp_bulk_loader_pub.write_log('Pricing_attr_value_to_disp: '|| rec.pricing_attr_value_to_disp);
613: IF rec.pricing_attr_value_to IS NULL and
614: rec.pricing_attr_value_to_disp IS NOT NULL THEN

Line 611: qp_bulk_loader_pub.write_log('Pricing_attr_value_to : '|| rec.pricing_attr_value_to);

607: END IF;
608:
609: --PRICING_ATTR_VALUE_TO
610: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value to');
611: qp_bulk_loader_pub.write_log('Pricing_attr_value_to : '|| rec.pricing_attr_value_to);
612: qp_bulk_loader_pub.write_log('Pricing_attr_value_to_disp: '|| rec.pricing_attr_value_to_disp);
613: IF rec.pricing_attr_value_to IS NULL and
614: rec.pricing_attr_value_to_disp IS NOT NULL THEN
615: BEGIN

Line 612: qp_bulk_loader_pub.write_log('Pricing_attr_value_to_disp: '|| rec.pricing_attr_value_to_disp);

608:
609: --PRICING_ATTR_VALUE_TO
610: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value to');
611: qp_bulk_loader_pub.write_log('Pricing_attr_value_to : '|| rec.pricing_attr_value_to);
612: qp_bulk_loader_pub.write_log('Pricing_attr_value_to_disp: '|| rec.pricing_attr_value_to_disp);
613: IF rec.pricing_attr_value_to IS NULL and
614: rec.pricing_attr_value_to_disp IS NOT NULL THEN
615: BEGIN
616: l_segment_name :=QP_PRICE_LIST_LINE_UTIL.Get_Segment_Name

Line 621: qp_bulk_loader_pub.write_log('getting segment name'||l_segment_name);

617: ('QP_ATTR_DEFNS_PRICING',
618: rec.pricing_attribute_context,
619: rec.pricing_attribute);
620:
621: qp_bulk_loader_pub.write_log('getting segment name'||l_segment_name);
622:
623: qp_bulk_loader_pub.write_log('getting pricing_attr_value_to_disp using flex_meaning_to_value_id');
624: QP_Value_To_ID.Flex_Meaning_To_Value_Id(
625: p_flexfield_name => 'QP_ATTR_DEFNS_PRICING',

Line 623: qp_bulk_loader_pub.write_log('getting pricing_attr_value_to_disp using flex_meaning_to_value_id');

619: rec.pricing_attribute);
620:
621: qp_bulk_loader_pub.write_log('getting segment name'||l_segment_name);
622:
623: qp_bulk_loader_pub.write_log('getting pricing_attr_value_to_disp using flex_meaning_to_value_id');
624: QP_Value_To_ID.Flex_Meaning_To_Value_Id(
625: p_flexfield_name => 'QP_ATTR_DEFNS_PRICING',
626: p_context => rec.pricing_attribute_context,
627: p_segment => l_segment_name,

Line 639: qp_bulk_loader_pub.write_log('pricing_attr_value_to is '||l_pricing_attr_value_to);

635: ELSE
636: l_pricing_attr_value_to := x_value;
637: END IF;
638:
639: qp_bulk_loader_pub.write_log('pricing_attr_value_to is '||l_pricing_attr_value_to);
640: UPDATE QP_INTERFACE_PRICING_ATTRIBS
641: SET PRICING_ATTR_VALUE_TO = l_pricing_attr_value_to
642: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
643: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF

Line 653: qp_bulk_loader_pub.write_log('Exception Error caused'||sqlerrm);

649: SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'007'
650: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
651: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
652: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
653: qp_bulk_loader_pub.write_log('Exception Error caused'||sqlerrm);
654: END;
655: END IF;
656:
657: END LOOP;

Line 658: qp_bulk_loader_pub.write_log( 'Leaving Value to ID Lines');

654: END;
655: END IF;
656:
657: END LOOP;
658: qp_bulk_loader_pub.write_log( 'Leaving Value to ID Lines');
659:
660: EXCEPTION
661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
662: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.LINE:'||sqlerrm);

Line 662: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.LINE:'||sqlerrm);

658: qp_bulk_loader_pub.write_log( 'Leaving Value to ID Lines');
659:
660: EXCEPTION
661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
662: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.LINE:'||sqlerrm);
663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
664: WHEN OTHERS THEN
665: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.LINE:'||sqlerrm);
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 665: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.LINE:'||sqlerrm);

661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
662: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.LINE:'||sqlerrm);
663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
664: WHEN OTHERS THEN
665: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.LINE:'||sqlerrm);
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: END LINE;
668:
669:

Line 690: qp_bulk_loader_pub.write_log( 'Entering Insert Header Error Messages');

686: l_msg_txt VARCHAR2(2000);
687:
688: BEGIN
689:
690: qp_bulk_loader_pub.write_log( 'Entering Insert Header Error Messages');
691:
692: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_BULK_VALUE_TO_ID_ERROR');
693:
694: FOR l_err in c_error_records LOOP

Line 739: qp_bulk_loader_pub.write_log( 'Leaving Insert Header Error Messages');

735: <>
736: NULL;
737: END LOOP;
738:
739: qp_bulk_loader_pub.write_log( 'Leaving Insert Header Error Messages');
740:
741: EXCEPTION
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: qp_bulk_loader_pub.write_log(

Line 743: qp_bulk_loader_pub.write_log(

739: qp_bulk_loader_pub.write_log( 'Leaving Insert Header Error Messages');
740:
741: EXCEPTION
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: qp_bulk_loader_pub.write_log(
744: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_HEADER_ERROR_MESSAGES:'||sqlerrm);
745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
746: WHEN OTHERS THEN
747: qp_bulk_loader_pub.write_log(

Line 747: qp_bulk_loader_pub.write_log(

743: qp_bulk_loader_pub.write_log(
744: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_HEADER_ERROR_MESSAGES:'||sqlerrm);
745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
746: WHEN OTHERS THEN
747: qp_bulk_loader_pub.write_log(
748: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_HEADER_ERROR_MESSAGES:'||sqlerrm);
749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
750:
751: END INSERT_HEADER_ERROR_MESSAGES;

Line 774: qp_bulk_loader_pub.write_log( 'Entering Insert Qualifier Error Messages');

770: l_msg_txt VARCHAR2(2000);
771:
772: BEGIN
773:
774: qp_bulk_loader_pub.write_log( 'Entering Insert Qualifier Error Messages');
775:
776: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_BULK_VALUE_TO_ID_ERROR');
777:
778: FOR l_err in c_error_records LOOP

Line 839: qp_bulk_loader_pub.write_log( 'Leaving Insert Qualifier Error Messages');

835: END IF;
836: NULL;
837: END LOOP;
838:
839: qp_bulk_loader_pub.write_log( 'Leaving Insert Qualifier Error Messages');
840:
841: EXCEPTION
842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
843: qp_bulk_loader_pub.write_log(

Line 843: qp_bulk_loader_pub.write_log(

839: qp_bulk_loader_pub.write_log( 'Leaving Insert Qualifier Error Messages');
840:
841: EXCEPTION
842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
843: qp_bulk_loader_pub.write_log(
844: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_QUAL_ERROR_MESSAGES:'||sqlerrm);
845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
846: WHEN OTHERS THEN
847: qp_bulk_loader_pub.write_log(

Line 847: qp_bulk_loader_pub.write_log(

843: qp_bulk_loader_pub.write_log(
844: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_QUAL_ERROR_MESSAGES:'||sqlerrm);
845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
846: WHEN OTHERS THEN
847: qp_bulk_loader_pub.write_log(
848: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_QUAL_ERROR_MESSAGES:'||sqlerrm);
849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850:
851: END INSERT_QUAL_ERROR_MESSAGE;

Line 888: qp_bulk_loader_pub.write_log( 'Entering Insert Line Error Messages');

884: l_msg_data VARCHAR2(2000);
885: l_msg_txt VARCHAR2(2000);
886:
887: BEGIN
888: qp_bulk_loader_pub.write_log( 'Entering Insert Line Error Messages');
889:
890: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_BULK_VALUE_TO_ID_ERROR');
891:
892: FOR l_err in c_error_records LOOP

Line 1009: qp_bulk_loader_pub.write_log( 'Leaving Insert Line Error Messages');

1005: <>
1006: NULL;
1007: END LOOP;
1008:
1009: qp_bulk_loader_pub.write_log( 'Leaving Insert Line Error Messages');
1010:
1011: EXCEPTION
1012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1013: qp_bulk_loader_pub.write_log(

Line 1013: qp_bulk_loader_pub.write_log(

1009: qp_bulk_loader_pub.write_log( 'Leaving Insert Line Error Messages');
1010:
1011: EXCEPTION
1012: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1013: qp_bulk_loader_pub.write_log(
1014: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_LINE_ERROR_MESSAGES:'||sqlerrm);
1015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1016: WHEN OTHERS THEN
1017: qp_bulk_loader_pub.write_log(

Line 1017: qp_bulk_loader_pub.write_log(

1013: qp_bulk_loader_pub.write_log(
1014: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_LINE_ERROR_MESSAGES:'||sqlerrm);
1015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1016: WHEN OTHERS THEN
1017: qp_bulk_loader_pub.write_log(
1018: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_LINE_ERROR_MESSAGES:'||sqlerrm);
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020:
1021: END INSERT_LINE_ERROR_MESSAGE;