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_UTIL dependencies on QP_BULK_LOADER_PUB

Line 6: ,X_HEADER_REC OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE

2: /* $Header: QPXBUTLB.pls 120.12.12010000.3 2009/05/07 07:11:30 dnema ship $ */
3:
4: PROCEDURE LOAD_INS_HEADER
5: ( P_REQUEST_ID IN NUMBER
6: ,X_HEADER_REC OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE
7: )
8: IS
9:
10: CURSOR C_PL_HEADER IS

Line 87: qp_bulk_loader_pub.write_log('Entering Loading Ins Header');

83: AND process_status_flag = 'P' --IS NULL
84: AND interface_action_code='INSERT';
85:
86: BEGIN
87: qp_bulk_loader_pub.write_log('Entering Loading Ins Header');
88: OPEN C_PL_HEADER;
89: FETCH C_PL_HEADER BULK COLLECT
90: INTO x_header_rec.list_header_id
91: ,x_header_rec.creation_date

Line 161: qp_bulk_loader_pub.write_log('Leaving Loading Ins Header');

157: ,x_header_rec.global_flag;
158:
159: CLOSE C_PL_HEADER;
160:
161: qp_bulk_loader_pub.write_log('Leaving Loading Ins Header');
162:
163: EXCEPTION
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_INS_HEADER:'||sqlerrm);

Line 165: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_INS_HEADER:'||sqlerrm);

161: qp_bulk_loader_pub.write_log('Leaving Loading Ins Header');
162:
163: EXCEPTION
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_INS_HEADER:'||sqlerrm);
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: WHEN OTHERS THEN
168: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_INS_HEADER:'||sqlerrm);
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 168: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_INS_HEADER:'||sqlerrm);

164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_INS_HEADER:'||sqlerrm);
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: WHEN OTHERS THEN
168: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_INS_HEADER:'||sqlerrm);
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170:
171: END LOAD_INS_HEADER;
172:

Line 175: ,X_HEADER_REC OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE

171: END LOAD_INS_HEADER;
172:
173: PROCEDURE LOAD_UDT_HEADER
174: ( P_REQUEST_ID IN NUMBER
175: ,X_HEADER_REC OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE
176: )
177: IS
178:
179:

Line 262: qp_bulk_loader_pub.write_log('Entering Loading Udt Header');

258: AND a.process_status_flag = 'P' --IS NULL
259: AND a.interface_action_code='UPDATE';
260:
261: BEGIN
262: qp_bulk_loader_pub.write_log('Entering Loading Udt Header');
263:
264: OPEN C_PL_HEADER;
265: FETCH C_PL_HEADER BULK COLLECT
266: INTO x_header_rec.list_header_id

Line 337: qp_bulk_loader_pub.write_log('Leaving Loading Udt Header');

333: ,x_header_rec.global_flag;
334:
335: CLOSE C_PL_HEADER;
336:
337: qp_bulk_loader_pub.write_log('Leaving Loading Udt Header');
338:
339: EXCEPTION
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_UDT_HEADER:'||sqlerrm);

Line 341: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_UDT_HEADER:'||sqlerrm);

337: qp_bulk_loader_pub.write_log('Leaving Loading Udt Header');
338:
339: EXCEPTION
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_UDT_HEADER:'||sqlerrm);
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: WHEN OTHERS THEN
344: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_UDT_HEADER:'||sqlerrm);
345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 344: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_UDT_HEADER:'||sqlerrm);

340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_UDT_HEADER:'||sqlerrm);
342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
343: WHEN OTHERS THEN
344: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.LOAD_UDT_HEADER:'||sqlerrm);
345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
346:
347:
348: END LOAD_UDT_HEADER;

Line 352: (p_header_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE)

348: END LOAD_UDT_HEADER;
349:
350:
351: PROCEDURE INSERT_HEADER
352: (p_header_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE)
353: IS
354: x_result varchar2(1);
355: BEGIN
356: qp_bulk_loader_pub.write_log('Entering Insert Header');

Line 356: qp_bulk_loader_pub.write_log('Entering Insert Header');

352: (p_header_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE)
353: IS
354: x_result varchar2(1);
355: BEGIN
356: qp_bulk_loader_pub.write_log('Entering Insert Header');
357: FORALL I IN
358: P_HEADER_REC.list_header_id.FIRST..P_HEADER_REC.list_header_id.LAST
359:
360: INSERT INTO qp_list_headers_b

Line 487: qp_bulk_loader_pub.write_log('Inserted Header records: '|| SQL%ROWCOUNT);

