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_UTILITY_PVT

Line 221: DPP_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

217: FND_MSG_PUB.initialize;
218: END IF;
219: -- Debug Message
220: IF g_debug THEN
221: DPP_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
222: END IF;
223: -- Initialize API return status to success
224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225:

Line 227: DPP_UTILITY_PVT.debug_message('Transaction Number: ' || l_txn_hdr_rec.Transaction_number);

223: -- Initialize API return status to success
224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225:
226: IF g_debug THEN
227: DPP_UTILITY_PVT.debug_message('Transaction Number: ' || l_txn_hdr_rec.Transaction_number);
228: DPP_UTILITY_PVT.debug_message('Claim Type Flag: ' || l_txn_hdr_rec.claim_type_flag);
229: END IF;
230: l_transaction_number := ''''||l_txn_hdr_rec.Transaction_number||'''';
231:

Line 228: DPP_UTILITY_PVT.debug_message('Claim Type Flag: ' || l_txn_hdr_rec.claim_type_flag);

224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225:
226: IF g_debug THEN
227: DPP_UTILITY_PVT.debug_message('Transaction Number: ' || l_txn_hdr_rec.Transaction_number);
228: DPP_UTILITY_PVT.debug_message('Claim Type Flag: ' || l_txn_hdr_rec.claim_type_flag);
229: END IF;
230: l_transaction_number := ''''||l_txn_hdr_rec.Transaction_number||'''';
231:
232: MO_GLOBAL.set_policy_context('S',l_txn_hdr_rec.org_id);

Line 270: DPP_UTILITY_PVT.debug_message('Pre Approval Required : ' || l_approval_flag);

266: END IF;
267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
268: END;
269: IF g_debug THEN
270: DPP_UTILITY_PVT.debug_message('Pre Approval Required : ' || l_approval_flag);
271: DPP_UTILITY_PVT.debug_message('Customer Account ID : ' || l_cust_account_id);
272: END IF;
273:
274: --Added code for DPP Price Increase Enhancement

Line 271: DPP_UTILITY_PVT.debug_message('Customer Account ID : ' || l_cust_account_id);

267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
268: END;
269: IF g_debug THEN
270: DPP_UTILITY_PVT.debug_message('Pre Approval Required : ' || l_approval_flag);
271: DPP_UTILITY_PVT.debug_message('Customer Account ID : ' || l_cust_account_id);
272: END IF;
273:
274: --Added code for DPP Price Increase Enhancement
275: --Segregate the lines according to the claim_amount

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 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 426: DPP_UTILITY_PVT.debug_message('l_txn_hdr_rec.claim_amount : ' || l_txn_hdr_rec.claim_amount);

422: l_claim_pub_rec.cust_account_id := l_cust_account_id;
423: l_claim_pub_rec.claim_class := 'CLAIM';
424:
425: IF g_debug THEN
426: DPP_UTILITY_PVT.debug_message('l_txn_hdr_rec.claim_amount : ' || l_txn_hdr_rec.claim_amount);
427: END IF;
428:
429: l_claim_pub_rec.currency_code := l_txn_hdr_rec.currency_code;
430: l_claim_pub_rec.vendor_id := l_txn_hdr_rec.Vendor_ID;

Line 489: DPP_UTILITY_PVT.debug_message('l_claim_line_pub_tbl(i).claim_currency_amount: ' || l_claim_line_pub_tbl(i).claim_currency_amount);

485: l_claim_line_pub_tbl(i).claim_currency_amount := l_txn_line_tbl(i).Claim_Line_Amount;
486: END IF;
487:
488: IF g_debug THEN
489: DPP_UTILITY_PVT.debug_message('l_claim_line_pub_tbl(i).claim_currency_amount: ' || l_claim_line_pub_tbl(i).claim_currency_amount);
490: END IF;
491:
492: l_claim_line_pub_tbl(i).item_description := l_item_description;
493: l_claim_line_pub_tbl(i).item_type := l_item_type;

Line 513: dpp_utility_pvt.debug_message('return status for Create_Claim =>'||l_return_status);

509: p_claim_line_tbl => l_claim_line_pub_tbl,
510: x_claim_id => l_x_claim_id
511: );
512: IF g_debug THEN
513: dpp_utility_pvt.debug_message('return status for Create_Claim =>'||l_return_status);
514: dpp_utility_pvt.debug_message (substr(('Message data from OZF Create Claim =>'||l_msg_data),1,4000));
515: END IF;
516: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
517: x_return_status := l_return_status;

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

