APPS.DPP_CLAIMS_PVT dependencies on DPP_CUSTOMER_CLAIMS_ALL

Line 886: UPDATE DPP_CUSTOMER_CLAIMS_ALL

882: FOR i IN l_txn_line_tbl.FIRST..l_txn_line_tbl.LAST LOOP
883: --Insert into the output xml table to generate the error log
884: FOR get_claim_id_rec IN get_claim_id_csr (l_txn_line_tbl(i).transaction_line_id) LOOP
885: IF get_claim_id_rec.claim_id IS NOT NULL THEN
886: UPDATE DPP_CUSTOMER_CLAIMS_ALL
887: SET SUPP_CUST_CLAIM_ID = to_char(get_claim_id_rec.claim_id),
888: supplier_claim_created = 'Y',
889: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
890: last_updated_by = l_txn_hdr_rec.LAST_UPDATED_BY,

Line 896: DPP_UTILITY_PVT.debug_message('Unable to Update the column SUPP_CUST_CLAIM_ID in DPP_CUSTOMER_CLAIMS_ALL Table');

892: last_update_login = l_txn_hdr_rec.LAST_UPDATED_BY
893: WHERE CUSTOMER_INV_LINE_ID = l_txn_line_tbl(i).transaction_line_id;
894:
895: IF SQL%ROWCOUNT = 0 THEN
896: DPP_UTILITY_PVT.debug_message('Unable to Update the column SUPP_CUST_CLAIM_ID in DPP_CUSTOMER_CLAIMS_ALL Table');
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END IF;
899: ELSE
900: UPDATE DPP_CUSTOMER_CLAIMS_ALL

Line 900: UPDATE DPP_CUSTOMER_CLAIMS_ALL

896: DPP_UTILITY_PVT.debug_message('Unable to Update the column SUPP_CUST_CLAIM_ID in DPP_CUSTOMER_CLAIMS_ALL Table');
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END IF;
899: ELSE
900: UPDATE DPP_CUSTOMER_CLAIMS_ALL
901: SET supplier_claim_created = 'N',
902: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
903: last_updated_by = l_txn_hdr_rec.LAST_UPDATED_BY,
904: last_update_date = sysdate,

Line 909: DPP_UTILITY_PVT.debug_message('Unable to Update the column supplier_claim_created in DPP_CUSTOMER_CLAIMS_ALL Table');

905: last_update_login = l_txn_hdr_rec.LAST_UPDATED_BY
906: WHERE CUSTOMER_INV_LINE_ID = l_txn_line_tbl(i).transaction_line_id;
907:
908: IF SQL%ROWCOUNT = 0 THEN
909: DPP_UTILITY_PVT.debug_message('Unable to Update the column supplier_claim_created in DPP_CUSTOMER_CLAIMS_ALL Table');
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: END IF;
912: END IF;
913: END LOOP;

Line 1100: UPDATE DPP_CUSTOMER_CLAIMS_ALL

1096: --Assign the claim id to the corresponding lines
1097: FOR i IN l_txn_line_tbl.FIRST..l_txn_line_tbl.LAST LOOP
1098: FOR get_claim_id_rec IN get_claim_id_csr (l_txn_line_tbl(i).transaction_line_id) LOOP
1099: IF get_claim_id_rec.claim_id IS NOT NULL THEN
1100: UPDATE DPP_CUSTOMER_CLAIMS_ALL
1101: SET CUSTOMER_CLAIM_ID = to_char(get_claim_id_rec.claim_id),
1102: customer_claim_created = 'Y',
1103: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1104: last_updated_by = l_txn_hdr_rec.LAST_UPDATED_BY,

Line 1110: DPP_UTILITY_PVT.debug_message('Unable to Update the column CUSTOMER_CLAIM_ID in DPP_CUSTOMER_CLAIMS_ALL Table');

1106: last_update_login = l_txn_hdr_rec.LAST_UPDATED_BY
1107: WHERE CUSTOMER_INV_LINE_ID = l_txn_line_tbl(i).transaction_line_id;
1108:
1109: IF SQL%ROWCOUNT = 0 THEN
1110: DPP_UTILITY_PVT.debug_message('Unable to Update the column CUSTOMER_CLAIM_ID in DPP_CUSTOMER_CLAIMS_ALL Table');
1111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1112: END IF;
1113: ELSE
1114: UPDATE DPP_CUSTOMER_CLAIMS_ALL

Line 1114: UPDATE DPP_CUSTOMER_CLAIMS_ALL

1110: DPP_UTILITY_PVT.debug_message('Unable to Update the column CUSTOMER_CLAIM_ID in DPP_CUSTOMER_CLAIMS_ALL Table');
1111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1112: END IF;
1113: ELSE
1114: UPDATE DPP_CUSTOMER_CLAIMS_ALL
1115: SET customer_claim_created = 'N',
1116: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
1117: last_updated_by = l_txn_hdr_rec.LAST_UPDATED_BY,
1118: last_update_date = sysdate,

Line 1123: DPP_UTILITY_PVT.debug_message('Unable to Update the column customer_claim_created in DPP_CUSTOMER_CLAIMS_ALL Table');

1119: last_update_login = l_txn_hdr_rec.LAST_UPDATED_BY
1120: WHERE CUSTOMER_INV_LINE_ID = l_txn_line_tbl(i).transaction_line_id;
1121:
1122: IF SQL%ROWCOUNT = 0 THEN
1123: DPP_UTILITY_PVT.debug_message('Unable to Update the column customer_claim_created in DPP_CUSTOMER_CLAIMS_ALL Table');
1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1125: END IF;
1126: END IF;
1127: END LOOP;