483: FROM DUAL
484: WHERE P_HEADER_REC.process_status_flag(I) IS NOT NULL;
485:
486:
487: qp_bulk_loader_pub.write_log('Inserted Header records: '|| SQL%ROWCOUNT);
488:
489: FORALL I IN
490: P_HEADER_REC.list_header_id.FIRST..P_HEADER_REC.list_header_id.LAST
491:

Line 537: qp_bulk_loader_pub.write_log('Leaving Insert Header');

533: x_return_status => x_result);
534: END LOOP;
535: END IF;
536:
537: qp_bulk_loader_pub.write_log('Leaving Insert Header');
538:
539: COMMIT;
540:
541: EXCEPTION

Line 543: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_HEADER:'||sqlerrm);

539: COMMIT;
540:
541: EXCEPTION
542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
543: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_HEADER:'||sqlerrm);
544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: WHEN OTHERS THEN
546: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_HEADER:'||sqlerrm);
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 546: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_HEADER:'||sqlerrm);

542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
543: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_HEADER:'||sqlerrm);
544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: WHEN OTHERS THEN
546: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_HEADER:'||sqlerrm);
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
548:
549:
550: END INSERT_HEADER;

Line 553: (p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE)

549:
550: END INSERT_HEADER;
551:
552: PROCEDURE INSERT_LINE
553: (p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE)
554: IS
555: BEGIN
556:
557: qp_bulk_loader_pub.write_log('Entering Insert Line');

Line 557: qp_bulk_loader_pub.write_log('Entering Insert Line');

553: (p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE)
554: IS
555: BEGIN
556:
557: qp_bulk_loader_pub.write_log('Entering Insert Line');
558: FORALL I IN
559: P_LINE_REC.orig_sys_line_ref.FIRST..P_LINE_REC.orig_sys_line_ref.LAST
560:
561: INSERT INTO qp_list_lines

Line 758: qp_bulk_loader_pub.write_log('Line Insert Count: '|| sql%rowcount);

754: WHERE orig_sys_line_ref=P_LINE_REC.ORIG_SYS_LINE_REF(I)
755: AND request_id=P_LINE_REC.REQUEST_ID(I)
756: AND process_status_flag is not null);
757:
758: qp_bulk_loader_pub.write_log('Line Insert Count: '|| sql%rowcount);
759: qp_bulk_loader_pub.write_log('Leaving Insert Line');
760:
761: EXCEPTION
762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 759: qp_bulk_loader_pub.write_log('Leaving Insert Line');

755: AND request_id=P_LINE_REC.REQUEST_ID(I)
756: AND process_status_flag is not null);
757:
758: qp_bulk_loader_pub.write_log('Line Insert Count: '|| sql%rowcount);
759: qp_bulk_loader_pub.write_log('Leaving Insert Line');
760:
761: EXCEPTION
762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
763: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_LINE:'||sqlerrm);

Line 763: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_LINE:'||sqlerrm);

759: qp_bulk_loader_pub.write_log('Leaving Insert Line');
760:
761: EXCEPTION
762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
763: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_LINE:'||sqlerrm);
764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
765: WHEN OTHERS THEN
766: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_LINE:'||sqlerrm);
767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 766: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_LINE:'||sqlerrm);

762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
763: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_LINE:'||sqlerrm);
764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
765: WHEN OTHERS THEN
766: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_LINE:'||sqlerrm);
767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
768:
769:
770: END INSERT_LINE;

Line 775: (p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE)

771:
772:
773: -- New procedure 6028305
774: PROCEDURE UPDATE_LINE_TO_OLD
775: (p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE)
776: IS
777: BEGIN
778:
779: qp_bulk_loader_pub.write_log('Entering Update Line'||'entered'|| p_line_rec.orig_sys_line_ref.count);

Line 779: qp_bulk_loader_pub.write_log('Entering Update Line'||'entered'|| p_line_rec.orig_sys_line_ref.count);

775: (p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE)
776: IS
777: BEGIN
778:
779: qp_bulk_loader_pub.write_log('Entering Update Line'||'entered'|| p_line_rec.orig_sys_line_ref.count);
780: FOR I IN
781: P_LINE_REC.orig_sys_line_ref.FIRST..P_LINE_REC.orig_sys_line_ref.LAST
782: loop
783: --qp_bulk_loader_pub.write_log('count'|| i);

Line 783: --qp_bulk_loader_pub.write_log('count'|| i);

