APPS.M4R_OM_CONF_PKG dependencies on STANDARD

Line 199: L_STANDARD_CODE VARCHAR2(100);

195: p_funcmode IN VARCHAR2,
196: x_resultout IN OUT NOCOPY VARCHAR2) IS
197: L_PARTY_SITE_ID VARCHAR2(100);
198: L_PARTY_ID VARCHAR2(100);
199: L_STANDARD_CODE VARCHAR2(100);
200: l_eventkey VARCHAR2(100);
201: l_error_code NUMBER;
202: l_error_msg VARCHAR2(1000);
203: BEGIN

Line 217: select standard_code

213: -- Retrieve Activity Attributes
214: l_party_site_id := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_PARTY_SITE_ID');
215: l_party_id := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_PARTY_ID');
216:
217: select standard_code
218: into l_standard_code
219: from ecx_tp_details_v
220: where tp_header_id = (select tp_header_id from ecx_tp_headers
221: where party_id = l_party_id and

Line 218: into l_standard_code

214: l_party_site_id := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_PARTY_SITE_ID');
215: l_party_id := Wf_Engine.GetActivityAttrText(p_itemtype, p_itemkey, p_actid, 'ECX_PARTY_ID');
216:
217: select standard_code
218: into l_standard_code
219: from ecx_tp_details_v
220: where tp_header_id = (select tp_header_id from ecx_tp_headers
221: where party_id = l_party_id and
222: party_site_id = l_party_site_id) and

Line 225: if (l_standard_code = 'OAG') then

221: where party_id = l_party_id and
222: party_site_id = l_party_site_id) and
223: transaction_type ='ONT' and transaction_subtype = 'POA';
224:
225: if (l_standard_code = 'OAG') then
226: x_resultout := 'COMPLETE:T'; -- Reached Here. Successful execution.
227: else
228: x_resultout := 'COMPLETE:F';
229: l_eventkey :=p_itemkey;

Line 266: l_standard VARCHAR2(100);

262: l_xmlg_txn_type VARCHAR2(100);
263: l_xmlg_txn_subtype VARCHAR2(100);
264: l_tr_partner_id VARCHAR2(100);
265: l_tr_partner_site VARCHAR2(100);
266: l_standard VARCHAR2(100);
267: l_return_tmp VARCHAR2(100);
268: l_processing_stage VARCHAR2(100);
269: BEGIN
270: IF (l_Debug_Level <= 2) THEN

Line 294: cln_debug_pub.Add('Getting the Message Standard', 1);

290: END IF;
291:
292: IF (l_xmlg_txn_type = 'ONT' and l_xmlg_txn_subtype = 'POA' and l_processing_stage = 'OUTBOUND_SENT') THEN
293: IF (l_Debug_Level <= 1) THEN
294: cln_debug_pub.Add('Getting the Message Standard', 1);
295: END IF;
296:
297: l_tr_partner_id := WF_EVENT.getValueForParameter('TRADING_PARTNER_ID',l_evt_parameters);
298: IF (l_Debug_Level <= 1) THEN

Line 308: SELECT standard_code

304: cln_debug_pub.Add('Trading Partner Site ----'||l_tr_partner_site, 1);
305: END IF;
306:
307: BEGIN
308: SELECT standard_code
309: into l_standard
310: FROM ecx_tp_details_v
311: WHERE tp_header_id = (SELECT tp_header_id FROM ecx_tp_headers
312: WHERE party_id = l_tr_partner_id

Line 309: into l_standard

305: END IF;
306:
307: BEGIN
308: SELECT standard_code
309: into l_standard
310: FROM ecx_tp_details_v
311: WHERE tp_header_id = (SELECT tp_header_id FROM ecx_tp_headers
312: WHERE party_id = l_tr_partner_id
313: AND party_site_id = l_tr_partner_site

Line 325: IF l_standard = 'ROSETTANET' THEN

321: cln_debug_pub.Add('In valid paramerers passed to the event', 4);
322: END IF;
323: END;
324:
325: IF l_standard = 'ROSETTANET' THEN
326: -- For rosettan net standard this event shoudl be ignored
327: IF (l_Debug_Level <= 2) THEN
328: cln_debug_pub.Add('==========EXITING UPDATE_CH_OM_EVENT_SUB WITHOUT UPDATING COLLABORATION HISTORY ===========', 2);
329: END IF;

Line 326: -- For rosettan net standard this event shoudl be ignored

322: END IF;
323: END;
324:
325: IF l_standard = 'ROSETTANET' THEN
326: -- For rosettan net standard this event shoudl be ignored
327: IF (l_Debug_Level <= 2) THEN
328: cln_debug_pub.Add('==========EXITING UPDATE_CH_OM_EVENT_SUB WITHOUT UPDATING COLLABORATION HISTORY ===========', 2);
329: END IF;
330: RETURN 'SUCCESS';