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.DPP_CLAIMS_PVT dependencies on DPP_CUSTOMER_CLAIMS_GT

Line 130: FROM DPP_CUSTOMER_CLAIMS_GT

126: j NUMBER;
127:
128: CURSOR get_claim_hdr_amt_pd_csr IS
129: SELECT SUM(claim_line_amount) amount
130: FROM DPP_CUSTOMER_CLAIMS_GT
131: where claim_line_amount > 0;
132:
133: CURSOR get_claim_hdr_amt_pi_csr IS
134: SELECT SUM(ABS(claim_line_amount)) amount

Line 135: FROM DPP_CUSTOMER_CLAIMS_GT

131: where claim_line_amount > 0;
132:
133: CURSOR get_claim_hdr_amt_pi_csr IS
134: SELECT SUM(ABS(claim_line_amount)) amount
135: FROM DPP_CUSTOMER_CLAIMS_GT
136: where claim_line_amount < 0;
137:
138: CURSOR get_claim_id_csr (p_line_id IN NUMBER) IS
139: SELECT claim_id

Line 140: FROM DPP_CUSTOMER_CLAIMS_GT

136: where claim_line_amount < 0;
137:
138: CURSOR get_claim_id_csr (p_line_id IN NUMBER) IS
139: SELECT claim_id
140: FROM DPP_CUSTOMER_CLAIMS_GT
141: WHERE Transaction_Line_ID = p_line_id;
142:
143: CURSOR grpby_currency_csr IS
144: SELECT SUM(Claim_Line_Amount) amount,

Line 146: FROM DPP_CUSTOMER_CLAIMS_GT

142:
143: CURSOR grpby_currency_csr IS
144: SELECT SUM(Claim_Line_Amount) amount,
145: Currency
146: FROM DPP_CUSTOMER_CLAIMS_GT
147: GROUP BY Currency;
148:
149: CURSOR get_claim_lines_csr (p_currency IN VARCHAR2) IS
150: SELECT transaction_line_id,

Line 157: FROM DPP_CUSTOMER_CLAIMS_GT

153: inventory_item_id,
154: claim_quantity,
155: item_description,
156: uom
157: FROM DPP_CUSTOMER_CLAIMS_GT
158: WHERE currency = p_currency;
159:
160: CURSOR grpby_cur_cust_csr IS
161: SELECT SUM(Claim_Line_Amount) amount,

Line 165: FROM DPP_CUSTOMER_CLAIMS_GT

161: SELECT SUM(Claim_Line_Amount) amount,
162: Currency,
163: customer_id,
164: cust_account_id
165: FROM DPP_CUSTOMER_CLAIMS_GT
166: GROUP BY Currency,
167: customer_id,
168: cust_account_id;
169:

Line 180: FROM DPP_CUSTOMER_CLAIMS_GT

176: inventory_item_id,
177: claim_quantity,
178: item_description,
179: uom
180: FROM DPP_CUSTOMER_CLAIMS_GT
181: WHERE currency = p_currency
182: AND customer_id = p_customer_id
183: AND cust_account_id = p_cust_account_id;
184:

Line 298: -- Delete the existing lines if any from the DPP_CUSTOMER_CLAIMS_GT temporary table

294: ELSE
295: j := 1;
296: END IF;
297:
298: -- Delete the existing lines if any from the DPP_CUSTOMER_CLAIMS_GT temporary table
299: DELETE FROM DPP_CUSTOMER_CLAIMS_GT;
300:
301: l_price_increase_flag := NULL;
302: FOR k in 1..j LOOP

Line 299: DELETE FROM DPP_CUSTOMER_CLAIMS_GT;

295: j := 1;
296: END IF;
297:
298: -- Delete the existing lines if any from the DPP_CUSTOMER_CLAIMS_GT temporary table
299: DELETE FROM DPP_CUSTOMER_CLAIMS_GT;
300:
301: l_price_increase_flag := NULL;
302: FOR k in 1..j LOOP
303: IF j = 2 THEN --When transaction has both price increase and price decrease lines

Line 321: -- Delete the existing lines if any from the DPP_CUSTOMER_CLAIMS_GT temporary table

317: l_price_increase_flag := 'N';
318: END IF;
319: END IF;
320:
321: -- Delete the existing lines if any from the DPP_CUSTOMER_CLAIMS_GT temporary table
322: --DELETE FROM DPP_CUSTOMER_CLAIMS_GT;
323:
324: --Insert the lines into the global temp table
325: FOR i in l_txn_line_tbl.FIRST..l_txn_line_tbl.LAST LOOP

