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);
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);
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;
117:
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:
120: PROCEDURE QUALIFIER
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);
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);
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;
198:
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;
201:
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);
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);
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;
698: END LINE;
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:
701: PROCEDURE INSERT_HEADER_ERROR_MESSAGES
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(
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
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(
779: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_HEADER_ERROR_MESSAGES:'||sqlerrm);
780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;
783:
784: PROCEDURE INSERT_QUAL_ERROR_MESSAGE
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(
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
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(
879: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_QUAL_ERROR_MESSAGES:'||sqlerrm);
880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;
883:
884:
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(
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
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(
1049: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_LINE_ERROR_MESSAGES:'||sqlerrm);
1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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;
1053:
1054: END QP_BULK_VALUE_TO_ID;