[Home] [Help]
305: if p_itemtype = 'DPPTXAPP' then
306: dpp_utility_pvt.debug_message( 'inside Notification ' || p_itemKey );
307: dpp_utility_pvt.debug_message( 'Phone number is ' || l_contact_phone );
308:
309: wf_engine.SetItemAttrText( itemtype => p_itemtype,
310: itemkey => p_itemKey,
311: aname => 'SUPPLIER_NAME',
312: avalue => l_vendor_name);
313: dpp_utility_pvt.debug_message( 'l_vendor_name ' || l_vendor_name );
311: aname => 'SUPPLIER_NAME',
312: avalue => l_vendor_name);
313: dpp_utility_pvt.debug_message( 'l_vendor_name ' || l_vendor_name );
314:
315: wf_engine.SetItemAttrText( itemtype => p_itemtype,
316: itemkey => p_itemKey,
317: aname => 'SUPPLIER_SITE_CODE',
318: avalue => l_vendor_site_code);
319: dpp_utility_pvt.debug_message( 'l_vendor_site_code ' || l_vendor_site_code );
317: aname => 'SUPPLIER_SITE_CODE',
318: avalue => l_vendor_site_code);
319: dpp_utility_pvt.debug_message( 'l_vendor_site_code ' || l_vendor_site_code );
320:
321: wf_engine.SetItemAttrText( itemtype => p_itemtype,
322: itemkey => p_itemKey,
323: aname => 'SUPPLIER_CONTACT',
324: avalue => l_contact_name
325: );
324: avalue => l_contact_name
325: );
326: dpp_utility_pvt.debug_message( 'l_contact_name ' || l_contact_name );
327:
328: wf_engine.SetItemAttrText( itemtype => p_itemtype,
329: itemkey => p_itemKey,
330: aname => 'SUPPLIER_CONTACT_PHONE',
331: avalue => l_contact_phone);
332: dpp_utility_pvt.debug_message( 'l_contact_phone ' || l_contact_phone );
330: aname => 'SUPPLIER_CONTACT_PHONE',
331: avalue => l_contact_phone);
332: dpp_utility_pvt.debug_message( 'l_contact_phone ' || l_contact_phone );
333:
334: /* wf_engine.SetItemAttrDate( itemtype => p_itemtype,
335: itemkey => p_itemKey,
336: aname => 'SUPPLIER_CONTACT_MAIL',
337: avalue => l_contact_email); */
338: dpp_utility_pvt.debug_message( 'l_contact_email ' || l_contact_email );
337: avalue => l_contact_email); */
338: dpp_utility_pvt.debug_message( 'l_contact_email ' || l_contact_email );
339:
340: dpp_utility_pvt.debug_message( 'l_transaction_header_id is ' || l_transaction_header_id );
341: wf_engine.SetItemAttrText( itemtype => p_itemtype,
342: itemkey => p_itemKey,
343: aname => 'TRANSACTION_HEADER_ID',
344: avalue => l_transaction_header_id);
345:
342: itemkey => p_itemKey,
343: aname => 'TRANSACTION_HEADER_ID',
344: avalue => l_transaction_header_id);
345:
346: wf_engine.SetItemAttrText( itemtype => p_itemtype,
347: itemkey => p_itemKey,
348: aname => 'TRANSACTION_NUMBER',
349: avalue => l_transaction_number);
350: dpp_utility_pvt.debug_message( 'l_ref_document_number is ' || l_ref_document_number );
347: itemkey => p_itemKey,
348: aname => 'TRANSACTION_NUMBER',
349: avalue => l_transaction_number);
350: dpp_utility_pvt.debug_message( 'l_ref_document_number is ' || l_ref_document_number );
351: wf_engine.SetItemAttrText( itemtype => p_itemtype,
352: itemkey => p_itemKey,
353: aname => 'REF_DOCUMENT_NUMBER',
354: avalue => l_ref_document_number);
355:
352: itemkey => p_itemKey,
353: aname => 'REF_DOCUMENT_NUMBER',
354: avalue => l_ref_document_number);
355:
356: wf_engine.SetItemAttrText( itemtype => p_itemtype,
357: itemkey => p_itemKey,
358: aname => 'CURRENCY',
359: avalue => l_currency);
360:
357: itemkey => p_itemKey,
358: aname => 'CURRENCY',
359: avalue => l_currency);
360:
361: wf_engine.SetItemAttrText( itemtype => p_itemtype,
362: itemkey => p_itemKey,
363: aname => 'TRANSACTION_STATUS',
364: avalue => l_transaction_status);
365: dpp_utility_pvt.debug_message( 'l_start_date is ' || l_start_date );
362: itemkey => p_itemKey,
363: aname => 'TRANSACTION_STATUS',
364: avalue => l_transaction_status);
365: dpp_utility_pvt.debug_message( 'l_start_date is ' || l_start_date );
366: wf_engine.SetItemAttrText( itemtype => p_itemtype,
367: itemkey => p_itemKey,
368: aname => 'EFFECTIVE_START_DATE',
369: avalue => l_start_date);
370:
367: itemkey => p_itemKey,
368: aname => 'EFFECTIVE_START_DATE',
369: avalue => l_start_date);
370:
371: wf_engine.SetItemAttrText( itemtype => p_itemtype,
372: itemkey => p_itemKey,
373: aname => 'DAYS_COVERED',
374: avalue => l_days_covered);
375:
385: -1,
386: -1,
387: 0,
388: 'DPPReqFrmTxnHdrId=' || p_transaction_header_id );
389: wf_engine.SetItemAttrText( itemtype => p_itemtype,
390: itemkey => p_itemKey,
391: aname => 'USER_LOGIN_URL',
392: avalue => l_login_url );
393:
403: ;
404:
405:
406: -- Setting the attribute value for updated projects URL
407: wf_engine.SetItemAttrText
408: ( itemtype => p_itemtype,
409: itemkey => p_itemKey,
410: aname => 'USER_DTAIL_URL',
411: avalue => l_user_dtail_url
412: );
413:
414: if l_decline_code IS NOT NULL THEN
415: l_decline_meaning := OZF_Utility_PVT.get_lookup_meaning('DPP_TRANSACTION_DECLINE_CODE',l_decline_code);
416: wf_engine.SetItemAttrText( itemtype => p_itemtype,
417: itemkey => p_itemKey,
418: aname => 'DECLINE_REASON',
419: avalue => l_decline_meaning);
420: END IF;