510: x_claim_id => l_x_claim_id
511: );
512: IF g_debug THEN
513: dpp_utility_pvt.debug_message('return status for Create_Claim =>'||l_return_status);
514: dpp_utility_pvt.debug_message (substr(('Message data from OZF Create Claim =>'||l_msg_data),1,4000));
515: END IF;
516: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
517: x_return_status := l_return_status;
518: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

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 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 611: DPP_UTILITY_PVT.debug_message('Unable to Update the column supp_dist_claim_id in DPP_TRANSACTION_LINES_ALL Table');

607: last_update_login = l_txn_hdr_rec.LAST_UPDATED_BY
608: WHERE transaction_line_id = l_txn_line_tbl(i).transaction_line_id;
609:
610: IF SQL%ROWCOUNT = 0 THEN
611: DPP_UTILITY_PVT.debug_message('Unable to Update the column supp_dist_claim_id in DPP_TRANSACTION_LINES_ALL Table');
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: END IF;
614: END LOOP; --getting the claim id loop
615: END LOOP; --lines table loop

Line 680: dpp_utility_pvt.debug_message('return status for OZF Update_Claims =>'||l_return_status);

676: ,p_claim_line_tbl => l_claim_line_pub_tbl
677: ,x_object_version_number => l_object_version_number
678: );
679: IF g_debug THEN
680: dpp_utility_pvt.debug_message('return status for OZF Update_Claims =>'||l_return_status);
681: dpp_utility_pvt.debug_message(substr(('Message data for OZF Update_Claims =>'||l_msg_data),1,4000));
682: END IF;
683: --If the claim updation process failed
684: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

677: ,x_object_version_number => l_object_version_number
678: );
679: IF g_debug THEN
680: dpp_utility_pvt.debug_message('return status for OZF Update_Claims =>'||l_return_status);
681: dpp_utility_pvt.debug_message(substr(('Message data for OZF Update_Claims =>'||l_msg_data),1,4000));
682: END IF;
683: --If the claim updation process failed
684: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
685: x_return_status := l_return_status;

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 747: dpp_utility_pvt.debug_message('return status for Create_Claim =>'||l_return_status);

743: p_claim_line_tbl => l_claim_line_pub_tbl,
744: x_claim_id => l_x_claim_id
745: );
746: IF g_debug THEN
747: dpp_utility_pvt.debug_message('return status for Create_Claim =>'||l_return_status);
748: dpp_utility_pvt.debug_message(substr(('Message Data for OZF Create_Claim =>'||l_msg_data),1,4000));
749: END IF;
750:
751: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

744: x_claim_id => l_x_claim_id
745: );
746: IF g_debug THEN
747: dpp_utility_pvt.debug_message('return status for Create_Claim =>'||l_return_status);
748: dpp_utility_pvt.debug_message(substr(('Message Data for OZF Create_Claim =>'||l_msg_data),1,4000));
749: END IF;
750:
751: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
752: x_return_status := l_return_status;

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 818: dpp_utility_pvt.debug_message('return status for Update_Claims =>'||l_return_status);

814: ,p_claim_line_tbl => l_claim_line_pub_tbl_updt
815: ,x_object_version_number => l_object_version_number
816: );
817: IF g_debug THEN
818: dpp_utility_pvt.debug_message('return status for Update_Claims =>'||l_return_status);
819: dpp_utility_pvt.debug_message(substr(('Message data for OZF Update_Claims =>'||l_msg_data),1,4000));
820: END IF;
821: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
822: x_return_status := l_return_status;

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

815: ,x_object_version_number => l_object_version_number
816: );
817: IF g_debug THEN
818: dpp_utility_pvt.debug_message('return status for Update_Claims =>'||l_return_status);
819: dpp_utility_pvt.debug_message(substr(('Message data for OZF Update_Claims =>'||l_msg_data),1,4000));
820: END IF;
821: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
822: x_return_status := l_return_status;
823: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

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 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 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 959: dpp_utility_pvt.debug_message('return status for Create_Claim =>'||l_return_status);

955: p_claim_line_tbl => l_claim_line_pub_tbl,
956: x_claim_id => l_x_claim_id
957: );
958: IF g_debug THEN
959: dpp_utility_pvt.debug_message('return status for Create_Claim =>'||l_return_status);
960: dpp_utility_pvt.debug_message(substr(('Message data for OZF Create_Claim =>'||l_msg_data),1,4000));
961: END IF;
962: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
963: x_return_status := l_return_status;

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