779: qp_bulk_loader_pub.write_log('Entering Update Line'||'entered'|| p_line_rec.orig_sys_line_ref.count);
780: FOR I IN
781: P_LINE_REC.orig_sys_line_ref.FIRST..P_LINE_REC.orig_sys_line_ref.LAST
782: loop
783: --qp_bulk_loader_pub.write_log('count'|| i);
784: UPDATE qp_list_lines
785: SET LAST_UPDATE_DATE =sysdate
786: ,LAST_UPDATED_BY =FND_GLOBAL.USER_ID
787: ,LAST_UPDATE_LOGIN =FND_GLOBAL.CONC_LOGIN_ID

Line 882: qp_bulk_loader_pub.write_log('Lines Records Updated: '|| sql%rowcount);

878: from qp_interface_pricing_Attribs
879: where process_Status_flag is NULL
880: AND request_id=P_LINE_REC.REQUEST_ID(I)); -- updating for erred records
881: end loop;
882: qp_bulk_loader_pub.write_log('Lines Records Updated: '|| sql%rowcount);
883: qp_bulk_loader_pub.write_log('Leaving Update Line old');
884:
885: EXCEPTION
886: when no_data_found then

Line 883: qp_bulk_loader_pub.write_log('Leaving Update Line old');

879: where process_Status_flag is NULL
880: AND request_id=P_LINE_REC.REQUEST_ID(I)); -- updating for erred records
881: end loop;
882: qp_bulk_loader_pub.write_log('Lines Records Updated: '|| sql%rowcount);
883: qp_bulk_loader_pub.write_log('Leaving Update Line old');
884:
885: EXCEPTION
886: when no_data_found then
887: qp_bulk_loader_pub.write_log( 'NO data found QP_BULK_UTIL.UPDATE_LINE_TO_OLD');

Line 887: qp_bulk_loader_pub.write_log( 'NO data found QP_BULK_UTIL.UPDATE_LINE_TO_OLD');

883: qp_bulk_loader_pub.write_log('Leaving Update Line old');
884:
885: EXCEPTION
886: when no_data_found then
887: qp_bulk_loader_pub.write_log( 'NO data found QP_BULK_UTIL.UPDATE_LINE_TO_OLD');
888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
890: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE_TO_OLD:'||sqlerrm);
891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 890: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE_TO_OLD:'||sqlerrm);

886: when no_data_found then
887: qp_bulk_loader_pub.write_log( 'NO data found QP_BULK_UTIL.UPDATE_LINE_TO_OLD');
888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
890: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE_TO_OLD:'||sqlerrm);
891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
892: WHEN OTHERS THEN
893: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE_TO_OLD:'||sqlerrm);
894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 893: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE_TO_OLD:'||sqlerrm);

889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
890: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE_TO_OLD:'||sqlerrm);
891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
892: WHEN OTHERS THEN
893: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE_TO_OLD:'||sqlerrm);
894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
895:
896:
897: END UPDATE_LINE_TO_OLD;

Line 902: (P_QUALIFIER_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Qualifier_Rec_Type)

898: -- End New procedure 6028305
899:
900:
901: PROCEDURE INSERT_QUALIFIER
902: (P_QUALIFIER_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Qualifier_Rec_Type)
903: IS
904: BEGIN
905:
906: qp_bulk_loader_pub.write_log('Entering Insert Qualifier');

Line 906: qp_bulk_loader_pub.write_log('Entering Insert Qualifier');

902: (P_QUALIFIER_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Qualifier_Rec_Type)
903: IS
904: BEGIN
905:
906: qp_bulk_loader_pub.write_log('Entering Insert Qualifier');
907: FORALL I IN
908: P_QUALIFIER_REC.orig_sys_qualifier_ref.FIRST..P_QUALIFIER_REC.orig_sys_qualifier_ref.LAST
909:
910: INSERT INTO qp_qualifiers

Line 1016: qp_bulk_loader_pub.write_log('Inserted Qualifier Count: '|| sql%rowcount);

1012: ,P_QUALIFIER_REC.ORIG_SYS_HEADER_REF(I)
1013: ,P_QUALIFIER_REC.ORIG_SYS_LINE_REF(I)
1014: ,P_QUALIFIER_REC.QUALIFY_HIER_DESCENDENTS_FLAG(I)
1015: );
1016: qp_bulk_loader_pub.write_log('Inserted Qualifier Count: '|| sql%rowcount);
1017: qp_bulk_loader_pub.write_log('Leaving Insert Qualifier');
1018:
1019: EXCEPTION
1020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1017: qp_bulk_loader_pub.write_log('Leaving Insert Qualifier');

1013: ,P_QUALIFIER_REC.ORIG_SYS_LINE_REF(I)
1014: ,P_QUALIFIER_REC.QUALIFY_HIER_DESCENDENTS_FLAG(I)
1015: );
1016: qp_bulk_loader_pub.write_log('Inserted Qualifier Count: '|| sql%rowcount);
1017: qp_bulk_loader_pub.write_log('Leaving Insert Qualifier');
1018:
1019: EXCEPTION
1020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1021: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_QUALIFIER:'||sqlerrm);

