DBA Data[Home] [Help]

APPS.DPP_TRANSACTION_PVT dependencies on WF_EVENT

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

7: --29-Jan-2008 sanagar Bug 6773981
8: --06-Feb-2008 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-2008 sanagar Included event and subscription test(wf_event.test)
12: -- Rounded change value to 2 decimal
13: --08-Feb-2008 sanagar BUG 6806974
14: --24-Feb-2008 sanagar BUG 6816594
15: --03-Mar-2008 sanagar BUG 6856618

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

4319: evtkey := dbms_utility.get_time();
4320: IF DPP_DEBUG_HIGH_ON THEN
4321: dpp_utility_pvt.debug_message('Event Key = ' || evtkey);
4322: END IF;
4323: l_event_test := wf_event.test(l_event_name);
4324: IF l_event_test = 'NONE' THEN
4325: fnd_message.set_name('DPP', 'DPP_EVENT_SUBS_ERR');
4326: fnd_message.set_token('CLAIM_NUMBER', p_claim_id);
4327: x_msg_data := fnd_message.get();

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

4328: DPP_UTILITY_PVT.debug_message('No enabled local subscriptions reference the event, or the event does not exist.');
4329: RAISE FND_API.g_exc_error;
4330: END IF;
4331: -- DEFINE IN WF ATTRIBUTES
4332: wf_event.addparametertolist(p_name => 'ECX_MAP_CODE', p_value => l_map_code, p_parameterlist => l_parameter_list);
4333: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_TYPE', p_value => l_transaction_type, p_parameterlist => l_parameter_list);
4334: wf_event.addparametertolist(p_name => 'ECX_PARTY_TYPE', p_value => p_party_type, p_parameterlist => l_parameter_list);
4335: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_SUBTYPE', p_value => l_transaction_sub_type, p_parameterlist => l_parameter_list);
4336: wf_event.addparametertolist(p_name => 'ECX_PARTY_ID', p_value => p_party_id, p_parameterlist => l_parameter_list);

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

4329: RAISE FND_API.g_exc_error;
4330: END IF;
4331: -- DEFINE IN WF ATTRIBUTES
4332: wf_event.addparametertolist(p_name => 'ECX_MAP_CODE', p_value => l_map_code, p_parameterlist => l_parameter_list);
4333: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_TYPE', p_value => l_transaction_type, p_parameterlist => l_parameter_list);
4334: wf_event.addparametertolist(p_name => 'ECX_PARTY_TYPE', p_value => p_party_type, p_parameterlist => l_parameter_list);
4335: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_SUBTYPE', p_value => l_transaction_sub_type, p_parameterlist => l_parameter_list);
4336: wf_event.addparametertolist(p_name => 'ECX_PARTY_ID', p_value => p_party_id, p_parameterlist => l_parameter_list);
4337: wf_event.addparametertolist(p_name => 'ECX_PARTY_SITE_ID', p_value => p_party_site_id, p_parameterlist => l_parameter_list);

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

4330: END IF;
4331: -- DEFINE IN WF ATTRIBUTES
4332: wf_event.addparametertolist(p_name => 'ECX_MAP_CODE', p_value => l_map_code, p_parameterlist => l_parameter_list);
4333: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_TYPE', p_value => l_transaction_type, p_parameterlist => l_parameter_list);
4334: wf_event.addparametertolist(p_name => 'ECX_PARTY_TYPE', p_value => p_party_type, p_parameterlist => l_parameter_list);
4335: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_SUBTYPE', p_value => l_transaction_sub_type, p_parameterlist => l_parameter_list);
4336: wf_event.addparametertolist(p_name => 'ECX_PARTY_ID', p_value => p_party_id, p_parameterlist => l_parameter_list);
4337: wf_event.addparametertolist(p_name => 'ECX_PARTY_SITE_ID', p_value => p_party_site_id, p_parameterlist => l_parameter_list);
4338: wf_event.addparametertolist(p_name => 'ECX_DOCUMENT_ID', p_value => p_claim_id, p_parameterlist => l_parameter_list);

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

4331: -- DEFINE IN WF ATTRIBUTES
4332: wf_event.addparametertolist(p_name => 'ECX_MAP_CODE', p_value => l_map_code, p_parameterlist => l_parameter_list);
4333: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_TYPE', p_value => l_transaction_type, p_parameterlist => l_parameter_list);
4334: wf_event.addparametertolist(p_name => 'ECX_PARTY_TYPE', p_value => p_party_type, p_parameterlist => l_parameter_list);
4335: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_SUBTYPE', p_value => l_transaction_sub_type, p_parameterlist => l_parameter_list);
4336: wf_event.addparametertolist(p_name => 'ECX_PARTY_ID', p_value => p_party_id, p_parameterlist => l_parameter_list);
4337: wf_event.addparametertolist(p_name => 'ECX_PARTY_SITE_ID', p_value => p_party_site_id, p_parameterlist => l_parameter_list);
4338: wf_event.addparametertolist(p_name => 'ECX_DOCUMENT_ID', p_value => p_claim_id, p_parameterlist => l_parameter_list);
4339: wf_event.addparametertolist(p_name => 'ECX_DEBUG_LEVEL', p_value => l_debug_mode, p_parameterlist => l_parameter_list);

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

4332: wf_event.addparametertolist(p_name => 'ECX_MAP_CODE', p_value => l_map_code, p_parameterlist => l_parameter_list);
4333: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_TYPE', p_value => l_transaction_type, p_parameterlist => l_parameter_list);
4334: wf_event.addparametertolist(p_name => 'ECX_PARTY_TYPE', p_value => p_party_type, p_parameterlist => l_parameter_list);
4335: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_SUBTYPE', p_value => l_transaction_sub_type, p_parameterlist => l_parameter_list);
4336: wf_event.addparametertolist(p_name => 'ECX_PARTY_ID', p_value => p_party_id, p_parameterlist => l_parameter_list);
4337: wf_event.addparametertolist(p_name => 'ECX_PARTY_SITE_ID', p_value => p_party_site_id, p_parameterlist => l_parameter_list);
4338: wf_event.addparametertolist(p_name => 'ECX_DOCUMENT_ID', p_value => p_claim_id, p_parameterlist => l_parameter_list);
4339: wf_event.addparametertolist(p_name => 'ECX_DEBUG_LEVEL', p_value => l_debug_mode, p_parameterlist => l_parameter_list);
4340: wf_event.RAISE(l_event_name, evtkey, NULL, l_parameter_list, sysdate);

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

4333: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_TYPE', p_value => l_transaction_type, p_parameterlist => l_parameter_list);
4334: wf_event.addparametertolist(p_name => 'ECX_PARTY_TYPE', p_value => p_party_type, p_parameterlist => l_parameter_list);
4335: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_SUBTYPE', p_value => l_transaction_sub_type, p_parameterlist => l_parameter_list);
4336: wf_event.addparametertolist(p_name => 'ECX_PARTY_ID', p_value => p_party_id, p_parameterlist => l_parameter_list);
4337: wf_event.addparametertolist(p_name => 'ECX_PARTY_SITE_ID', p_value => p_party_site_id, p_parameterlist => l_parameter_list);
4338: wf_event.addparametertolist(p_name => 'ECX_DOCUMENT_ID', p_value => p_claim_id, p_parameterlist => l_parameter_list);
4339: wf_event.addparametertolist(p_name => 'ECX_DEBUG_LEVEL', p_value => l_debug_mode, p_parameterlist => l_parameter_list);
4340: wf_event.RAISE(l_event_name, evtkey, NULL, l_parameter_list, sysdate);
4341:

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

4334: wf_event.addparametertolist(p_name => 'ECX_PARTY_TYPE', p_value => p_party_type, p_parameterlist => l_parameter_list);
4335: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_SUBTYPE', p_value => l_transaction_sub_type, p_parameterlist => l_parameter_list);
4336: wf_event.addparametertolist(p_name => 'ECX_PARTY_ID', p_value => p_party_id, p_parameterlist => l_parameter_list);
4337: wf_event.addparametertolist(p_name => 'ECX_PARTY_SITE_ID', p_value => p_party_site_id, p_parameterlist => l_parameter_list);
4338: wf_event.addparametertolist(p_name => 'ECX_DOCUMENT_ID', p_value => p_claim_id, p_parameterlist => l_parameter_list);
4339: wf_event.addparametertolist(p_name => 'ECX_DEBUG_LEVEL', p_value => l_debug_mode, p_parameterlist => l_parameter_list);
4340: wf_event.RAISE(l_event_name, evtkey, NULL, l_parameter_list, sysdate);
4341:
4342: COMMIT;

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

4335: wf_event.addparametertolist(p_name => 'ECX_TRANSACTION_SUBTYPE', p_value => l_transaction_sub_type, p_parameterlist => l_parameter_list);
4336: wf_event.addparametertolist(p_name => 'ECX_PARTY_ID', p_value => p_party_id, p_parameterlist => l_parameter_list);
4337: wf_event.addparametertolist(p_name => 'ECX_PARTY_SITE_ID', p_value => p_party_site_id, p_parameterlist => l_parameter_list);
4338: wf_event.addparametertolist(p_name => 'ECX_DOCUMENT_ID', p_value => p_claim_id, p_parameterlist => l_parameter_list);
4339: wf_event.addparametertolist(p_name => 'ECX_DEBUG_LEVEL', p_value => l_debug_mode, p_parameterlist => l_parameter_list);
4340: wf_event.RAISE(l_event_name, evtkey, NULL, l_parameter_list, sysdate);
4341:
4342: COMMIT;
4343: EXCEPTION

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

4336: wf_event.addparametertolist(p_name => 'ECX_PARTY_ID', p_value => p_party_id, p_parameterlist => l_parameter_list);
4337: wf_event.addparametertolist(p_name => 'ECX_PARTY_SITE_ID', p_value => p_party_site_id, p_parameterlist => l_parameter_list);
4338: wf_event.addparametertolist(p_name => 'ECX_DOCUMENT_ID', p_value => p_claim_id, p_parameterlist => l_parameter_list);
4339: wf_event.addparametertolist(p_name => 'ECX_DEBUG_LEVEL', p_value => l_debug_mode, p_parameterlist => l_parameter_list);
4340: wf_event.RAISE(l_event_name, evtkey, NULL, l_parameter_list, sysdate);
4341:
4342: COMMIT;
4343: EXCEPTION
4344: WHEN Fnd_Api.G_EXC_ERROR THEN