DBA Data[Home] [Help]

APPS.DPP_TRANSACTION_PVT dependencies on WF_EVENT

Line 11: --08-Feb-08 sanagar Included event and subscription test(wf_event.test)

7: --29-Jan-08 sanagar Bug 6773981
8: --06-Feb-08 sanagar Negative Change Value Handled
9: -- suppliername,Supplier site and Ref Doc Number identifies transaction
10: -- Update_claimsApproval claim id included in query.
11: --08-Feb-08 sanagar Included event and subscription test(wf_event.test)
12: -- Rounded change value to 2 decimal
13: --08-Feb-08 sanagar BUG 6806974
14: --24-Feb-08 sanagar BUG 6816594
15: --03-Mar-08 sanagar BUG 6856618

Line 4610: l_event_test := wf_event.test(l_event_name);

4606: -- Initialize API return status to sucess
4607: x_return_status := fnd_api.g_ret_sts_success;
4608: evtkey := dbms_utility.get_time();
4609: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Event Key = ' || evtkey);
4610: l_event_test := wf_event.test(l_event_name);
4611: IF l_event_test = 'NONE' THEN
4612: fnd_message.set_name('DPP', 'DPP_EVENT_SUBS_ERR');
4613: fnd_message.set_token('CLAIM_NUMBER', p_claim_id);
4614: x_msg_data := fnd_message.get();

Line 4619: wf_event.addparametertolist(p_name => 'ECX_MAP_CODE', p_value => l_map_code, p_parameterlist => l_parameter_list);

4615: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'No enabled local subscriptions reference the event, or the event does not exist.');
4616: RAISE FND_API.g_exc_error;
4617: END IF;
4618: -- DEFINE IN WF ATTRIBUTES
4619: wf_event.addparametertolist(p_name => 'ECX_MAP_CODE', p_value => l_map_code, p_parameterlist => l_parameter_list);
4620: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_TYPE', p_value => l_transaction_type, p_parameterlist => l_parameter_list);
4621: wf_event.addparametertolist(p_name => 'ECX_PARTY_TYPE', p_value => p_party_type, p_parameterlist => l_parameter_list);
4622: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_SUBTYPE', p_value => l_transaction_sub_type, p_parameterlist => l_parameter_list);
4623: wf_event.addparametertolist(p_name => 'ECX_PARTY_ID', p_value => p_party_id, p_parameterlist => l_parameter_list);

Line 4620: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_TYPE', p_value => l_transaction_type, p_parameterlist => l_parameter_list);

4616: RAISE FND_API.g_exc_error;
4617: END IF;
4618: -- DEFINE IN WF ATTRIBUTES
4619: wf_event.addparametertolist(p_name => 'ECX_MAP_CODE', p_value => l_map_code, p_parameterlist => l_parameter_list);
4620: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_TYPE', p_value => l_transaction_type, p_parameterlist => l_parameter_list);
4621: wf_event.addparametertolist(p_name => 'ECX_PARTY_TYPE', p_value => p_party_type, p_parameterlist => l_parameter_list);
4622: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_SUBTYPE', p_value => l_transaction_sub_type, p_parameterlist => l_parameter_list);
4623: wf_event.addparametertolist(p_name => 'ECX_PARTY_ID', p_value => p_party_id, p_parameterlist => l_parameter_list);
4624: wf_event.addparametertolist(p_name => 'ECX_PARTY_SITE_ID', p_value => p_party_site_id, p_parameterlist => l_parameter_list);

Line 4621: wf_event.addparametertolist(p_name => 'ECX_PARTY_TYPE', p_value => p_party_type, p_parameterlist => l_parameter_list);

4617: END IF;
4618: -- DEFINE IN WF ATTRIBUTES
4619: wf_event.addparametertolist(p_name => 'ECX_MAP_CODE', p_value => l_map_code, p_parameterlist => l_parameter_list);
4620: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_TYPE', p_value => l_transaction_type, p_parameterlist => l_parameter_list);
4621: wf_event.addparametertolist(p_name => 'ECX_PARTY_TYPE', p_value => p_party_type, p_parameterlist => l_parameter_list);
4622: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_SUBTYPE', p_value => l_transaction_sub_type, p_parameterlist => l_parameter_list);
4623: wf_event.addparametertolist(p_name => 'ECX_PARTY_ID', p_value => p_party_id, p_parameterlist => l_parameter_list);
4624: wf_event.addparametertolist(p_name => 'ECX_PARTY_SITE_ID', p_value => p_party_site_id, p_parameterlist => l_parameter_list);
4625: wf_event.addparametertolist(p_name => 'ECX_DOCUMENT_ID', p_value => p_claim_id, p_parameterlist => l_parameter_list);

Line 4622: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_SUBTYPE', p_value => l_transaction_sub_type, p_parameterlist => l_parameter_list);

4618: -- DEFINE IN WF ATTRIBUTES
4619: wf_event.addparametertolist(p_name => 'ECX_MAP_CODE', p_value => l_map_code, p_parameterlist => l_parameter_list);
4620: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_TYPE', p_value => l_transaction_type, p_parameterlist => l_parameter_list);
4621: wf_event.addparametertolist(p_name => 'ECX_PARTY_TYPE', p_value => p_party_type, p_parameterlist => l_parameter_list);
4622: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_SUBTYPE', p_value => l_transaction_sub_type, p_parameterlist => l_parameter_list);
4623: wf_event.addparametertolist(p_name => 'ECX_PARTY_ID', p_value => p_party_id, p_parameterlist => l_parameter_list);
4624: wf_event.addparametertolist(p_name => 'ECX_PARTY_SITE_ID', p_value => p_party_site_id, p_parameterlist => l_parameter_list);
4625: wf_event.addparametertolist(p_name => 'ECX_DOCUMENT_ID', p_value => p_claim_id, p_parameterlist => l_parameter_list);
4626: wf_event.addparametertolist(p_name => 'ECX_DEBUG_LEVEL', p_value => l_debug_mode, p_parameterlist => l_parameter_list);

Line 4623: wf_event.addparametertolist(p_name => 'ECX_PARTY_ID', p_value => p_party_id, p_parameterlist => l_parameter_list);

4619: wf_event.addparametertolist(p_name => 'ECX_MAP_CODE', p_value => l_map_code, p_parameterlist => l_parameter_list);
4620: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_TYPE', p_value => l_transaction_type, p_parameterlist => l_parameter_list);
4621: wf_event.addparametertolist(p_name => 'ECX_PARTY_TYPE', p_value => p_party_type, p_parameterlist => l_parameter_list);
4622: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_SUBTYPE', p_value => l_transaction_sub_type, p_parameterlist => l_parameter_list);
4623: wf_event.addparametertolist(p_name => 'ECX_PARTY_ID', p_value => p_party_id, p_parameterlist => l_parameter_list);
4624: wf_event.addparametertolist(p_name => 'ECX_PARTY_SITE_ID', p_value => p_party_site_id, p_parameterlist => l_parameter_list);
4625: wf_event.addparametertolist(p_name => 'ECX_DOCUMENT_ID', p_value => p_claim_id, p_parameterlist => l_parameter_list);
4626: wf_event.addparametertolist(p_name => 'ECX_DEBUG_LEVEL', p_value => l_debug_mode, p_parameterlist => l_parameter_list);
4627: wf_event.RAISE(l_event_name, evtkey, NULL, l_parameter_list, sysdate);

Line 4624: wf_event.addparametertolist(p_name => 'ECX_PARTY_SITE_ID', p_value => p_party_site_id, p_parameterlist => l_parameter_list);

4620: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_TYPE', p_value => l_transaction_type, p_parameterlist => l_parameter_list);
4621: wf_event.addparametertolist(p_name => 'ECX_PARTY_TYPE', p_value => p_party_type, p_parameterlist => l_parameter_list);
4622: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_SUBTYPE', p_value => l_transaction_sub_type, p_parameterlist => l_parameter_list);
4623: wf_event.addparametertolist(p_name => 'ECX_PARTY_ID', p_value => p_party_id, p_parameterlist => l_parameter_list);
4624: wf_event.addparametertolist(p_name => 'ECX_PARTY_SITE_ID', p_value => p_party_site_id, p_parameterlist => l_parameter_list);
4625: wf_event.addparametertolist(p_name => 'ECX_DOCUMENT_ID', p_value => p_claim_id, p_parameterlist => l_parameter_list);
4626: wf_event.addparametertolist(p_name => 'ECX_DEBUG_LEVEL', p_value => l_debug_mode, p_parameterlist => l_parameter_list);
4627: wf_event.RAISE(l_event_name, evtkey, NULL, l_parameter_list, sysdate);
4628:

Line 4625: wf_event.addparametertolist(p_name => 'ECX_DOCUMENT_ID', p_value => p_claim_id, p_parameterlist => l_parameter_list);

4621: wf_event.addparametertolist(p_name => 'ECX_PARTY_TYPE', p_value => p_party_type, p_parameterlist => l_parameter_list);
4622: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_SUBTYPE', p_value => l_transaction_sub_type, p_parameterlist => l_parameter_list);
4623: wf_event.addparametertolist(p_name => 'ECX_PARTY_ID', p_value => p_party_id, p_parameterlist => l_parameter_list);
4624: wf_event.addparametertolist(p_name => 'ECX_PARTY_SITE_ID', p_value => p_party_site_id, p_parameterlist => l_parameter_list);
4625: wf_event.addparametertolist(p_name => 'ECX_DOCUMENT_ID', p_value => p_claim_id, p_parameterlist => l_parameter_list);
4626: wf_event.addparametertolist(p_name => 'ECX_DEBUG_LEVEL', p_value => l_debug_mode, p_parameterlist => l_parameter_list);
4627: wf_event.RAISE(l_event_name, evtkey, NULL, l_parameter_list, sysdate);
4628:
4629: COMMIT;

Line 4626: wf_event.addparametertolist(p_name => 'ECX_DEBUG_LEVEL', p_value => l_debug_mode, p_parameterlist => l_parameter_list);

4622: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_SUBTYPE', p_value => l_transaction_sub_type, p_parameterlist => l_parameter_list);
4623: wf_event.addparametertolist(p_name => 'ECX_PARTY_ID', p_value => p_party_id, p_parameterlist => l_parameter_list);
4624: wf_event.addparametertolist(p_name => 'ECX_PARTY_SITE_ID', p_value => p_party_site_id, p_parameterlist => l_parameter_list);
4625: wf_event.addparametertolist(p_name => 'ECX_DOCUMENT_ID', p_value => p_claim_id, p_parameterlist => l_parameter_list);
4626: wf_event.addparametertolist(p_name => 'ECX_DEBUG_LEVEL', p_value => l_debug_mode, p_parameterlist => l_parameter_list);
4627: wf_event.RAISE(l_event_name, evtkey, NULL, l_parameter_list, sysdate);
4628:
4629: COMMIT;
4630: EXCEPTION

Line 4627: wf_event.RAISE(l_event_name, evtkey, NULL, l_parameter_list, sysdate);

4623: wf_event.addparametertolist(p_name => 'ECX_PARTY_ID', p_value => p_party_id, p_parameterlist => l_parameter_list);
4624: wf_event.addparametertolist(p_name => 'ECX_PARTY_SITE_ID', p_value => p_party_site_id, p_parameterlist => l_parameter_list);
4625: wf_event.addparametertolist(p_name => 'ECX_DOCUMENT_ID', p_value => p_claim_id, p_parameterlist => l_parameter_list);
4626: wf_event.addparametertolist(p_name => 'ECX_DEBUG_LEVEL', p_value => l_debug_mode, p_parameterlist => l_parameter_list);
4627: wf_event.RAISE(l_event_name, evtkey, NULL, l_parameter_list, sysdate);
4628:
4629: COMMIT;
4630: EXCEPTION
4631: WHEN Fnd_Api.G_EXC_ERROR THEN