Line 1021: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_QUALIFIER:'||sqlerrm);

1017: qp_bulk_loader_pub.write_log('Leaving Insert Qualifier');
1018:
1019: EXCEPTION
1020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1021: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_QUALIFIER:'||sqlerrm);
1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023: WHEN OTHERS THEN
1024: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_QUALIFIER:'||sqlerrm);
1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1024: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_QUALIFIER:'||sqlerrm);

1020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1021: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_QUALIFIER:'||sqlerrm);
1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023: WHEN OTHERS THEN
1024: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_QUALIFIER:'||sqlerrm);
1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1026:
1027: END INSERT_QUALIFIER;
1028:

Line 1030: (P_PRICING_ATTR_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Pricing_Attr_Rec_Type)

1026:
1027: END INSERT_QUALIFIER;
1028:
1029: PROCEDURE INSERT_PRICING_ATTR
1030: (P_PRICING_ATTR_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Pricing_Attr_Rec_Type)
1031: IS
1032: BEGIN
1033:
1034: qp_bulk_loader_pub.write_log('Entering Insert Pricing Attribute');

Line 1034: qp_bulk_loader_pub.write_log('Entering Insert Pricing Attribute');

1030: (P_PRICING_ATTR_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Pricing_Attr_Rec_Type)
1031: IS
1032: BEGIN
1033:
1034: qp_bulk_loader_pub.write_log('Entering Insert Pricing Attribute');
1035: FORALL I IN
1036: P_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.FIRST
1037: ..P_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.LAST
1038:

Line 1151: qp_bulk_loader_pub.write_log('Pricing Attr Insertcount: '|| sql%rowcount);

1147: WHERE ORIG_SYS_PRICING_ATTR_REF=P_PRICING_ATTR_REC.ORIG_SYS_PRICING_ATTR_REF(I)
1148: AND request_id=P_PRICING_ATTR_REC.REQUEST_ID(I)
1149: AND process_status_flag is not null);
1150:
1151: qp_bulk_loader_pub.write_log('Pricing Attr Insertcount: '|| sql%rowcount);
1152: qp_bulk_loader_pub.write_log('Leaving Insert Pricing Attribute');
1153:
1154: EXCEPTION
1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1152: qp_bulk_loader_pub.write_log('Leaving Insert Pricing Attribute');