956: x_claim_id => l_x_claim_id
957: );
958: IF g_debug THEN
959: dpp_utility_pvt.debug_message('return status for Create_Claim =>'||l_return_status);
960: dpp_utility_pvt.debug_message(substr(('Message data for OZF Create_Claim =>'||l_msg_data),1,4000));
961: END IF;
962: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
963: x_return_status := l_return_status;
964: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

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 1030: dpp_utility_pvt.debug_message('return status for Update_Claims =>'||l_return_status);

1026: ,p_claim_line_tbl => l_claim_line_pub_tbl_updt
1027: ,x_object_version_number => l_object_version_number
1028: );
1029: IF g_debug THEN
1030: dpp_utility_pvt.debug_message('return status for Update_Claims =>'||l_return_status);
1031: dpp_utility_pvt.debug_message(substr(('Message Data for OZF Update_Claims =>'||l_msg_data),1,4000));
1032: END IF;
1033: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1034: x_return_status := l_return_status;

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

1027: ,x_object_version_number => l_object_version_number
1028: );
1029: IF g_debug THEN
1030: dpp_utility_pvt.debug_message('return status for Update_Claims =>'||l_return_status);
1031: dpp_utility_pvt.debug_message(substr(('Message Data for OZF Update_Claims =>'||l_msg_data),1,4000));
1032: END IF;
1033: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1034: x_return_status := l_return_status;
1035: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

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

Line 1188: DPP_UTILITY_PVT.debug_message('Unable to Update DPP_EXECUTION_DETAILS Table');

1184: WHERE EXECUTION_DETAIL_ID = l_txn_hdr_rec.Execution_Detail_ID
1185: AND transaction_header_id = l_txn_hdr_rec.Transaction_Header_ID;
1186:
1187: IF SQL%ROWCOUNT = 0 THEN
1188: DPP_UTILITY_PVT.debug_message('Unable to Update DPP_EXECUTION_DETAILS Table');
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190: END IF;
1191: */
1192:

Line 1196: DPP_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

1192:
1193:
1194: -- Debug Message
1195: IF g_debug THEN
1196: DPP_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
1197: END IF;
1198: -- Standard check for p_commit
1199: IF FND_API.to_Boolean( p_commit )
1200: THEN

Line 1210: WHEN DPP_UTILITY_PVT.resource_locked THEN

1206: p_data => x_msg_data
1207: );
1208: --Exception Handling
1209: EXCEPTION
1210: WHEN DPP_UTILITY_PVT.resource_locked THEN
1211: ROLLBACK TO CREATE_CLAIMS_PVT;
1212: x_return_status := FND_API.g_ret_sts_error;
1213: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');
1214: FND_MSG_PUB.Count_And_Get (

Line 1213: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');

1209: EXCEPTION
1210: WHEN DPP_UTILITY_PVT.resource_locked THEN
1211: ROLLBACK TO CREATE_CLAIMS_PVT;
1212: x_return_status := FND_API.g_ret_sts_error;
1213: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');
1214: FND_MSG_PUB.Count_And_Get (
1215: p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data

Line 1350: DPP_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

1346: END IF;
1347:
1348: -- Debug Message
1349: IF g_debug THEN
1350: DPP_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
1351: END IF;
1352: -- Initialize API return status to sucess
1353: l_return_status := FND_API.G_RET_STS_SUCCESS;
1354:

Line 1373: DPP_UTILITY_PVT.debug_message('Transaction Number: ' || l_txn_hdr_rec.Transaction_number);

1369: RAISE FND_API.G_EXC_ERROR;
1370: ELSE
1371: l_transaction_number := ''''||l_txn_hdr_rec.Transaction_number||'''';
1372: IF g_debug THEN
1373: DPP_UTILITY_PVT.debug_message('Transaction Number: ' || l_txn_hdr_rec.Transaction_number);
1374: DPP_UTILITY_PVT.debug_message('Claim Id to be updated : ' || l_txn_hdr_rec.claim_id);
1375: END IF;
1376: END IF;
1377: --

Line 1374: DPP_UTILITY_PVT.debug_message('Claim Id to be updated : ' || l_txn_hdr_rec.claim_id);

1370: ELSE
1371: l_transaction_number := ''''||l_txn_hdr_rec.Transaction_number||'''';
1372: IF g_debug THEN
1373: DPP_UTILITY_PVT.debug_message('Transaction Number: ' || l_txn_hdr_rec.Transaction_number);
1374: DPP_UTILITY_PVT.debug_message('Claim Id to be updated : ' || l_txn_hdr_rec.claim_id);
1375: END IF;
1376: END IF;
1377: --
1378: -- API body

Line 1513: dpp_utility_pvt.debug_message('return status for Update_Claims =>'||l_return_status);

1509: ,p_claim_line_tbl => l_claim_line_pub_tbl
1510: ,x_object_version_number => l_object_version_number
1511: );
1512: IF g_debug THEN
1513: dpp_utility_pvt.debug_message('return status for Update_Claims =>'||l_return_status);
1514: dpp_utility_pvt.debug_message(substr(('Message Data for OZF Update_Claims =>'||l_msg_data),1,4000));
1515: END IF;
1516: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1517: IF g_debug THEN

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

1510: ,x_object_version_number => l_object_version_number
1511: );
1512: IF g_debug THEN
1513: dpp_utility_pvt.debug_message('return status for Update_Claims =>'||l_return_status);
1514: dpp_utility_pvt.debug_message(substr(('Message Data for OZF Update_Claims =>'||l_msg_data),1,4000));
1515: END IF;
1516: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1517: IF g_debug THEN
1518: dpp_utility_pvt.debug_message('return status for Update_Claims =>'||l_return_status);