Line 322: --DELETE FROM DPP_CUSTOMER_CLAIMS_GT;

318: END IF;
319: END IF;
320:
321: -- Delete the existing lines if any from the DPP_CUSTOMER_CLAIMS_GT temporary table
322: --DELETE FROM DPP_CUSTOMER_CLAIMS_GT;
323:
324: --Insert the lines into the global temp table
325: FOR i in l_txn_line_tbl.FIRST..l_txn_line_tbl.LAST LOOP
326: BEGIN

Line 327: Insert into DPP_CUSTOMER_CLAIMS_GT(Transaction_Line_ID,

323:
324: --Insert the lines into the global temp table
325: FOR i in l_txn_line_tbl.FIRST..l_txn_line_tbl.LAST LOOP
326: BEGIN
327: Insert into DPP_CUSTOMER_CLAIMS_GT(Transaction_Line_ID,
328: Inventory_Item_Id,
329: cust_account_id,
330: Claim_Line_Amount,
331: Currency,

Line 359: UPDATE DPP_CUSTOMER_CLAIMS_GT

355: END;
356: --Get the item number
357: IF l_txn_line_tbl(i).inventory_item_id IS NOT NULL THEN
358: FOR get_item_number_rec IN get_item_number_csr(l_txn_line_tbl(i).inventory_item_id) LOOP
359: UPDATE DPP_CUSTOMER_CLAIMS_GT
360: SET item_number = get_item_number_rec.item_number,
361: item_description = get_item_number_rec.description
362: WHERE transaction_line_id = l_txn_line_tbl(i).transaction_line_id;
363: IF SQL%ROWCOUNT = 0 THEN

Line 364: DPP_UTILITY_PVT.debug_message('Unable to Update the column item_number in DPP_CUSTOMER_CLAIMS_GT Table');

360: SET item_number = get_item_number_rec.item_number,
361: item_description = get_item_number_rec.description
362: WHERE transaction_line_id = l_txn_line_tbl(i).transaction_line_id;
363: IF SQL%ROWCOUNT = 0 THEN
364: DPP_UTILITY_PVT.debug_message('Unable to Update the column item_number in DPP_CUSTOMER_CLAIMS_GT Table');
365: END IF;
366: END LOOP;
367: ELSE
368: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 377: UPDATE DPP_CUSTOMER_CLAIMS_GT

373: --Get the customer name
374: IF l_txn_hdr_rec.claim_type_flag = 'CUST_CL' THEN
375: IF l_txn_line_tbl(i).cust_account_id IS NOT NULL THEN
376: FOR get_customer_dtl_rec IN get_customer_dtl_csr(l_txn_line_tbl(i).cust_account_id) LOOP
377: UPDATE DPP_CUSTOMER_CLAIMS_GT
378: SET customer_name = get_customer_dtl_rec.account_name,
379: customer_id = get_customer_dtl_rec.party_id
380: WHERE cust_account_id = l_txn_line_tbl(i).cust_account_id;
381: IF SQL%ROWCOUNT = 0 THEN

Line 382: DPP_UTILITY_PVT.debug_message('Unable to Update the column customer_name in DPP_CUSTOMER_CLAIMS_GT Table');

378: SET customer_name = get_customer_dtl_rec.account_name,
379: customer_id = get_customer_dtl_rec.party_id
380: WHERE cust_account_id = l_txn_line_tbl(i).cust_account_id;
381: IF SQL%ROWCOUNT = 0 THEN
382: DPP_UTILITY_PVT.debug_message('Unable to Update the column customer_name in DPP_CUSTOMER_CLAIMS_GT Table');
383: END IF;
384: END LOOP;
385: ELSE
386: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 524: UPDATE DPP_CUSTOMER_CLAIMS_GT

520: fnd_message.set_token('ERRNO', sqlcode);
521: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
522: FND_MSG_PUB.add;
523: --Update the GT table with the reason for failure
524: UPDATE DPP_CUSTOMER_CLAIMS_GT
525: SET reason_for_failure = nvl(substr(l_msg_data,1,4000),'Error while Creating Claim in Trade Management');
526: IF SQL%ROWCOUNT = 0 THEN
527: DPP_UTILITY_PVT.debug_message('Unable to Update DPP_CUSTOMER_CLAIMS_GT Table');
528: END IF;

Line 527: DPP_UTILITY_PVT.debug_message('Unable to Update DPP_CUSTOMER_CLAIMS_GT Table');

523: --Update the GT table with the reason for failure
524: UPDATE DPP_CUSTOMER_CLAIMS_GT
525: SET reason_for_failure = nvl(substr(l_msg_data,1,4000),'Error while Creating Claim in Trade Management');
526: IF SQL%ROWCOUNT = 0 THEN
527: DPP_UTILITY_PVT.debug_message('Unable to Update DPP_CUSTOMER_CLAIMS_GT Table');
528: END IF;
529: ELSE
530: --Assign the claim id to the header record to call the update claim api
531: l_txn_hdr_rec.claim_id := l_x_claim_id ;

Line 580: UPDATE DPP_CUSTOMER_CLAIMS_GT

576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: END;
578: --Insert the claim id into the global temp table..
579: IF l_price_increase_flag = 'Y' THEN
580: UPDATE DPP_CUSTOMER_CLAIMS_GT
581: SET claim_id = l_x_claim_id,
582: claim_number = l_claim_number
583: where claim_line_amount < 0;
584: ELSIF l_price_increase_flag = 'N' THEN

Line 585: UPDATE DPP_CUSTOMER_CLAIMS_GT

581: SET claim_id = l_x_claim_id,
582: claim_number = l_claim_number
583: where claim_line_amount < 0;
584: ELSIF l_price_increase_flag = 'N' THEN
585: UPDATE DPP_CUSTOMER_CLAIMS_GT
586: SET claim_id = l_x_claim_id,
587: claim_number = l_claim_number
588: where claim_line_amount > 0;
589: END IF;

Line 591: -- UPDATE DPP_CUSTOMER_CLAIMS_GT

587: claim_number = l_claim_number
588: where claim_line_amount > 0;
589: END IF;
590:
591: -- UPDATE DPP_CUSTOMER_CLAIMS_GT
592: -- SET claim_id = l_x_claim_id,
593: -- claim_number = l_claim_number;
594: IF SQL%ROWCOUNT = 0 THEN
595: DPP_UTILITY_PVT.debug_message('Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');

Line 595: DPP_UTILITY_PVT.debug_message('Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');

591: -- UPDATE DPP_CUSTOMER_CLAIMS_GT
592: -- SET claim_id = l_x_claim_id,
593: -- claim_number = l_claim_number;
594: IF SQL%ROWCOUNT = 0 THEN
595: DPP_UTILITY_PVT.debug_message('Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');
596: END IF;
597: --Assign the claim id to the corresponding lines
598: FOR i IN l_txn_line_tbl.FIRST..l_txn_line_tbl.LAST LOOP
599: --Insert into the output xml table to generate the error log

Line 692: UPDATE DPP_CUSTOMER_CLAIMS_GT

688: fnd_message.set_token('ERRNO', sqlcode);
689: fnd_message.set_token('REASON', 'Error while Updating Claim in Trade Management');
690: FND_MSG_PUB.add;
691: --Delete the claim numbers from the GT table
692: UPDATE DPP_CUSTOMER_CLAIMS_GT
693: SET claim_id = null,
694: claim_number = null;
695: IF SQL%ROWCOUNT = 0 THEN
696: DPP_UTILITY_PVT.debug_message('Unable to Update DPP_CUSTOMER_CLAIMS_GT Table');

Line 696: DPP_UTILITY_PVT.debug_message('Unable to Update DPP_CUSTOMER_CLAIMS_GT Table');

692: UPDATE DPP_CUSTOMER_CLAIMS_GT
693: SET claim_id = null,
694: claim_number = null;
695: IF SQL%ROWCOUNT = 0 THEN
696: DPP_UTILITY_PVT.debug_message('Unable to Update DPP_CUSTOMER_CLAIMS_GT Table');
697: END IF;
698: END IF;
699: END IF; --Pre approval is not required
700: END IF;

Line 759: UPDATE DPP_CUSTOMER_CLAIMS_GT

755: fnd_message.set_token('ERRNO', sqlcode);
756: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
757: FND_MSG_PUB.add;
758: --Update the claim id into the global temp table..
759: UPDATE DPP_CUSTOMER_CLAIMS_GT
760: SET reason_for_failure = nvl(substr(l_msg_data,1,4000),'Error while Creating Claim in Trade Management')
761: WHERE currency = grpby_currency_rec.Currency;
762:
763: IF SQL%ROWCOUNT = 0 THEN

Line 764: DPP_UTILITY_PVT.debug_message('Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');

760: SET reason_for_failure = nvl(substr(l_msg_data,1,4000),'Error while Creating Claim in Trade Management')
761: WHERE currency = grpby_currency_rec.Currency;
762:
763: IF SQL%ROWCOUNT = 0 THEN
764: DPP_UTILITY_PVT.debug_message('Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');
765: END IF;
766: ELSE
767: --Update the claim to pending close status
768: --Call the update_claims procedure to update the claim status to open

Line 870: UPDATE DPP_CUSTOMER_CLAIMS_GT

866: END IF;
867: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
868: END;
869: --Update the claim id into the global temp table..
870: UPDATE DPP_CUSTOMER_CLAIMS_GT
871: SET claim_id = l_x_claim_id,
872: claim_number = l_claim_number
873: WHERE currency = grpby_currency_rec.Currency;
874:

Line 876: DPP_UTILITY_PVT.debug_message('Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');

872: claim_number = l_claim_number
873: WHERE currency = grpby_currency_rec.Currency;
874:
875: IF SQL%ROWCOUNT = 0 THEN
876: DPP_UTILITY_PVT.debug_message('Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');
877: END IF;
878: END IF; --Update claim call success
879: END IF; --Create claim success
880: END LOOP;

Line 970: UPDATE DPP_CUSTOMER_CLAIMS_GT

966: fnd_message.set_token('ERRNO', sqlcode);
967: fnd_message.set_token('REASON', 'Error while Creating Claim in Trade Management');
968: FND_MSG_PUB.add;
969: --Insert the claim id into the global temp table..
970: UPDATE DPP_CUSTOMER_CLAIMS_GT
971: SET reason_for_failure = nvl(substr(l_msg_data,1,4000),'Error while Creating Claim in Trade Management')
972: WHERE currency = grpby_cur_cust_rec.Currency
973: AND customer_id = grpby_cur_cust_rec.customer_id
974: AND cust_account_id = grpby_cur_cust_rec.cust_account_id;

Line 977: DPP_UTILITY_PVT.debug_message('Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');

973: AND customer_id = grpby_cur_cust_rec.customer_id
974: AND cust_account_id = grpby_cur_cust_rec.cust_account_id;
975:
976: IF SQL%ROWCOUNT = 0 THEN
977: DPP_UTILITY_PVT.debug_message('Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');
978: END IF;
979: ELSE
980: --Update the claim to Pending Close status
981: l_claim_pub_rec.claim_id := l_x_claim_id;

Line 1082: UPDATE DPP_CUSTOMER_CLAIMS_GT

1078: END IF;
1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1080: END;
1081: --Insert the claim id into the global temp table..
1082: UPDATE DPP_CUSTOMER_CLAIMS_GT
1083: SET claim_id = l_x_claim_id,
1084: claim_number = l_claim_number,
1085: reason_for_failure = nvl(substr(l_msg_data,1,4000),'Error while Updating Claim in Trade Management')
1086: WHERE currency = grpby_cur_cust_rec.Currency

Line 1090: DPP_UTILITY_PVT.debug_message('Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');

1086: WHERE currency = grpby_cur_cust_rec.Currency
1087: AND customer_id = grpby_cur_cust_rec.customer_id
1088: AND cust_account_id = grpby_cur_cust_rec.cust_account_id;
1089: IF SQL%ROWCOUNT = 0 THEN
1090: DPP_UTILITY_PVT.debug_message('Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');
1091: END IF;
1092: END IF;
1093: END IF;
1094: END LOOP;

Line 1145: FROM DPP_CUSTOMER_CLAIMS_GT) TRANSACTION

1141: l_status := 'SUCCESS';
1142: --Output XML Generation Code.
1143: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_transaction_number||'Txnnumber,
1144: CURSOR (SELECT DISTINCT claim_number claimnumber
1145: FROM DPP_CUSTOMER_CLAIMS_GT) TRANSACTION
1146: FROM dual');
1147: ELSE
1148: l_status := 'WARNING';
1149: --Output XML Generation Code.

Line 1156: FROM DPP_CUSTOMER_CLAIMS_GT) transaction FROM dual');

1152: customer_name customername,
1153: currency,
1154: item_number itemnumber ,
1155: reason_for_failure reason
1156: FROM DPP_CUSTOMER_CLAIMS_GT) transaction FROM dual');
1157: END IF;
1158: dbms_xmlquery.setRowTag(l_queryCtx
1159: ,'ROOT'
1160: );