DBA Data[Home] [Help]

APPS.QP_BULK_VALUE_TO_ID dependencies on QP_BULK_VALUE_TO_ID

Line 1: PACKAGE BODY QP_BULK_VALUE_TO_ID AS

1: PACKAGE BODY QP_BULK_VALUE_TO_ID AS
2: /* $Header: QPXBVIDB.pls 120.3.12010000.4 2008/09/02 06:55:56 jputta ship $ */
3:
4: PROCEDURE HEADER
5: (p_request_id IN NUMBER)

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 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 662: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.LINE:'||sqlerrm);

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

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

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

Line 692: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_BULK_VALUE_TO_ID_ERROR');

688: BEGIN
689:
690: qp_bulk_loader_pub.write_log( 'Entering Insert Header Error Messages');
691:
692: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_BULK_VALUE_TO_ID_ERROR');
693:
694: FOR l_err in c_error_records LOOP
695:
696: l_counter := length(l_err.attribute_status)/3;

Line 744: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_HEADER_ERROR_MESSAGES:'||sqlerrm);

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

Line 748: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_HEADER_ERROR_MESSAGES:'||sqlerrm);

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

Line 776: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_BULK_VALUE_TO_ID_ERROR');

772: BEGIN
773:
774: qp_bulk_loader_pub.write_log( 'Entering Insert Qualifier Error Messages');
775:
776: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_BULK_VALUE_TO_ID_ERROR');
777:
778: FOR l_err in c_error_records LOOP
779:
780: IF l_err.attribute_status is not NULL then

Line 844: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_QUAL_ERROR_MESSAGES:'||sqlerrm);

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

Line 848: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_QUAL_ERROR_MESSAGES:'||sqlerrm);

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

Line 890: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_BULK_VALUE_TO_ID_ERROR');

886:
887: BEGIN
888: qp_bulk_loader_pub.write_log( 'Entering Insert Line Error Messages');
889:
890: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_BULK_VALUE_TO_ID_ERROR');
891:
892: FOR l_err in c_error_records LOOP
893: IF l_err.attribute_status is NULL then
894: if l_err.pac is not NULL and l_err.pa is NULL then

Line 1014: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_LINE_ERROR_MESSAGES:'||sqlerrm);

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

Line 1018: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_LINE_ERROR_MESSAGES:'||sqlerrm);

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

Line 1023: END QP_BULK_VALUE_TO_ID;

1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020:
1021: END INSERT_LINE_ERROR_MESSAGE;
1022:
1023: END QP_BULK_VALUE_TO_ID;