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_BUSINESSEVENTS_PVT dependencies on DPP_UTILITY_PVT

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

104: END IF;
105:
106: -- Debug Message
107: IF g_debug THEN
108: DPP_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
109: END IF;
110:
111: -- Initialize API return status to sucess
112: x_return_status := FND_API.g_ret_sts_success;

Line 145: DPP_UTILITY_PVT.debug_message('Execution Detail ID : ' || l_exe_dtl_id ||' For Transaction ID :'||p_txn_hdr_rec.Transaction_Header_ID);

141: END IF;
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
143: END;
144: IF g_debug THEN
145: DPP_UTILITY_PVT.debug_message('Execution Detail ID : ' || l_exe_dtl_id ||' For Transaction ID :'||p_txn_hdr_rec.Transaction_Header_ID);
146: DPP_UTILITY_PVT.debug_message('Process Code : ' || p_txn_hdr_rec.process_code);
147: END IF;
148:
149: --Get the user name corresponding to the user id

Line 146: DPP_UTILITY_PVT.debug_message('Process Code : ' || p_txn_hdr_rec.process_code);

142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
143: END;
144: IF g_debug THEN
145: DPP_UTILITY_PVT.debug_message('Execution Detail ID : ' || l_exe_dtl_id ||' For Transaction ID :'||p_txn_hdr_rec.Transaction_Header_ID);
146: DPP_UTILITY_PVT.debug_message('Process Code : ' || p_txn_hdr_rec.process_code);
147: END IF;
148:
149: --Get the user name corresponding to the user id
150: BEGIN

Line 191: DPP_UTILITY_PVT.debug_message('Claim Type Flag : ' || l_claim_type_flag);

187: ELSE
188: --Concatinate the claim flag with necessary quotes to generate xml data
189: l_claim_type_flag := ''''||p_txn_hdr_rec.claim_type_flag||'''';
190: IF g_debug THEN
191: DPP_UTILITY_PVT.debug_message('Claim Type Flag : ' || l_claim_type_flag);
192: END IF;
193: END IF;
194: --Delete the existing rows from the DPP_TRANSACTION_LINES_GT table
195: DELETE FROM DPP_TRANSACTION_LINES_GT;

Line 324: DPP_UTILITY_PVT.debug_message('Unable to Update the column update_item_list_price in DPP_TRANSACTION_LINES_ALL Table');

320: AND nvl(update_item_list_price, 'N') = 'N';
321:
322: IF SQL%ROWCOUNT = 0 THEN
323: l_return_status := FND_API.G_RET_STS_ERROR;
324: DPP_UTILITY_PVT.debug_message('Unable to Update the column update_item_list_price in DPP_TRANSACTION_LINES_ALL Table');
325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
326: END IF;
327:
328: END IF;

Line 378: DPP_UTILITY_PVT.debug_message('Unable to Update the column NOTIFY_OUTBOUND_PRICELIST in DPP_TRANSACTION_LINES_ALL Table');

374: AND nvl(NOTIFY_OUTBOUND_PRICELIST,'N') <> 'D';
375:
376: IF SQL%ROWCOUNT = 0 THEN
377: l_return_status := FND_API.G_RET_STS_ERROR;
378: DPP_UTILITY_PVT.debug_message('Unable to Update the column NOTIFY_OUTBOUND_PRICELIST in DPP_TRANSACTION_LINES_ALL Table');
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381: END IF;
382:

Line 501: DPP_UTILITY_PVT.debug_message('Unable to Update the column NOTIFY_INBOUND_PRICELIST in DPP_TRANSACTION_LINES_ALL Table');

497: AND nvl(NOTIFY_INBOUND_PRICELIST,'N') <> 'D';
498:
499: IF SQL%ROWCOUNT = 0 THEN
500: l_return_status := FND_API.G_RET_STS_ERROR;
501: DPP_UTILITY_PVT.debug_message('Unable to Update the column NOTIFY_INBOUND_PRICELIST in DPP_TRANSACTION_LINES_ALL Table');
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504: END IF;
505:

Line 555: DPP_UTILITY_PVT.debug_message('Unable to Update the column NOTIFY_PROMOTIONS_PRICELIST in DPP_TRANSACTION_LINES_ALL Table');

551: AND nvl(NOTIFY_PROMOTIONS_PRICELIST,'N') <> 'D';
552:
553: IF SQL%ROWCOUNT = 0 THEN
554: l_return_status := FND_API.G_RET_STS_ERROR;
555: DPP_UTILITY_PVT.debug_message('Unable to Update the column NOTIFY_PROMOTIONS_PRICELIST in DPP_TRANSACTION_LINES_ALL Table');
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
558: END IF;
559: ELSIF p_txn_hdr_rec.process_code = 'INVC' THEN

Line 622: DPP_UTILITY_PVT.debug_message('Cost Adjustment Account : ' ||l_cost_adj_acct);

618: END IF;
619:
620: IF l_cost_adj_acct IS NOT NULL THEN
621: IF g_debug THEN
622: DPP_UTILITY_PVT.debug_message('Cost Adjustment Account : ' ||l_cost_adj_acct);
623: END IF;
624: --Generate the Input Xml required for the Business Event -- Update Inventory Costing
625: l_queryCtx := dbms_xmlquery.newContext('SELECT Transaction_header_id,
626: Transaction_number,

Line 672: DPP_UTILITY_PVT.debug_message('Unable to Update the column UPDATE_INVENTORY_COSTING in DPP_TRANSACTION_LINES_ALL Table');

668: AND nvl(UPDATE_INVENTORY_COSTING,'N') = 'N';
669:
670: IF SQL%ROWCOUNT = 0 THEN
671: l_return_status := FND_API.G_RET_STS_ERROR;
672: DPP_UTILITY_PVT.debug_message('Unable to Update the column UPDATE_INVENTORY_COSTING in DPP_TRANSACTION_LINES_ALL Table');
673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
674: END IF;
675: END IF;
676: ELSE

Line 738: DPP_UTILITY_PVT.debug_message('Unable to Update the column notify_purchasing_docs in DPP_TRANSACTION_LINES_ALL Table');

734: AND nvl(notify_purchasing_docs ,'N') <> 'D';
735:
736: IF SQL%ROWCOUNT = 0 THEN
737: l_return_status := FND_API.G_RET_STS_ERROR;
738: DPP_UTILITY_PVT.debug_message('Unable to Update the column notify_purchasing_docs in DPP_TRANSACTION_LINES_ALL Table');
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: END IF;
741: END IF;
742: ELSIF p_txn_hdr_rec.process_code = 'UPDTPO' THEN

Line 790: DPP_UTILITY_PVT.debug_message('Unable to Update the column UPDATE_PURCHASING_DOCS in DPP_TRANSACTION_LINES_ALL Table');

786: AND nvl(UPDATE_PURCHASING_DOCS ,'N')= 'N';
787:
788: IF SQL%ROWCOUNT = 0 THEN
789: l_return_status := FND_API.G_RET_STS_ERROR;
790: DPP_UTILITY_PVT.debug_message('Unable to Update the column UPDATE_PURCHASING_DOCS in DPP_TRANSACTION_LINES_ALL Table');
791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
792: END IF;
793: END IF;
794: ELSIF p_txn_hdr_rec.process_code = 'DSTRINVCL' THEN

Line 902: DPP_UTILITY_PVT.debug_message('Unable to Update the column SUPP_DIST_CLAIM_STATUS in DPP_TRANSACTION_LINES_ALL Table');

898: AND nvl(price_change,0) > 0;
899:
900: IF SQL%ROWCOUNT = 0 THEN
901: l_return_status := FND_API.G_RET_STS_ERROR;
902: DPP_UTILITY_PVT.debug_message('Unable to Update the column SUPP_DIST_CLAIM_STATUS in DPP_TRANSACTION_LINES_ALL Table');
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: END IF;
905: --Update those lines to Y who have the approved inventory as 0
906: UPDATE DPP_TRANSACTION_LINES_ALL

Line 930: DPP_UTILITY_PVT.debug_message('Unable to Update the column SUPP_DIST_CLAIM_STATUS in DPP_TRANSACTION_LINES_ALL Table');

926: AND nvl(price_change,0) <> 0;
927:
928: IF SQL%ROWCOUNT = 0 THEN
929: l_return_status := FND_API.G_RET_STS_ERROR;
930: DPP_UTILITY_PVT.debug_message('Unable to Update the column SUPP_DIST_CLAIM_STATUS in DPP_TRANSACTION_LINES_ALL Table');
931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
932: END IF;
933: --Update those lines to Y who have the approved inventory as 0
934: UPDATE DPP_TRANSACTION_LINES_ALL

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

1006: AND nvl(supp_claim_amt,0) > 0;
1007:
1008: IF SQL%ROWCOUNT = 0 THEN
1009: l_return_status := FND_API.G_RET_STS_ERROR;
1010: DPP_UTILITY_PVT.debug_message('Unable to Update the column supplier_claim_created in DPP_customer_claims_all Table');
1011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1012: END IF;
1013: --Update those lines to Y which have reported inventory as 0
1014: UPDATE DPP_customer_claims_all

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

1155: ,p_row_count => l_row_count
1156: ,p_exe_dtl_id => l_exe_dtl_id
1157: );
1158: IF g_debug THEN
1159: dpp_utility_pvt.debug_message('return status for Raise_Workflow_Event =>'||l_return_status);
1160: --dpp_utility_pvt.debug_message (substr(('Message data =>'||l_msg_data),1,4000));
1161: END IF;
1162: -- Check return status from the above procedure call
1163: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1160: --dpp_utility_pvt.debug_message (substr(('Message data =>'||l_msg_data),1,4000));

1156: ,p_exe_dtl_id => l_exe_dtl_id
1157: );
1158: IF g_debug THEN
1159: dpp_utility_pvt.debug_message('return status for Raise_Workflow_Event =>'||l_return_status);
1160: --dpp_utility_pvt.debug_message (substr(('Message data =>'||l_msg_data),1,4000));
1161: END IF;
1162: -- Check return status from the above procedure call
1163: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1164: RAISE FND_API.g_exc_error;

Line 1282: DPP_UTILITY_PVT.debug_message('No enabled local subscriptions reference the event, or the event does not exist.');

1278: l_new_item_key := TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
1279: --Check if the event subscription can be raised or not before inserting into the DPP_EXECUTION_DETAILS table
1280: l_event_test := wf_event.test(l_event_name);
1281: IF l_event_test = 'NONE' THEN
1282: DPP_UTILITY_PVT.debug_message('No enabled local subscriptions reference the event, or the event does not exist.');
1283: RAISE FND_API.g_exc_error;
1284: ELSE
1285: IF g_debug THEN
1286: DPP_UTILITY_PVT.debug_message('Number of rows Processed : '||p_row_count);

Line 1286: DPP_UTILITY_PVT.debug_message('Number of rows Processed : '||p_row_count);

1282: DPP_UTILITY_PVT.debug_message('No enabled local subscriptions reference the event, or the event does not exist.');
1283: RAISE FND_API.g_exc_error;
1284: ELSE
1285: IF g_debug THEN
1286: DPP_UTILITY_PVT.debug_message('Number of rows Processed : '||p_row_count);
1287: END IF;
1288: --Check if the xml has any rows processed and raise the event
1289: IF p_row_count > 0 THEN
1290: --Insert a line in to the DPP_EXECUTION_DETAILS table corresponding to the process which has been started

Line 1349: DPP_UTILITY_PVT.debug_message('Work Flow Event Raised');

1345: ,p_parameters => l_parameter_list
1346: ,p_send_date => sysdate
1347: );
1348: IF g_debug THEN
1349: DPP_UTILITY_PVT.debug_message('Work Flow Event Raised');
1350: END IF;
1351: ELSE
1352: IF g_debug THEN
1353: DPP_UTILITY_PVT.debug_message('Work Flow Event is not Raised');

Line 1353: DPP_UTILITY_PVT.debug_message('Work Flow Event is not Raised');

1349: DPP_UTILITY_PVT.debug_message('Work Flow Event Raised');
1350: END IF;
1351: ELSE
1352: IF g_debug THEN
1353: DPP_UTILITY_PVT.debug_message('Work Flow Event is not Raised');
1354: END IF;
1355: FND_MESSAGE.set_name('DPP', 'DPP_CC_NO_ELIGIBLE_LINES_MSG');
1356: FND_MSG_PUB.add;
1357: RAISE FND_API.g_exc_error;