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 FND_LOG

Line 226: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Public API: ' || l_api_name || 'start');

222: THEN
223: FND_MSG_PUB.initialize;
224: END IF;
225: -- Debug Message
226: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Public API: ' || l_api_name || 'start');
227:
228: -- Initialize API return status to success
229: x_return_status := FND_API.G_RET_STS_SUCCESS;
230:

Line 231: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Transaction Number: ' || l_txn_hdr_rec.Transaction_number);

227:
228: -- Initialize API return status to success
229: x_return_status := FND_API.G_RET_STS_SUCCESS;
230:
231: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Transaction Number: ' || l_txn_hdr_rec.Transaction_number);
232: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Claim Type Flag: ' || l_txn_hdr_rec.claim_type_flag);
233:
234: l_transaction_number := ''''||l_txn_hdr_rec.Transaction_number||'''';
235:

Line 232: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Claim Type Flag: ' || l_txn_hdr_rec.claim_type_flag);

228: -- Initialize API return status to success
229: x_return_status := FND_API.G_RET_STS_SUCCESS;
230:
231: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Transaction Number: ' || l_txn_hdr_rec.Transaction_number);
232: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Claim Type Flag: ' || l_txn_hdr_rec.claim_type_flag);
233:
234: l_transaction_number := ''''||l_txn_hdr_rec.Transaction_number||'''';
235:
236: MO_GLOBAL.set_policy_context('S',l_txn_hdr_rec.org_id);

Line 281: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Pre Approval Required : ' || l_approval_flag);

277: END IF;
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: END;
280:
281: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Pre Approval Required : ' || l_approval_flag);
282: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Customer Account ID : ' || l_cust_account_id);
283:
284: --Added code for DPP Price Increase Enhancement
285: --Segregate the lines according to the claim_amount

Line 282: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Customer Account ID : ' || l_cust_account_id);

278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: END;
280:
281: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Pre Approval Required : ' || l_approval_flag);
282: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Customer Account ID : ' || l_cust_account_id);
283:
284: --Added code for DPP Price Increase Enhancement
285: --Segregate the lines according to the claim_amount
286: l_pi_count := 0;

Line 374: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, 'Unable to Update the column item_number in DPP_CUSTOMER_CLAIMS_GT Table');

370: SET item_number = get_item_number_rec.item_number,
371: item_description = get_item_number_rec.description
372: WHERE transaction_line_id = l_txn_line_tbl(i).transaction_line_id;
373: IF SQL%ROWCOUNT = 0 THEN
374: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, 'Unable to Update the column item_number in DPP_CUSTOMER_CLAIMS_GT Table');
375: END IF;
376: END LOOP;
377: ELSE
378: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 392: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, 'Unable to Update the column customer_name in DPP_CUSTOMER_CLAIMS_GT Table');

388: SET customer_name = get_customer_dtl_rec.account_name,
389: customer_id = get_customer_dtl_rec.party_id
390: WHERE cust_account_id = l_txn_line_tbl(i).cust_account_id;
391: IF SQL%ROWCOUNT = 0 THEN
392: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module, 'Unable to Update the column customer_name in DPP_CUSTOMER_CLAIMS_GT Table');
393: END IF;
394: END LOOP;
395: ELSE
396: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');

Line 435: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_txn_hdr_rec.claim_amount : ' || l_txn_hdr_rec.claim_amount);

431: -- END LOOP;
432: l_claim_pub_rec.cust_account_id := l_cust_account_id;
433: l_claim_pub_rec.claim_class := 'CLAIM';
434:
435: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_txn_hdr_rec.claim_amount : ' || l_txn_hdr_rec.claim_amount);
436:
437: l_claim_pub_rec.currency_code := l_txn_hdr_rec.currency_code;
438: l_claim_pub_rec.vendor_id := l_txn_hdr_rec.Vendor_ID;
439: l_claim_pub_rec.vendor_site_id := l_txn_hdr_rec.Vendor_site_ID;

Line 499: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_claim_line_pub_tbl(i).claim_currency_amount: ' || l_claim_line_pub_tbl(i).claim_currency_amount);

495: l_claim_line_pub_tbl(i).source_object_class := 'PPVENDOR';
496: l_claim_line_pub_tbl(i).claim_currency_amount := l_txn_line_tbl(i).Claim_Line_Amount;
497: END IF;
498:
499: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_claim_line_pub_tbl(i).claim_currency_amount: ' || l_claim_line_pub_tbl(i).claim_currency_amount);
500:
501: l_claim_line_pub_tbl(i).item_description := l_item_description;
502: l_claim_line_pub_tbl(i).item_type := l_item_type;
503: l_claim_line_pub_tbl(i).item_id := l_txn_line_tbl(i).Inventory_Item_Id;

Line 522: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Create_Claim =>'||l_return_status);

518: p_claim_line_tbl => l_claim_line_pub_tbl,
519: x_claim_id => l_x_claim_id
520: );
521:
522: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Create_Claim =>'||l_return_status);
523: dpp_utility_pvt.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message data from OZF Create Claim =>'||l_msg_data),1,4000));
524:
525: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
526: x_return_status := l_return_status;

Line 523: dpp_utility_pvt.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message data from OZF Create Claim =>'||l_msg_data),1,4000));

519: x_claim_id => l_x_claim_id
520: );
521:
522: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Create_Claim =>'||l_return_status);
523: dpp_utility_pvt.debug_message (FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message data from OZF Create Claim =>'||l_msg_data),1,4000));
524:
525: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
526: x_return_status := l_return_status;
527: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 536: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update DPP_CUSTOMER_CLAIMS_GT Table');

532: --Update the GT table with the reason for failure
533: UPDATE DPP_CUSTOMER_CLAIMS_GT
534: SET reason_for_failure = nvl(substr(l_msg_data,1,4000),'Error while Creating Claim in Trade Management');
535: IF SQL%ROWCOUNT = 0 THEN
536: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update DPP_CUSTOMER_CLAIMS_GT Table');
537: END IF;
538: ELSE
539: --Assign the claim id to the header record to call the update claim api
540: l_txn_hdr_rec.claim_id := l_x_claim_id ;

Line 604: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');

600: -- UPDATE DPP_CUSTOMER_CLAIMS_GT
601: -- SET claim_id = l_x_claim_id,
602: -- claim_number = l_claim_number;
603: IF SQL%ROWCOUNT = 0 THEN
604: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');
605: END IF;
606: --Assign the claim id to the corresponding lines
607: FOR i IN l_txn_line_tbl.FIRST..l_txn_line_tbl.LAST LOOP
608: --Insert into the output xml table to generate the error log

Line 620: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column supp_dist_claim_id in DPP_TRANSACTION_LINES_ALL Table');

616: last_update_login = l_txn_hdr_rec.LAST_UPDATED_BY
617: WHERE transaction_line_id = l_txn_line_tbl(i).transaction_line_id;
618:
619: IF SQL%ROWCOUNT = 0 THEN
620: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column supp_dist_claim_id in DPP_TRANSACTION_LINES_ALL Table');
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: END IF;
623: END LOOP; --getting the claim id loop
624: END LOOP; --lines table loop

Line 693: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for OZF Update_Claims =>'||l_return_status);

689: ,p_claim_line_tbl => l_claim_line_pub_tbl
690: ,x_object_version_number => l_object_version_number
691: );
692:
693: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for OZF Update_Claims =>'||l_return_status);
694: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message data for OZF Update_Claims =>'||l_msg_data),1,4000));
695:
696: --If the claim updation process failed
697: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 694: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message data for OZF Update_Claims =>'||l_msg_data),1,4000));

690: ,x_object_version_number => l_object_version_number
691: );
692:
693: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for OZF Update_Claims =>'||l_return_status);
694: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message data for OZF Update_Claims =>'||l_msg_data),1,4000));
695:
696: --If the claim updation process failed
697: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
698: x_return_status := l_return_status;

Line 709: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update DPP_CUSTOMER_CLAIMS_GT Table');

705: UPDATE DPP_CUSTOMER_CLAIMS_GT
706: SET claim_id = null,
707: claim_number = null;
708: IF SQL%ROWCOUNT = 0 THEN
709: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update DPP_CUSTOMER_CLAIMS_GT Table');
710: END IF;
711: END IF;
712: END IF; --Pre approval is not required
713: END IF;

Line 760: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Create_Claim =>'||l_return_status);

756: p_claim_line_tbl => l_claim_line_pub_tbl,
757: x_claim_id => l_x_claim_id
758: );
759:
760: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Create_Claim =>'||l_return_status);
761: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message Data for OZF Create_Claim =>'||l_msg_data),1,4000));
762:
763: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
764: x_return_status := l_return_status;

Line 761: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message Data for OZF Create_Claim =>'||l_msg_data),1,4000));

757: x_claim_id => l_x_claim_id
758: );
759:
760: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Create_Claim =>'||l_return_status);
761: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message Data for OZF Create_Claim =>'||l_msg_data),1,4000));
762:
763: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
764: x_return_status := l_return_status;
765: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 776: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');

772: SET reason_for_failure = nvl(substr(l_msg_data,1,4000),'Error while Creating Claim in Trade Management')
773: WHERE currency = grpby_currency_rec.Currency;
774:
775: IF SQL%ROWCOUNT = 0 THEN
776: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');
777: END IF;
778: ELSE
779: --Update the claim to pending close status
780: --Call the update_claims procedure to update the claim status to open

Line 832: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Update_Claims =>'||l_return_status);

828: ,p_claim_line_tbl => l_claim_line_pub_tbl_updt
829: ,x_object_version_number => l_object_version_number
830: );
831:
832: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Update_Claims =>'||l_return_status);
833: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message data for OZF Update_Claims =>'||l_msg_data),1,4000));
834:
835: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
836: x_return_status := l_return_status;

Line 833: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message data for OZF Update_Claims =>'||l_msg_data),1,4000));

829: ,x_object_version_number => l_object_version_number
830: );
831:
832: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Update_Claims =>'||l_return_status);
833: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message data for OZF Update_Claims =>'||l_msg_data),1,4000));
834:
835: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
836: x_return_status := l_return_status;
837: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 890: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');

886: claim_number = l_claim_number
887: WHERE currency = grpby_currency_rec.Currency;
888:
889: IF SQL%ROWCOUNT = 0 THEN
890: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');
891: END IF;
892: END IF; --Update claim call success
893: END IF; --Create claim success
894: END LOOP;

Line 910: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column SUPP_CUST_CLAIM_ID in DPP_CUSTOMER_CLAIMS_ALL Table');

906: last_update_login = l_txn_hdr_rec.LAST_UPDATED_BY
907: WHERE CUSTOMER_INV_LINE_ID = l_txn_line_tbl(i).transaction_line_id;
908:
909: IF SQL%ROWCOUNT = 0 THEN
910: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column SUPP_CUST_CLAIM_ID in DPP_CUSTOMER_CLAIMS_ALL Table');
911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
912: END IF;
913: ELSE
914: UPDATE DPP_CUSTOMER_CLAIMS_ALL

Line 923: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column supplier_claim_created in DPP_CUSTOMER_CLAIMS_ALL Table');

919: last_update_login = l_txn_hdr_rec.LAST_UPDATED_BY
920: WHERE CUSTOMER_INV_LINE_ID = l_txn_line_tbl(i).transaction_line_id;
921:
922: IF SQL%ROWCOUNT = 0 THEN
923: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column supplier_claim_created in DPP_CUSTOMER_CLAIMS_ALL Table');
924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
925: END IF;
926: END IF;
927: END LOOP;

Line 973: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Create_Claim =>'||l_return_status);

969: p_claim_line_tbl => l_claim_line_pub_tbl,
970: x_claim_id => l_x_claim_id
971: );
972:
973: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Create_Claim =>'||l_return_status);
974: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message data for OZF Create_Claim =>'||l_msg_data),1,4000));
975:
976: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
977: x_return_status := l_return_status;

Line 974: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message data for OZF Create_Claim =>'||l_msg_data),1,4000));

970: x_claim_id => l_x_claim_id
971: );
972:
973: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Create_Claim =>'||l_return_status);
974: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message data for OZF Create_Claim =>'||l_msg_data),1,4000));
975:
976: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
977: x_return_status := l_return_status;
978: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 991: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');