Line 1518: dpp_utility_pvt.debug_message('return status for Update_Claims =>'||l_return_status);

1514: dpp_utility_pvt.debug_message(substr(('Message Data for OZF Update_Claims =>'||l_msg_data),1,4000));
1515: END IF;
1516: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1517: IF g_debug THEN
1518: dpp_utility_pvt.debug_message('return status for Update_Claims =>'||l_return_status);
1519: dpp_utility_pvt.debug_message('Unable to Update the claim to OPEN status');
1520: END IF;
1521: ELSE
1522: --Bug#6928445

Line 1519: dpp_utility_pvt.debug_message('Unable to Update the claim to OPEN status');

1515: END IF;
1516: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1517: IF g_debug THEN
1518: dpp_utility_pvt.debug_message('return status for Update_Claims =>'||l_return_status);
1519: dpp_utility_pvt.debug_message('Unable to Update the claim to OPEN status');
1520: END IF;
1521: ELSE
1522: --Bug#6928445
1523: IF l_txn_hdr_rec.claim_amount <> 0 THEN --ANBBALAS: For Price Increase enhancement

Line 1578: dpp_utility_pvt.debug_message('return status for Update_Claims =>'||l_return_status);

1574: ,p_claim_line_tbl => l_claim_line_pub_tbl
1575: ,x_object_version_number => l_object_version_number
1576: );
1577: IF g_debug THEN
1578: dpp_utility_pvt.debug_message('return status for Update_Claims =>'||l_return_status);
1579: dpp_utility_pvt.debug_message(substr(('Message data for OZF Update_Claims =>'||l_msg_data),1,4000));
1580: END IF;
1581: END IF; --IF l_txn_hdr_rec.claim_amount > 0 THEN
1582: END IF;

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

1575: ,x_object_version_number => l_object_version_number
1576: );
1577: IF g_debug THEN
1578: dpp_utility_pvt.debug_message('return status for Update_Claims =>'||l_return_status);
1579: dpp_utility_pvt.debug_message(substr(('Message data for OZF Update_Claims =>'||l_msg_data),1,4000));
1580: END IF;
1581: END IF; --IF l_txn_hdr_rec.claim_amount > 0 THEN
1582: END IF;
1583: l_reason := ''''||substr(l_msg_data,1,3990)||'''';

Line 1618: DPP_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

1614: END IF;
1615:
1616: -- Debug Message
1617: IF g_debug THEN
1618: DPP_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
1619: END IF;
1620: -- Standard check for p_commit
1621: IF FND_API.to_Boolean( p_commit )
1622: THEN

Line 1632: WHEN DPP_UTILITY_PVT.resource_locked THEN

1628: p_data => x_msg_data
1629: );
1630: --Exception Handling
1631: EXCEPTION
1632: WHEN DPP_UTILITY_PVT.resource_locked THEN
1633: ROLLBACK TO UPDATE_CLAIMS_PVT;
1634: x_return_status := FND_API.g_ret_sts_error;
1635: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');
1636: FND_MSG_PUB.Count_And_Get (

Line 1635: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');

1631: EXCEPTION
1632: WHEN DPP_UTILITY_PVT.resource_locked THEN
1633: ROLLBACK TO UPDATE_CLAIMS_PVT;
1634: x_return_status := FND_API.g_ret_sts_error;
1635: DPP_UTILITY_PVT.Error_Message(p_message_name => 'API_RESOURCE_LOCKED');
1636: FND_MSG_PUB.Count_And_Get (
1637: p_encoded => FND_API.G_FALSE,
1638: p_count => x_msg_count,
1639: p_data => x_msg_data