1148: AND request_id=P_PRICING_ATTR_REC.REQUEST_ID(I)
1149: AND process_status_flag is not null);
1150:
1151: qp_bulk_loader_pub.write_log('Pricing Attr Insertcount: '|| sql%rowcount);
1152: qp_bulk_loader_pub.write_log('Leaving Insert Pricing Attribute');
1153:
1154: EXCEPTION
1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1156: qp_bulk_loader_pub.write_log(

Line 1156: qp_bulk_loader_pub.write_log(

1152: qp_bulk_loader_pub.write_log('Leaving Insert Pricing Attribute');
1153:
1154: EXCEPTION
1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1156: qp_bulk_loader_pub.write_log(
1157: 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_PRICING_ATTR:'||sqlerrm);
1158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1159: WHEN OTHERS THEN
1160: qp_bulk_loader_pub.write_log(

Line 1160: qp_bulk_loader_pub.write_log(

1156: qp_bulk_loader_pub.write_log(
1157: 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_PRICING_ATTR:'||sqlerrm);
1158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1159: WHEN OTHERS THEN
1160: qp_bulk_loader_pub.write_log(
1161: 'UNEXPECTED ERROR IN QP_BULK_UTIL.INSERT_PRICING_ATTR:'||sqlerrm);
1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1163:
1164: END INSERT_PRICING_ATTR;

Line 1167: (p_header_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE)

1163:
1164: END INSERT_PRICING_ATTR;
1165:
1166: PROCEDURE UPDATE_HEADER
1167: (p_header_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE)
1168: IS
1169: BEGIN
1170:
1171: qp_bulk_loader_pub.write_log('Entering Update Header');

Line 1171: qp_bulk_loader_pub.write_log('Entering Update Header');

1167: (p_header_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.HEADER_REC_TYPE)
1168: IS
1169: BEGIN
1170:
1171: qp_bulk_loader_pub.write_log('Entering Update Header');
1172: FORALL I IN
1173: P_HEADER_REC.list_header_id.FIRST..P_HEADER_REC.list_header_id.LAST
1174:
1175: UPDATE qp_list_headers_b

Line 1261: qp_bulk_loader_pub.write_log('Header Records Updated: '|| sql%rowcount);

1257: AND LANGUAGE = P_HEADER_REC.LANGUAGE(I)
1258: AND SOURCE_LANG = P_HEADER_REC.SOURCE_LANG(I)
1259: AND P_HEADER_REC.process_status_flag(I) = 'P'; --IS NULL;
1260:
1261: qp_bulk_loader_pub.write_log('Header Records Updated: '|| sql%rowcount);
1262: qp_bulk_loader_pub.write_log('Leaving Update Header');
1263:
1264: EXCEPTION
1265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1262: qp_bulk_loader_pub.write_log('Leaving Update Header');

1258: AND SOURCE_LANG = P_HEADER_REC.SOURCE_LANG(I)
1259: AND P_HEADER_REC.process_status_flag(I) = 'P'; --IS NULL;
1260:
1261: qp_bulk_loader_pub.write_log('Header Records Updated: '|| sql%rowcount);
1262: qp_bulk_loader_pub.write_log('Leaving Update Header');
1263:
1264: EXCEPTION
1265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1266: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_HEADER:'||sqlerrm);

Line 1266: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_HEADER:'||sqlerrm);

1262: qp_bulk_loader_pub.write_log('Leaving Update Header');
1263:
1264: EXCEPTION
1265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1266: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_HEADER:'||sqlerrm);
1267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1268: WHEN OTHERS THEN
1269: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_HEADER:'||sqlerrm);
1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1269: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_HEADER:'||sqlerrm);

1265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1266: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_HEADER:'||sqlerrm);
1267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1268: WHEN OTHERS THEN
1269: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_HEADER:'||sqlerrm);
1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1271:
1272: END UPDATE_HEADER;
1273:

Line 1275: (p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE)

1271:
1272: END UPDATE_HEADER;
1273:
1274: PROCEDURE UPDATE_LINE
1275: (p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE)
1276: IS
1277: BEGIN
1278:
1279: qp_bulk_loader_pub.write_log('Entering Update Line');

Line 1279: qp_bulk_loader_pub.write_log('Entering Update Line');

1275: (p_line_rec IN OUT NOCOPY QP_BULK_LOADER_PUB.LINE_REC_TYPE)
1276: IS
1277: BEGIN
1278:
1279: qp_bulk_loader_pub.write_log('Entering Update Line');
1280: FORALL I IN
1281: P_LINE_REC.orig_sys_line_ref.FIRST..P_LINE_REC.orig_sys_line_ref.LAST
1282:
1283: UPDATE qp_list_lines

Line 1383: qp_bulk_loader_pub.write_log('Lines Records Updated: '|| sql%rowcount);

1379: AND ORIG_SYS_HEADER_REF = P_LINE_REC.ORIG_SYS_HEADER_REF(I)
1380: AND PROCESS_STATUS_FLAG is not null
1381: AND REQUEST_ID=P_LINE_REC.REQUEST_ID(I)) ;
1382:
1383: qp_bulk_loader_pub.write_log('Lines Records Updated: '|| sql%rowcount);
1384: qp_bulk_loader_pub.write_log('Leaving Update Line');
1385:
1386: EXCEPTION
1387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1384: qp_bulk_loader_pub.write_log('Leaving Update Line');

1380: AND PROCESS_STATUS_FLAG is not null
1381: AND REQUEST_ID=P_LINE_REC.REQUEST_ID(I)) ;
1382:
1383: qp_bulk_loader_pub.write_log('Lines Records Updated: '|| sql%rowcount);
1384: qp_bulk_loader_pub.write_log('Leaving Update Line');
1385:
1386: EXCEPTION
1387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1388: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE:'||sqlerrm);

Line 1388: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE:'||sqlerrm);

1384: qp_bulk_loader_pub.write_log('Leaving Update Line');
1385:
1386: EXCEPTION
1387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1388: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE:'||sqlerrm);
1389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1390: WHEN OTHERS THEN
1391: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE:'||sqlerrm);
1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1391: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE:'||sqlerrm);

1387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1388: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE:'||sqlerrm);
1389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1390: WHEN OTHERS THEN
1391: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE:'||sqlerrm);
1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1393:
1394:
1395: END UPDATE_LINE;

Line 1398: (P_QUALIFIER_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Qualifier_Rec_Type)

1394:
1395: END UPDATE_LINE;
1396:
1397: PROCEDURE UPDATE_QUALIFIER
1398: (P_QUALIFIER_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Qualifier_Rec_Type)
1399:
1400: IS
1401: BEGIN
1402:

Line 1403: qp_bulk_loader_pub.write_log('Entering Update Qualifier');

1399:
1400: IS
1401: BEGIN
1402:
1403: qp_bulk_loader_pub.write_log('Entering Update Qualifier');
1404: FORALL I IN
1405: P_QUALIFIER_REC.orig_sys_qualifier_ref.FIRST..P_QUALIFIER_REC.orig_sys_qualifier_ref.LAST
1406:
1407: UPDATE qp_qualifiers

Line 1460: qp_bulk_loader_pub.write_log('Qualifier Records Updated: '|| sql%rowcount);

1456: WHERE orig_sys_qualifier_ref = P_QUALIFIER_REC.orig_sys_qualifier_ref(I)
1457: AND orig_sys_header_ref = P_QUALIFIER_REC.orig_sys_header_ref(I)
1458: AND P_QUALIFIER_REC.process_status_flag(I) = 'P'; --IS NULL;
1459:
1460: qp_bulk_loader_pub.write_log('Qualifier Records Updated: '|| sql%rowcount);
1461: qp_bulk_loader_pub.write_log('Leaving Update Qualifier');
1462:
1463: EXCEPTION
1464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1461: qp_bulk_loader_pub.write_log('Leaving Update Qualifier');

1457: AND orig_sys_header_ref = P_QUALIFIER_REC.orig_sys_header_ref(I)
1458: AND P_QUALIFIER_REC.process_status_flag(I) = 'P'; --IS NULL;
1459:
1460: qp_bulk_loader_pub.write_log('Qualifier Records Updated: '|| sql%rowcount);
1461: qp_bulk_loader_pub.write_log('Leaving Update Qualifier');
1462:
1463: EXCEPTION
1464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1465: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_QUALIFIER:'||sqlerrm);

Line 1465: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_QUALIFIER:'||sqlerrm);

1461: qp_bulk_loader_pub.write_log('Leaving Update Qualifier');
1462:
1463: EXCEPTION
1464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1465: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_QUALIFIER:'||sqlerrm);
1466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1467: WHEN OTHERS THEN
1468: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_QUALIFIER:'||sqlerrm);
1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1468: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_QUALIFIER:'||sqlerrm);

1464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1465: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_QUALIFIER:'||sqlerrm);
1466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1467: WHEN OTHERS THEN
1468: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_QUALIFIER:'||sqlerrm);
1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1470:
1471: END UPDATE_QUALIFIER;
1472:

Line 1474: (P_PRICING_ATTR_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Pricing_Attr_Rec_Type)

1470:
1471: END UPDATE_QUALIFIER;
1472:
1473: PROCEDURE UPDATE_PRICING_ATTR
1474: (P_PRICING_ATTR_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Pricing_Attr_Rec_Type)
1475: IS
1476: BEGIN
1477: qp_bulk_loader_pub.write_log('Entering Update Pricing Attribute');
1478: FORALL I IN

Line 1477: qp_bulk_loader_pub.write_log('Entering Update Pricing Attribute');

1473: PROCEDURE UPDATE_PRICING_ATTR
1474: (P_PRICING_ATTR_REC IN OUT NOCOPY QP_BULK_LOADER_PUB.Pricing_Attr_Rec_Type)
1475: IS
1476: BEGIN
1477: qp_bulk_loader_pub.write_log('Entering Update Pricing Attribute');
1478: FORALL I IN
1479: P_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.FIRST
1480: ..P_PRICING_ATTR_REC.orig_sys_pricing_attr_ref.LAST
1481:

Line 1542: qp_bulk_loader_pub.write_log('Pricing Attr Records Updated: '|| sql%rowcount);

1538: AND ORIG_SYS_HEADER_REF =P_PRICING_ATTR_REC.ORIG_SYS_HEADER_REF(I)
1539: AND REQUEST_ID= P_PRICING_ATTR_REC.REQUEST_ID(I)
1540: AND PROCESS_STATUS_FLAG is not null) ;
1541:
1542: qp_bulk_loader_pub.write_log('Pricing Attr Records Updated: '|| sql%rowcount);
1543: qp_bulk_loader_pub.write_log('Leaving Update Pricing Attribute');
1544:
1545: EXCEPTION
1546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1543: qp_bulk_loader_pub.write_log('Leaving Update Pricing Attribute');

1539: AND REQUEST_ID= P_PRICING_ATTR_REC.REQUEST_ID(I)
1540: AND PROCESS_STATUS_FLAG is not null) ;
1541:
1542: qp_bulk_loader_pub.write_log('Pricing Attr Records Updated: '|| sql%rowcount);
1543: qp_bulk_loader_pub.write_log('Leaving Update Pricing Attribute');
1544:
1545: EXCEPTION
1546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1547: qp_bulk_loader_pub.write_log(

Line 1547: qp_bulk_loader_pub.write_log(

1543: qp_bulk_loader_pub.write_log('Leaving Update Pricing Attribute');
1544:
1545: EXCEPTION
1546: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1547: qp_bulk_loader_pub.write_log(
1548: 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_PRICING_ATTR:'||sqlerrm);
1549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1550: WHEN OTHERS THEN
1551: qp_bulk_loader_pub.write_log(

Line 1551: qp_bulk_loader_pub.write_log(

1547: qp_bulk_loader_pub.write_log(
1548: 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_PRICING_ATTR:'||sqlerrm);
1549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1550: WHEN OTHERS THEN
1551: qp_bulk_loader_pub.write_log(
1552: 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_PRICING_ATTR:'||sqlerrm);
1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1554:
1555: END UPDATE_PRICING_ATTR;

Line 1564: qp_bulk_loader_pub.write_log('Entering Delete Header');

1560: l_msg_txt VARCHAR2(2000);
1561:
1562: BEGIN
1563:
1564: qp_bulk_loader_pub.write_log('Entering Delete Header');
1565:
1566: FND_MESSAGE.SET_NAME('QP', 'HDR_NOT_ALLOWED_TO_DLT');
1567: l_msg_txt := FND_MESSAGE.GET;
1568:

Line 1589: qp_bulk_loader_pub.write_log('Leaving Delete Header');

1585: SET process_status_flag = NULL --'E'
1586: WHERE request_id = p_request_id
1587: AND interface_action_code = 'DELETE';
1588:
1589: qp_bulk_loader_pub.write_log('Leaving Delete Header');
1590:
1591: EXCEPTION
1592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1593: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_HEADER:'||sqlerrm);

Line 1593: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_HEADER:'||sqlerrm);

1589: qp_bulk_loader_pub.write_log('Leaving Delete Header');
1590:
1591: EXCEPTION
1592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1593: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_HEADER:'||sqlerrm);
1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1595: WHEN OTHERS THEN
1596: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_HEADER:'||sqlerrm);
1597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1596: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_HEADER:'||sqlerrm);

1592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1593: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_HEADER:'||sqlerrm);
1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1595: WHEN OTHERS THEN
1596: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_HEADER:'||sqlerrm);
1597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1598:
1599: END DELETE_HEADER;
1600:

Line 1608: qp_bulk_loader_pub.write_log('Entering Delete Qualifier');

1604: l_msg_txt VARCHAR2(2000);
1605:
1606: BEGIN
1607:
1608: qp_bulk_loader_pub.write_log('Entering Delete Qualifier');
1609:
1610: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
1611: FND_MESSAGE.SET_TOKEN('RECORD' , 'QUALIFIER');
1612: l_msg_txt := FND_MESSAGE.GET;

Line 1651: qp_bulk_loader_pub.write_log('Qualifier Records Deleted: '|| sql%rowcount);

1647: AND iq.process_status_flag = 'P' --IS NULL
1648: AND iq.orig_sys_qualifier_ref = q.orig_sys_qualifier_ref
1649: AND iq.orig_sys_header_ref = q.orig_sys_header_ref);
1650:
1651: qp_bulk_loader_pub.write_log('Qualifier Records Deleted: '|| sql%rowcount);
1652:
1653: --Set process_status_flag of sucessfully deleted records
1654: UPDATE qp_interface_qualifiers
1655: SET process_status_flag ='I'

Line 1660: qp_bulk_loader_pub.write_log('Leaving Delete Qualifier');

1656: WHERE process_status_flag = 'P' --IS NULL
1657: AND request_id = p_request_id
1658: AND interface_action_code = 'DELETE';
1659:
1660: qp_bulk_loader_pub.write_log('Leaving Delete Qualifier');
1661:
1662: EXCEPTION
1663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1664: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_QUALIFIER:'||sqlerrm);

Line 1664: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_QUALIFIER:'||sqlerrm);

1660: qp_bulk_loader_pub.write_log('Leaving Delete Qualifier');
1661:
1662: EXCEPTION
1663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1664: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_QUALIFIER:'||sqlerrm);
1665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1666: WHEN OTHERS THEN
1667: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_QUALIFIER:'||sqlerrm);
1668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1667: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_QUALIFIER:'||sqlerrm);

1663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1664: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_QUALIFIER:'||sqlerrm);
1665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1666: WHEN OTHERS THEN
1667: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_QUALIFIER:'||sqlerrm);
1668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1669:
1670: END DELETE_QUALIFIER;
1671:

Line 1680: qp_bulk_loader_pub.write_log('Entering Delete Line');

1676: l_msg_txt VARCHAR2(2000);
1677:
1678: BEGIN
1679:
1680: qp_bulk_loader_pub.write_log('Entering Delete Line');
1681:
1682: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
1683: FND_MESSAGE.SET_TOKEN('RECORD' , 'LINE');
1684: l_msg_txt := FND_MESSAGE.GET;

Line 1778: qp_bulk_loader_pub.write_log('Leaving Delete Line');

1774: WHERE process_status_flag = 'P' --IS NULL
1775: AND request_id = p_request_id
1776: AND interface_action_code = 'DELETE';
1777:
1778: qp_bulk_loader_pub.write_log('Leaving Delete Line');
1779:
1780: EXCEPTION
1781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1782: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_LINE:'||sqlerrm);

Line 1782: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_LINE:'||sqlerrm);

1778: qp_bulk_loader_pub.write_log('Leaving Delete Line');
1779:
1780: EXCEPTION
1781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1782: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_LINE:'||sqlerrm);
1783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1784: WHEN OTHERS THEN
1785: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_LINE:'||sqlerrm);
1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1785: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_LINE:'||sqlerrm);

1781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1782: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_LINE:'||sqlerrm);
1783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1784: WHEN OTHERS THEN
1785: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_LINE:'||sqlerrm);
1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1787:
1788: END DELETE_LINE;
1789:

Line 1797: qp_bulk_loader_pub.write_log('Entering Delete Pricing Attribute');

1793: l_msg_txt VARCHAR2(2000);
1794:
1795: BEGIN
1796:
1797: qp_bulk_loader_pub.write_log('Entering Delete Pricing Attribute');
1798: FND_MESSAGE.SET_NAME('QP', 'NO_RECORD');
1799: FND_MESSAGE.SET_TOKEN('RECORD' , 'PRICING ATTRIBUTE');
1800: l_msg_txt := FND_MESSAGE.GET;
1801:

Line 1838: qp_bulk_loader_pub.write_log('Cannot delete a Price Break child line if it is not the highest break.');

1834: AND qpil.interface_action_code = 'DELETE');
1835:
1836: --Bug# 5253114 RAVI START
1837:
1838: qp_bulk_loader_pub.write_log('Cannot delete a Price Break child line if it is not the highest break.');
1839: FND_MESSAGE.SET_NAME('QP', 'QP_NO_DELETE_PB_CHILD_LINE');
1840: l_msg_txt := FND_MESSAGE.GET;
1841:
1842: INSERT INTO QP_INTERFACE_ERRORS

Line 1893: qp_bulk_loader_pub.write_log('Number of PA deleted: '||to_char(SQL%ROWCOUNT));

1889: AND ipa.orig_sys_line_ref = pa.orig_sys_line_ref
1890: AND ipa.orig_sys_header_ref = pa.orig_sys_header_ref
1891: AND ipa.orig_sys_pricing_attr_ref = pa.orig_sys_pricing_attr_ref);
1892:
1893: qp_bulk_loader_pub.write_log('Number of PA deleted: '||to_char(SQL%ROWCOUNT));
1894: --Set process_status_flag of sucessfully deleted records
1895: UPDATE qp_interface_pricing_attribs
1896: SET process_status_flag ='I'
1897: WHERE process_status_flag = 'P' --IS NULL

Line 1903: qp_bulk_loader_pub.write_log(

1899: AND interface_action_code = 'DELETE';
1900:
1901: EXCEPTION
1902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1903: qp_bulk_loader_pub.write_log(
1904: 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_PRICING_ATTR:'||sqlerrm);
1905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1906: WHEN OTHERS THEN
1907: qp_bulk_loader_pub.write_log(

Line 1907: qp_bulk_loader_pub.write_log(

1903: qp_bulk_loader_pub.write_log(
1904: 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_PRICING_ATTR:'||sqlerrm);
1905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1906: WHEN OTHERS THEN
1907: qp_bulk_loader_pub.write_log(
1908: 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_PRICING_ATTR:'||sqlerrm);
1909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1910:
1911: qp_bulk_loader_pub.write_log('Leaving Delete Pricing Attribute');

Line 1911: qp_bulk_loader_pub.write_log('Leaving Delete Pricing Attribute');

1907: qp_bulk_loader_pub.write_log(
1908: 'UNEXPECTED ERROR IN QP_BULK_UTIL.DELETE_PRICING_ATTR:'||sqlerrm);
1909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1910:
1911: qp_bulk_loader_pub.write_log('Leaving Delete Pricing Attribute');
1912:
1913: END DELETE_PRICING_ATTR;
1914:
1915: