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.2 2008/10/16 06:48:24 rbadadar 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 261: qp_bulk_loader_pub.write_log('Entering Loading Udt Header');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 889: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE_TO_OLD');

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

Line 892: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE_TO_OLD');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1155: qp_bulk_loader_pub.write_log(

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

Line 1159: qp_bulk_loader_pub.write_log(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1387: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE');

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

Line 1390: qp_bulk_loader_pub.write_log( 'UNEXPECTED ERROR IN QP_BULK_UTIL.UPDATE_LINE');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1546: qp_bulk_loader_pub.write_log(

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

Line 1550: qp_bulk_loader_pub.write_log(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1902: qp_bulk_loader_pub.write_log(

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

Line 1906: qp_bulk_loader_pub.write_log(

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

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

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