987: AND customer_id = grpby_cur_cust_rec.customer_id
988: AND cust_account_id = grpby_cur_cust_rec.cust_account_id;
989:
990: IF SQL%ROWCOUNT = 0 THEN
991: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');
992: END IF;
993: ELSE
994: --Update the claim to Pending Close status
995: l_claim_pub_rec.claim_id := l_x_claim_id;

Line 1046: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Update_Claims =>'||l_return_status);

1042: ,p_claim_line_tbl => l_claim_line_pub_tbl_updt
1043: ,x_object_version_number => l_object_version_number
1044: );
1045:
1046: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Update_Claims =>'||l_return_status);
1047: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message Data for OZF Update_Claims =>'||l_msg_data),1,4000));
1048:
1049: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1050: x_return_status := l_return_status;

Line 1047: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message Data for OZF Update_Claims =>'||l_msg_data),1,4000));

1043: ,x_object_version_number => l_object_version_number
1044: );
1045:
1046: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Update_Claims =>'||l_return_status);
1047: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message Data for OZF Update_Claims =>'||l_msg_data),1,4000));
1048:
1049: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1050: x_return_status := l_return_status;
1051: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 1106: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');

1102: WHERE currency = grpby_cur_cust_rec.Currency
1103: AND customer_id = grpby_cur_cust_rec.customer_id
1104: AND cust_account_id = grpby_cur_cust_rec.cust_account_id;
1105: IF SQL%ROWCOUNT = 0 THEN
1106: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column claim_id in DPP_CUSTOMER_CLAIMS_GT Table');
1107: END IF;
1108: END IF;
1109: END IF;
1110: END LOOP;

Line 1126: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column CUSTOMER_CLAIM_ID in DPP_CUSTOMER_CLAIMS_ALL Table');

1122: last_update_login = l_txn_hdr_rec.LAST_UPDATED_BY
1123: WHERE CUSTOMER_INV_LINE_ID = l_txn_line_tbl(i).transaction_line_id;
1124:
1125: IF SQL%ROWCOUNT = 0 THEN
1126: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column CUSTOMER_CLAIM_ID in DPP_CUSTOMER_CLAIMS_ALL Table');
1127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1128: END IF;
1129: ELSE
1130: UPDATE DPP_CUSTOMER_CLAIMS_ALL

Line 1139: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column customer_claim_created in DPP_CUSTOMER_CLAIMS_ALL Table');

1135: last_update_login = l_txn_hdr_rec.LAST_UPDATED_BY
1136: WHERE CUSTOMER_INV_LINE_ID = l_txn_line_tbl(i).transaction_line_id;
1137:
1138: IF SQL%ROWCOUNT = 0 THEN
1139: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the column customer_claim_created in DPP_CUSTOMER_CLAIMS_ALL Table');
1140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1141: END IF;
1142: END IF;
1143: END LOOP;

Line 1204: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update DPP_EXECUTION_DETAILS Table');

1200: WHERE EXECUTION_DETAIL_ID = l_txn_hdr_rec.Execution_Detail_ID
1201: AND transaction_header_id = l_txn_hdr_rec.Transaction_Header_ID;
1202:
1203: IF SQL%ROWCOUNT = 0 THEN
1204: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update DPP_EXECUTION_DETAILS Table');
1205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1206: END IF;
1207: */
1208:

Line 1211: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Public API: ' || l_api_name || 'end');

1207: */
1208:
1209:
1210: -- Debug Message
1211: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Public API: ' || l_api_name || 'end');
1212:
1213: -- Standard check for p_commit
1214: IF FND_API.to_Boolean( p_commit )
1215: THEN

Line 1365: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Public API: ' || l_api_name || 'start');

1361: FND_MSG_PUB.initialize;
1362: END IF;
1363:
1364: -- Debug Message
1365: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Public API: ' || l_api_name || 'start');
1366:
1367: -- Initialize API return status to sucess
1368: l_return_status := FND_API.G_RET_STS_SUCCESS;
1369:

