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_PURCHASEPRICE_PVT dependencies on FND_LOG

Line 147: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'start');

143: FND_MSG_PUB.initialize;
144: END IF;
145:
146: -- Debug Message
147: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'start');
148:
149: -- Initialize API return status to sucess
150: l_return_status := FND_API.G_RET_STS_SUCCESS;
151: l_cur_return_status := FND_API.G_RET_STS_SUCCESS;

Line 164: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module,'Invalid User');

160: FROM fnd_user
161: WHERE user_id = l_item_price_rec.last_updated_by;
162: EXCEPTION
163: WHEN NO_DATA_FOUND THEN
164: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_EXCEPTION, l_module,'Invalid User');
165: RAISE FND_API.G_EXC_ERROR;
166: WHEN OTHERS THEN
167: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
168: fnd_message.set_token('ROUTINE', 'DPP_PURCHASEPRICE_PVT');

Line 519: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Price Protection responsibility not available for Last updated user'||l_user_name);

515: FND_MESSAGE.set_name('DPP', 'DPP_INVALID_RESP');
516: FND_MESSAGE.set_token('USER', l_user_name);
517: FND_MSG_PUB.add;
518:
519: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Price Protection responsibility not available for Last updated user'||l_user_name);
520:
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523:

Line 543: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'PO Line Price Update for item: ' || l_item_cost_tbl(i).item_number

539: l_po_details_tbl(i).Document_Type := po_rec.type_lookup_code;
540: l_po_details_tbl(i).Line_Number := po_rec.line_num;
541: -- Debug Message
542:
543: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'PO Line Price Update for item: ' || l_item_cost_tbl(i).item_number
544: || ' for PO Number ' ||po_rec.po_num|| 'start');
545:
546: IF po_rec.currency_code IS NOT NULL THEN
547: IF po_rec.currency_code = l_item_cost_tbl(i).currency THEN --currency conversion req or not

Line 563: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Error in Currency Conversion to PO Currency: ' || po_rec.currency_code);

559: );
560: END IF; --currency conversion req or not
561: -- Handle currency conversion error
562: IF l_cur_return_status <> FND_API.G_RET_STS_SUCCESS THEN
563: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Error in Currency Conversion to PO Currency: ' || po_rec.currency_code);
564:
565: l_po_details_tbl(i).Reason_For_Failure := NVL(l_po_details_tbl(i).Reason_For_Failure,' ')
566: ||'Error in Currency Conversion to PO Currency: '
567: || po_rec.currency_code;

Line 583: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'No update required since PO line price is same for '||po_rec.po_num);

579: l_po_details_tbl(i).Reason_for_failure);
580: ELSE --l_cur_return_status is success
581: --Check if the Price is Same
582: IF po_rec.unit_price = l_new_price THEN
583: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'No update required since PO line price is same for '||po_rec.po_num);
584: ELSE ---po_rec.unit_price = l_new_price THEN
585: -- Debug Message
586: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Price to be updated for item: ' || l_item_cost_tbl(i).item_number || ' is ' ||l_new_price);
587:

Line 586: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Price to be updated for item: ' || l_item_cost_tbl(i).item_number || ' is ' ||l_new_price);

582: IF po_rec.unit_price = l_new_price THEN
583: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'No update required since PO line price is same for '||po_rec.po_num);
584: ELSE ---po_rec.unit_price = l_new_price THEN
585: -- Debug Message
586: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Price to be updated for item: ' || l_item_cost_tbl(i).item_number || ' is ' ||l_new_price);
587:
588: l_result := PO_CHANGE_API1_S.update_po(x_po_number => po_rec.po_num,
589: x_release_number => po_rec.release_num,
590: x_revision_number => po_rec.revision_num,

Line 608: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'PO API Result for item: ' || l_item_cost_tbl(i).item_number ||' and PO Number: '||po_rec.po_num ||' is ' ||l_result);

604: p_preferred_grade => NULL,
605: p_org_id => l_item_price_rec.org_id
606: );
607: -- Debug Message
608: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'PO API Result for item: ' || l_item_cost_tbl(i).item_number ||' and PO Number: '||po_rec.po_num ||' is ' ||l_result);
609:
610: IF (l_result <> 1) THEN
611: l_status_Update_tbl(i).update_status := 'N';
612: l_return_status := FND_API.G_RET_STS_ERROR;

Line 617: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Error Message: ' || l_api_errors.message_text(j));

613: -- Display the errors
614: FOR j IN 1..l_api_errors.message_text.COUNT LOOP
615: l_po_details_tbl(i).Reason_for_failure := l_api_errors.message_text(j);
616: -- Debug Message
617: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Error Message: ' || l_api_errors.message_text(j));
618:
619: INSERT INTO DPP_OUTPUT_XML_GT(Item_Number,
620: Document_Type,
621: Document_Number,

Line 636: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'PO Line Price Update for item: ' || l_item_cost_tbl(i).item_number

632: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
633: x_return_status := l_return_status;
634: END IF;
635: -- Debug Message
636: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'PO Line Price Update for item: ' || l_item_cost_tbl(i).item_number
637: || ' for PO Number ' ||po_rec.po_num|| 'end');
638:
639: END IF; ---po_rec.unit_price = l_new_price THEN
640: END IF; --Currency status success

Line 652: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Status before generating output xml: ' || x_return_status);

648: l_exe_update_rec.execution_status := 'WARNING';
649: END IF;
650: --OutputXML Generation
651: BEGIN
652: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Status before generating output xml: ' || x_return_status);
653:
654: --Get the output XML from DPP_OUTPUT_XML_GT table
655: l_Transaction_Number := ''''||l_item_price_rec.Transaction_Number||'''';
656: IF x_return_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 702: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Status after update execution details: ' || l_return_status);

698: ,p_EXE_UPDATE_rec => l_exe_update_rec
699: ,p_status_Update_tbl => l_status_Update_tbl
700: );
701:
702: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Status after update execution details: ' || l_return_status);
703:
704: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
705: RAISE FND_API.G_EXC_ERROR;
706: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 716: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'end');

712: THEN
713: COMMIT WORK;
714: END IF;
715: -- Debug Message
716: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'end');
717:
718: -- Standard call to get message count and if count is 1, get message info.
719: FND_MSG_PUB.Count_And_Get
720: (p_count => x_msg_count,

Line 1056: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'start');

1052: FND_MSG_PUB.initialize;
1053: END IF;
1054:
1055: -- Debug Message
1056: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'start');
1057:
1058: -- Initialize API return status to sucess
1059: x_return_status := FND_API.G_RET_STS_SUCCESS;
1060: --

Line 1092: DPP_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Inventory Item ID cannot be NULL');

1088: IF l_po_notify_item_tbl.EXISTS(1) THEN
1089: FOR i IN l_po_notify_item_tbl.FIRST..l_po_notify_item_tbl.LAST LOOP
1090: IF l_po_notify_item_tbl(i).inventory_item_id IS NULL THEN
1091: IF g_debug THEN
1092: DPP_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Inventory Item ID cannot be NULL');
1093: END IF;
1094: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1095: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
1096: FND_MSG_PUB.add;

Line 1133: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'end');

1129: END IF;
1130:
1131: -- Debug Message
1132: IF g_debug THEN
1133: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Private API: ' || l_api_name || 'end');
1134: END IF;
1135: -- Standard call to get message count and if count is 1, get message info.
1136: FND_MSG_PUB.Count_And_Get
1137: (p_count => x_msg_count,