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_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.8 2010/08/27 12:05:17 smbalara 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 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 723: l_msg_data := FND_MESSAGE.GET_STRING('QP','QP_BULK_VALUE_TO_ID_ERROR');

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
726:
727: l_counter := length(l_err.attribute_status)/3;

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

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(
779: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_HEADER_ERROR_MESSAGES:'||sqlerrm);

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

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;
783:

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

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
810:
811: IF l_err.attribute_status is not NULL then

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

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(
879: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_QUAL_ERROR_MESSAGES:'||sqlerrm);

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

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;
883:

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

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
924: IF l_err.attribute_status is NULL then
925: if l_err.pac is not NULL and l_err.pa is NULL then

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

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(
1049: 'UNEXCPECTED ERROR IN QP_BULK_VALUE_TO_ID.INSERT_LINE_ERROR_MESSAGES:'||sqlerrm);

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

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;
1053:

Line 1054: END QP_BULK_VALUE_TO_ID;

1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1051:
1052: END INSERT_LINE_ERROR_MESSAGE;
1053:
1054: END QP_BULK_VALUE_TO_ID;