Line 1388: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Transaction Number: ' || l_txn_hdr_rec.Transaction_number);

1384: RAISE FND_API.G_EXC_ERROR;
1385: ELSE
1386: l_transaction_number := ''''||l_txn_hdr_rec.Transaction_number||'''';
1387:
1388: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Transaction Number: ' || l_txn_hdr_rec.Transaction_number);
1389: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Claim Id to be updated : ' || l_txn_hdr_rec.claim_id);
1390:
1391: END IF;
1392: --

Line 1389: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Claim Id to be updated : ' || l_txn_hdr_rec.claim_id);

1385: ELSE
1386: l_transaction_number := ''''||l_txn_hdr_rec.Transaction_number||'''';
1387:
1388: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Transaction Number: ' || l_txn_hdr_rec.Transaction_number);
1389: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Claim Id to be updated : ' || l_txn_hdr_rec.claim_id);
1390:
1391: END IF;
1392: --
1393: -- API body

Line 1528: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Update_Claims =>'||l_return_status);

1524: ,p_claim_line_tbl => l_claim_line_pub_tbl
1525: ,x_object_version_number => l_object_version_number
1526: );
1527:
1528: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Update_Claims =>'||l_return_status);
1529: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message Data for OZF Update_Claims =>'||l_msg_data),1,4000));
1530:
1531: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1532: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Update_Claims =>'||l_return_status);

Line 1529: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message Data for OZF Update_Claims =>'||l_msg_data),1,4000));

1525: ,x_object_version_number => l_object_version_number
1526: );
1527:
1528: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Update_Claims =>'||l_return_status);
1529: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message Data for OZF Update_Claims =>'||l_msg_data),1,4000));
1530:
1531: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1532: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Update_Claims =>'||l_return_status);
1533: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the claim to OPEN status');

Line 1532: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Update_Claims =>'||l_return_status);

1528: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Update_Claims =>'||l_return_status);
1529: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message Data for OZF Update_Claims =>'||l_msg_data),1,4000));
1530:
1531: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1532: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Update_Claims =>'||l_return_status);
1533: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the claim to OPEN status');
1534: ELSE
1535: --Bug#6928445
1536: IF l_txn_hdr_rec.claim_amount <> 0 THEN --ANBBALAS: For Price Increase enhancement

Line 1533: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the claim to OPEN status');

1529: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message Data for OZF Update_Claims =>'||l_msg_data),1,4000));
1530:
1531: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1532: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Update_Claims =>'||l_return_status);
1533: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Unable to Update the claim to OPEN status');
1534: ELSE
1535: --Bug#6928445
1536: IF l_txn_hdr_rec.claim_amount <> 0 THEN --ANBBALAS: For Price Increase enhancement
1537: --Update the Claim to PENDING CLOSE status

Line 1591: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Update_Claims =>'||l_return_status);

1587: ,p_claim_line_tbl => l_claim_line_pub_tbl
1588: ,x_object_version_number => l_object_version_number
1589: );
1590:
1591: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Update_Claims =>'||l_return_status);
1592: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message data for OZF Update_Claims =>'||l_msg_data),1,4000));
1593:
1594: END IF; --IF l_txn_hdr_rec.claim_amount > 0 THEN
1595: END IF;

Line 1592: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message data for OZF Update_Claims =>'||l_msg_data),1,4000));

1588: ,x_object_version_number => l_object_version_number
1589: );
1590:
1591: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'return status for Update_Claims =>'||l_return_status);
1592: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, substr(('Message data for OZF Update_Claims =>'||l_msg_data),1,4000));
1593:
1594: END IF; --IF l_txn_hdr_rec.claim_amount > 0 THEN
1595: END IF;
1596: l_reason := ''''||substr(l_msg_data,1,3990)||'''';

Line 1630: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Public API: ' || l_api_name || 'end');

1626: RAISE FND_API.G_EXC_ERROR;
1627: END IF;
1628:
1629: -- Debug Message
1630: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_PROCEDURE, l_module, 'Public API: ' || l_api_name || 'end');
1631:
1632: -- Standard check for p_commit
1633: IF FND_API.to_Boolean( p_commit )
1634: THEN