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: --Query is commented for bug 10065970 smbalara
360:
361: /* UPDATE /*+ index(qipa QP_INTERFACE_PRCNG_ATTRIBS_N1) */ /*QP_INTERFACE_PRICING_ATTRIBS qipa --7323577
362: SET (PRODUCT_ATTR_VALUE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=

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

405: --bug 10065970 smbalara end
406:
407:
408: --6. Product_Attr_Value
409: qp_bulk_loader_pub.write_log( 'Entering Value to ID Lines Product Attribute Value2');
410: UPDATE QP_INTERFACE_PRICING_ATTRIBS qipa
411: SET (PRODUCT_ATTR_VALUE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
412: (SELECT a.category_id,
413: DECODE(a.category_id, NULL, null, 'P'),

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

426: AND qipa.INTERFACE_ACTION_CODE IN ('INSERT','UPDATE');
427:
428: FOR rec IN c_price_attr
429: LOOP
430: qp_bulk_loader_pub.write_log('In the Pricing attr value to id loop');
431: qp_bulk_loader_pub.write_log('product_attr_code: '|| rec.product_attr_code);
432: qp_bulk_loader_pub.write_log('product_attribute: '|| rec.product_attribute);
433: --PRODUCT_ATTRIBUTE
434: --PRODUCT_ATTR_VALUE

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

427:
428: FOR rec IN c_price_attr
429: LOOP
430: qp_bulk_loader_pub.write_log('In the Pricing attr value to id loop');
431: qp_bulk_loader_pub.write_log('product_attr_code: '|| rec.product_attr_code);
432: qp_bulk_loader_pub.write_log('product_attribute: '|| rec.product_attribute);
433: --PRODUCT_ATTRIBUTE
434: --PRODUCT_ATTR_VALUE
435:

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

428: FOR rec IN c_price_attr
429: LOOP
430: qp_bulk_loader_pub.write_log('In the Pricing attr value to id loop');
431: qp_bulk_loader_pub.write_log('product_attr_code: '|| rec.product_attr_code);
432: qp_bulk_loader_pub.write_log('product_attribute: '|| rec.product_attribute);
433: --PRODUCT_ATTRIBUTE
434: --PRODUCT_ATTR_VALUE
435:
436: l_product_attr_value := null; --bug7315184

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

434: --PRODUCT_ATTR_VALUE
435:
436: l_product_attr_value := null; --bug7315184
437:
438: qp_bulk_loader_pub.write_log('Product_attribute_context/product attribute'||rec.product_attribute_context||l_product_attribute);
439: IF rec.product_attribute_context='ITEM'
440: and rec.product_attribute='PRICING_ATTRIBUTE1' THEN
441: NULL;
442: ELSIF rec.product_attribute_context='ITEM'

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

442: ELSIF rec.product_attribute_context='ITEM'
443: and rec.product_attribute='PRICING_ATTRIBUTE2' THEN
444: NULL;
445: ELSE
446: qp_bulk_loader_pub.write_log('Product context/attribute is not Item nor category');
447: if rec.product_attr_val_disp is not NULL and
448: rec.product_attr_value is NULL then
449: BEGIN
450: l_segment_name :=QP_PRICE_LIST_LINE_UTIL.Get_Segment_Name

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

451: ('QP_ATTR_DEFNS_PRICING',
452: rec.product_attribute_context,
453: rec.product_attribute);
454:
455: qp_bulk_loader_pub.write_log('getting segment name'||l_segment_name);
456: /*
457: QP_Value_To_ID.Flex_Meaning_To_Value_Id(
458: p_flexfield_name => 'QP_ATTR_DEFNS_PRICING',
459: p_context => rec.product_attribute_context,

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

466: QP_UTIL.Get_Valueset_Id('QP_ATTR_DEFNS_PRICING',
467: rec.product_attribute_context,
468: l_segment_name,
469: x_vsid, x_format_type, x_validation_type);
470: qp_bulk_loader_pub.write_log('vsid: '||to_char(x_vsid));
471: FND_VSET.get_valueset(x_vsid, vset, fmt);
472: FND_VSET.get_value_init(vset, TRUE);
473: FND_VSET.get_value(vset, row, found, value);
474:

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

472: FND_VSET.get_value_init(vset, TRUE);
473: FND_VSET.get_value(vset, row, found, value);
474:
475: WHILE (found) LOOP
476: qp_bulk_loader_pub.write_log('meaning: '||value.meaning);
477: IF (fmt.has_meaning AND
478: ltrim(rtrim(value.meaning))=ltrim(rtrim(rec.product_attr_val_disp))
479: ) OR
480: ltrim(rtrim(value.value)) = ltrim(rtrim(rec.product_attr_val_disp))

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

478: ltrim(rtrim(value.meaning))=ltrim(rtrim(rec.product_attr_val_disp))
479: ) OR
480: ltrim(rtrim(value.value)) = ltrim(rtrim(rec.product_attr_val_disp))
481: THEN
482: qp_bulk_loader_pub.write_log('success: ');
483:
484: IF fmt.has_id THEN
485: qp_bulk_loader_pub.write_log('fmt.has_id');
486: x_id := value.id;

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

481: THEN
482: qp_bulk_loader_pub.write_log('success: ');
483:
484: IF fmt.has_id THEN
485: qp_bulk_loader_pub.write_log('fmt.has_id');
486: x_id := value.id;
487: x_value := value.value;
488: ELSE
489: x_value := value.value;

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

497: END LOOP;
498:
499: FND_VSET.get_value_end(vset);
500:
501: qp_bulk_loader_pub.write_log('x_value/x_id: ' || x_value || '/' || x_id);
502: if x_value is NULL then
503: x_value := rec.product_attr_val_disp;
504: --If a match is not found in the valueset.
505: end if;

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

503: x_value := rec.product_attr_val_disp;
504: --If a match is not found in the valueset.
505: end if;
506:
507: qp_bulk_loader_pub.write_log('getting product_attr_value using flex_meaning_to_value_id');
508: qp_bulk_loader_pub.write_log('product_attr_val_disp '||rec.product_attr_val_disp);
509:
510: IF x_id IS NOT NULL THEN
511: l_product_attr_value := x_id;

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

504: --If a match is not found in the valueset.
505: end if;
506:
507: qp_bulk_loader_pub.write_log('getting product_attr_value using flex_meaning_to_value_id');
508: qp_bulk_loader_pub.write_log('product_attr_val_disp '||rec.product_attr_val_disp);
509:
510: IF x_id IS NOT NULL THEN
511: l_product_attr_value := x_id;
512: ELSE

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

512: ELSE
513: l_product_attr_value := x_value;
514: END IF;
515:
516: qp_bulk_loader_pub.write_log('product_attr_value is '||l_product_attr_value);
517: IF l_product_attr_value IS NULL THEN
518: qp_bulk_loader_pub.write_log('product_attr_value is NULL - ERROR');
519: UPDATE QP_INTERFACE_PRICING_ATTRIBS
520: SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'004'

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

514: END IF;
515:
516: qp_bulk_loader_pub.write_log('product_attr_value is '||l_product_attr_value);
517: IF l_product_attr_value IS NULL THEN
518: qp_bulk_loader_pub.write_log('product_attr_value is NULL - ERROR');
519: UPDATE QP_INTERFACE_PRICING_ATTRIBS
520: SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'004'
521: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
522: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF

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

534: SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'004'
535: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
536: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
537: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
538: qp_bulk_loader_pub.write_log('Exception Error caused'||sqlerrm);
539: END;
540: END IF; -- product_attr_val is NULL
541: END IF;
542:

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

552: end if;
553: if l_orig_sys_line_ref IS NULL or
554: l_orig_sys_line_ref <> REC.orig_sys_line_ref then
555: l_orig_sys_line_ref := REC.ORIG_SYS_LINE_REF;
556: qp_bulk_loader_pub.write_log('default line precedence once for a line');
557: qp_bulk_loader_pub.write_log('Context/Attribute/Value'||rec.product_attribute_context||'/'||l_product_attribute||'/'||l_product_attr_value);
558: QP_UTIL.validate_qp_flexfield(
559: flexfield_name=> 'QP_ATTR_DEFNS_PRICING'
560: ,context =>rec.product_attribute_context

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

553: if l_orig_sys_line_ref IS NULL or
554: l_orig_sys_line_ref <> REC.orig_sys_line_ref then
555: l_orig_sys_line_ref := REC.ORIG_SYS_LINE_REF;
556: qp_bulk_loader_pub.write_log('default line precedence once for a line');
557: qp_bulk_loader_pub.write_log('Context/Attribute/Value'||rec.product_attribute_context||'/'||l_product_attribute||'/'||l_product_attr_value);
558: QP_UTIL.validate_qp_flexfield(
559: flexfield_name=> 'QP_ATTR_DEFNS_PRICING'
560: ,context =>rec.product_attribute_context
561: ,attribute =>rec.product_attribute

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

568: ,precedence =>l_precedence
569: ,error_code =>l_error_code
570: );
571:
572: qp_bulk_loader_pub.write_log('line ref'||rec.orig_sys_line_ref||'error_code'||to_char(l_error_code));
573: If l_error_code = 0 Then
574: UPDATE QP_INTERFACE_LIST_LINES
575: SET PRODUCT_PRECEDENCE = l_precedence
576: WHERE ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF

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

585: end if;
586: end if;
587: end if;
588: --PRICING_ATTRIBUTE
589: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attribute');
590: qp_bulk_loader_pub.write_log('Pricing_attr_code: '|| rec.pricing_attr_code);
591: qp_bulk_loader_pub.write_log('Pricing_attribute: '|| rec.pricing_attribute);
592: --PRICING_ATTR_VALUE_FROM
593: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value from');

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

586: end if;
587: end if;
588: --PRICING_ATTRIBUTE
589: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attribute');
590: qp_bulk_loader_pub.write_log('Pricing_attr_code: '|| rec.pricing_attr_code);
591: qp_bulk_loader_pub.write_log('Pricing_attribute: '|| rec.pricing_attribute);
592: --PRICING_ATTR_VALUE_FROM
593: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value from');
594: qp_bulk_loader_pub.write_log('Pricing_attr_value_from : '|| rec.pricing_attr_value_from);

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

587: end if;
588: --PRICING_ATTRIBUTE
589: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attribute');
590: qp_bulk_loader_pub.write_log('Pricing_attr_code: '|| rec.pricing_attr_code);
591: qp_bulk_loader_pub.write_log('Pricing_attribute: '|| rec.pricing_attribute);
592: --PRICING_ATTR_VALUE_FROM
593: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value from');
594: qp_bulk_loader_pub.write_log('Pricing_attr_value_from : '|| rec.pricing_attr_value_from);
595: qp_bulk_loader_pub.write_log('Pricing_attr_value_from_disp: '|| rec.pricing_attr_value_from_disp);

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

589: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attribute');
590: qp_bulk_loader_pub.write_log('Pricing_attr_code: '|| rec.pricing_attr_code);
591: qp_bulk_loader_pub.write_log('Pricing_attribute: '|| rec.pricing_attribute);
592: --PRICING_ATTR_VALUE_FROM
593: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value from');
594: qp_bulk_loader_pub.write_log('Pricing_attr_value_from : '|| rec.pricing_attr_value_from);
595: qp_bulk_loader_pub.write_log('Pricing_attr_value_from_disp: '|| rec.pricing_attr_value_from_disp);
596: IF rec.pricing_attr_value_from IS NULL and
597: rec.pricing_attr_value_from_disp IS NOT NULL THEN

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

590: qp_bulk_loader_pub.write_log('Pricing_attr_code: '|| rec.pricing_attr_code);
591: qp_bulk_loader_pub.write_log('Pricing_attribute: '|| rec.pricing_attribute);
592: --PRICING_ATTR_VALUE_FROM
593: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value from');
594: qp_bulk_loader_pub.write_log('Pricing_attr_value_from : '|| rec.pricing_attr_value_from);
595: qp_bulk_loader_pub.write_log('Pricing_attr_value_from_disp: '|| rec.pricing_attr_value_from_disp);
596: IF rec.pricing_attr_value_from IS NULL and
597: rec.pricing_attr_value_from_disp IS NOT NULL THEN
598: BEGIN

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

591: qp_bulk_loader_pub.write_log('Pricing_attribute: '|| rec.pricing_attribute);
592: --PRICING_ATTR_VALUE_FROM
593: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value from');
594: qp_bulk_loader_pub.write_log('Pricing_attr_value_from : '|| rec.pricing_attr_value_from);
595: qp_bulk_loader_pub.write_log('Pricing_attr_value_from_disp: '|| rec.pricing_attr_value_from_disp);
596: IF rec.pricing_attr_value_from IS NULL and
597: rec.pricing_attr_value_from_disp IS NOT NULL THEN
598: BEGIN
599: l_segment_name :=QP_PRICE_LIST_LINE_UTIL.Get_Segment_Name

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

599: l_segment_name :=QP_PRICE_LIST_LINE_UTIL.Get_Segment_Name
600: ('QP_ATTR_DEFNS_PRICING',
601: rec.pricing_attribute_context,
602: rec.pricing_attribute);
603: qp_bulk_loader_pub.write_log('getting segment name'||l_segment_name);
604:
605: qp_bulk_loader_pub.write_log('getting pricing_attr_value_from_disp using flex_meaning_to_value_id');
606: QP_Value_To_ID.Flex_Meaning_To_Value_Id(
607: p_flexfield_name => 'QP_ATTR_DEFNS_PRICING',

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

601: rec.pricing_attribute_context,
602: rec.pricing_attribute);
603: qp_bulk_loader_pub.write_log('getting segment name'||l_segment_name);
604:
605: qp_bulk_loader_pub.write_log('getting pricing_attr_value_from_disp using flex_meaning_to_value_id');
606: QP_Value_To_ID.Flex_Meaning_To_Value_Id(
607: p_flexfield_name => 'QP_ATTR_DEFNS_PRICING',
608: p_context => rec.pricing_attribute_context,
609: p_segment => l_segment_name,

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

618: ELSE
619: l_pricing_attr_value_from := x_value;
620: END IF;
621:
622: qp_bulk_loader_pub.write_log('pricing_attr_value_from is '||l_pricing_attr_value_from);
623: UPDATE QP_INTERFACE_PRICING_ATTRIBS
624: SET PRICING_ATTR_VALUE_FROM = l_pricing_attr_value_from
625: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
626: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF

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

632: SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'006'
633: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
634: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
635: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
636: qp_bulk_loader_pub.write_log('Exception Error caused'||sqlerrm);
637: END;
638: END IF;
639:
640: --PRICING_ATTR_VALUE_TO

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

637: END;
638: END IF;
639:
640: --PRICING_ATTR_VALUE_TO
641: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value to');
642: qp_bulk_loader_pub.write_log('Pricing_attr_value_to : '|| rec.pricing_attr_value_to);
643: qp_bulk_loader_pub.write_log('Pricing_attr_value_to_disp: '|| rec.pricing_attr_value_to_disp);
644: IF rec.pricing_attr_value_to IS NULL and
645: rec.pricing_attr_value_to_disp IS NOT NULL THEN

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

638: END IF;
639:
640: --PRICING_ATTR_VALUE_TO
641: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value to');
642: qp_bulk_loader_pub.write_log('Pricing_attr_value_to : '|| rec.pricing_attr_value_to);
643: qp_bulk_loader_pub.write_log('Pricing_attr_value_to_disp: '|| rec.pricing_attr_value_to_disp);
644: IF rec.pricing_attr_value_to IS NULL and
645: rec.pricing_attr_value_to_disp IS NOT NULL THEN
646: BEGIN

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

639:
640: --PRICING_ATTR_VALUE_TO
641: qp_bulk_loader_pub.write_log('Value to ID for Pricing Attr value to');
642: qp_bulk_loader_pub.write_log('Pricing_attr_value_to : '|| rec.pricing_attr_value_to);
643: qp_bulk_loader_pub.write_log('Pricing_attr_value_to_disp: '|| rec.pricing_attr_value_to_disp);
644: IF rec.pricing_attr_value_to IS NULL and
645: rec.pricing_attr_value_to_disp IS NOT NULL THEN
646: BEGIN
647: l_segment_name :=QP_PRICE_LIST_LINE_UTIL.Get_Segment_Name

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

648: ('QP_ATTR_DEFNS_PRICING',
649: rec.pricing_attribute_context,
650: rec.pricing_attribute);
651:
652: qp_bulk_loader_pub.write_log('getting segment name'||l_segment_name);
653:
654: qp_bulk_loader_pub.write_log('getting pricing_attr_value_to_disp using flex_meaning_to_value_id');
655: QP_Value_To_ID.Flex_Meaning_To_Value_Id(
656: p_flexfield_name => 'QP_ATTR_DEFNS_PRICING',

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

650: rec.pricing_attribute);
651:
652: qp_bulk_loader_pub.write_log('getting segment name'||l_segment_name);
653:
654: qp_bulk_loader_pub.write_log('getting pricing_attr_value_to_disp using flex_meaning_to_value_id');
655: QP_Value_To_ID.Flex_Meaning_To_Value_Id(
656: p_flexfield_name => 'QP_ATTR_DEFNS_PRICING',
657: p_context => rec.pricing_attribute_context,
658: p_segment => l_segment_name,

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

666: ELSE
667: l_pricing_attr_value_to := x_value;
668: END IF;
669:
670: qp_bulk_loader_pub.write_log('pricing_attr_value_to is '||l_pricing_attr_value_to);
671: UPDATE QP_INTERFACE_PRICING_ATTRIBS
672: SET PRICING_ATTR_VALUE_TO = l_pricing_attr_value_to
673: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
674: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF

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

680: SET PROCESS_STATUS_FLAG=NULL, ATTRIBUTE_STATUS=ATTRIBUTE_STATUS||'007'
681: WHERE ORIG_SYS_PRICING_ATTR_REF = REC.ORIG_SYS_PRICING_ATTR_REF
682: AND ORIG_SYS_HEADER_REF = REC.ORIG_SYS_HEADER_REF
683: AND ORIG_SYS_LINE_REF = REC.ORIG_SYS_LINE_REF;
684: qp_bulk_loader_pub.write_log('Exception Error caused'||sqlerrm);
685: END;
686: END IF;
687:
688: END LOOP;

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

685: END;
686: END IF;
687:
688: END LOOP;
689: qp_bulk_loader_pub.write_log( 'Leaving Value to ID Lines');
690:
691: EXCEPTION
692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
693: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.LINE:'||sqlerrm);

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

689: qp_bulk_loader_pub.write_log( 'Leaving Value to ID Lines');
690:
691: EXCEPTION
692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
693: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.LINE:'||sqlerrm);
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: WHEN OTHERS THEN
696: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.LINE:'||sqlerrm);
697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
693: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.LINE:'||sqlerrm);
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: WHEN OTHERS THEN
696: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.LINE:'||sqlerrm);
697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
698: END LINE;
699:
700:

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

717: l_msg_txt VARCHAR2(2000);
718:
719: BEGIN
720:
721: qp_bulk_loader_pub.write_log( 'Entering Insert Header Error Messages');
722:
723: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_BULK_VALUE_TO_ID_ERROR');
724:
725: FOR l_err in c_error_records LOOP

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

766: <>
767: NULL;
768: END LOOP;
769:
770: qp_bulk_loader_pub.write_log( 'Leaving Insert Header Error Messages');
771:
772: EXCEPTION
773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
774: qp_bulk_loader_pub.write_log(

Line 774: qp_bulk_loader_pub.write_log(

770: qp_bulk_loader_pub.write_log( 'Leaving Insert Header Error Messages');
771:
772: EXCEPTION
773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
774: qp_bulk_loader_pub.write_log(
775: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_HEADER_ERROR_MESSAGES:'||sqlerrm);
776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
777: WHEN OTHERS THEN
778: qp_bulk_loader_pub.write_log(

Line 778: qp_bulk_loader_pub.write_log(

774: qp_bulk_loader_pub.write_log(
775: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_HEADER_ERROR_MESSAGES:'||sqlerrm);
776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
777: WHEN OTHERS THEN
778: qp_bulk_loader_pub.write_log(
779: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_HEADER_ERROR_MESSAGES:'||sqlerrm);
780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
781:
782: END INSERT_HEADER_ERROR_MESSAGES;

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

801: l_msg_txt VARCHAR2(2000);
802:
803: BEGIN
804:
805: qp_bulk_loader_pub.write_log( 'Entering Insert Qualifier Error Messages');
806:
807: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_BULK_VALUE_TO_ID_ERROR');
808:
809: FOR l_err in c_error_records LOOP

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

866: END IF;
867: NULL;
868: END LOOP;
869:
870: qp_bulk_loader_pub.write_log( 'Leaving Insert Qualifier Error Messages');
871:
872: EXCEPTION
873: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
874: qp_bulk_loader_pub.write_log(

Line 874: qp_bulk_loader_pub.write_log(

870: qp_bulk_loader_pub.write_log( 'Leaving Insert Qualifier Error Messages');
871:
872: EXCEPTION
873: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
874: qp_bulk_loader_pub.write_log(
875: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_QUAL_ERROR_MESSAGES:'||sqlerrm);
876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
877: WHEN OTHERS THEN
878: qp_bulk_loader_pub.write_log(

Line 878: qp_bulk_loader_pub.write_log(

874: qp_bulk_loader_pub.write_log(
875: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_QUAL_ERROR_MESSAGES:'||sqlerrm);
876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
877: WHEN OTHERS THEN
878: qp_bulk_loader_pub.write_log(
879: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_QUAL_ERROR_MESSAGES:'||sqlerrm);
880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
881:
882: END INSERT_QUAL_ERROR_MESSAGE;

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

915: l_msg_data VARCHAR2(2000);
916: l_msg_txt VARCHAR2(2000);
917:
918: BEGIN
919: qp_bulk_loader_pub.write_log( 'Entering Insert Line Error Messages');
920:
921: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_BULK_VALUE_TO_ID_ERROR');
922:
923: FOR l_err in c_error_records LOOP

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

1036: <>
1037: NULL;
1038: END LOOP;
1039:
1040: qp_bulk_loader_pub.write_log( 'Leaving Insert Line Error Messages');
1041:
1042: EXCEPTION
1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: qp_bulk_loader_pub.write_log(

Line 1044: qp_bulk_loader_pub.write_log(

1040: qp_bulk_loader_pub.write_log( 'Leaving Insert Line Error Messages');
1041:
1042: EXCEPTION
1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: qp_bulk_loader_pub.write_log(
1045: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_LINE_ERROR_MESSAGES:'||sqlerrm);
1046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1047: WHEN OTHERS THEN
1048: qp_bulk_loader_pub.write_log(

Line 1048: qp_bulk_loader_pub.write_log(

1044: qp_bulk_loader_pub.write_log(
1045: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_LINE_ERROR_MESSAGES:'||sqlerrm);
1046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1047: WHEN OTHERS THEN
1048: qp_bulk_loader_pub.write_log(
1049: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_LINE_ERROR_MESSAGES:'||sqlerrm);
1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1051:
1052: END INSERT_LINE_ERROR_MESSAGE;