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

Line 59: dpp_utility_pvt.debug_message( l_api_name||': Start');

55: -- Standard begin of API savepoint
56: SAVEPOINT Event_Subscription_PVT;
57: -- Debug Message
58: IF G_DEBUG THEN
59: dpp_utility_pvt.debug_message( l_api_name||': Start');
60: END IF;
61:
62: l_parameter_list := p_event.getParameterList();
63: l_event_key := p_event.getEventKey();

Line 66: dpp_utility_pvt.debug_message( 'Event Key ' || l_event_key);

62: l_parameter_list := p_event.getParameterList();
63: l_event_key := p_event.getEventKey();
64:
65: IF G_DEBUG THEN
66: dpp_utility_pvt.debug_message( 'Event Key ' || l_event_key);
67: END IF;
68:
69: IF l_parameter_list IS NOT NULL THEN
70: i := l_parameter_list.FIRST;

Line 74: dpp_utility_pvt.debug_message( 'Parameter Name ' || l_parameter_list(i).getName());

70: i := l_parameter_list.FIRST;
71: WHILE ( i <= l_parameter_list.last) LOOP
72:
73: IF G_DEBUG THEN
74: dpp_utility_pvt.debug_message( 'Parameter Name ' || l_parameter_list(i).getName());
75: dpp_utility_pvt.debug_message( 'Parameter Value ' || l_parameter_list(i).getValue());
76: dpp_utility_pvt.debug_message( 'Parameter ' || i || ' of ' || l_parameter_list.last);
77: END IF;
78:

Line 75: dpp_utility_pvt.debug_message( 'Parameter Value ' || l_parameter_list(i).getValue());

71: WHILE ( i <= l_parameter_list.last) LOOP
72:
73: IF G_DEBUG THEN
74: dpp_utility_pvt.debug_message( 'Parameter Name ' || l_parameter_list(i).getName());
75: dpp_utility_pvt.debug_message( 'Parameter Value ' || l_parameter_list(i).getValue());
76: dpp_utility_pvt.debug_message( 'Parameter ' || i || ' of ' || l_parameter_list.last);
77: END IF;
78:
79: l_parameter_name := null;

Line 76: dpp_utility_pvt.debug_message( 'Parameter ' || i || ' of ' || l_parameter_list.last);

72:
73: IF G_DEBUG THEN
74: dpp_utility_pvt.debug_message( 'Parameter Name ' || l_parameter_list(i).getName());
75: dpp_utility_pvt.debug_message( 'Parameter Value ' || l_parameter_list(i).getValue());
76: dpp_utility_pvt.debug_message( 'Parameter ' || i || ' of ' || l_parameter_list.last);
77: END IF;
78:
79: l_parameter_name := null;
80: l_parameter_name := l_parameter_list(i).getName();

Line 123: dpp_utility_pvt.debug_message( l_api_name||': End');

119: RETURN 'SUCCESS';
120:
121: -- Debug Message
122: IF G_DEBUG THEN
123: dpp_utility_pvt.debug_message( l_api_name||': End');
124: END IF;
125:
126: EXCEPTION
127: WHEN OTHERS THEN

Line 306: dpp_utility_pvt.debug_message( 'inside Notification ' || p_itemKey );

302: fetch lc_last_approver_name into l_last_approver_name;
303: close lc_last_approver_name;
304:
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,

Line 307: dpp_utility_pvt.debug_message( 'Phone number is ' || l_contact_phone );

303: close lc_last_approver_name;
304:
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',

Line 313: dpp_utility_pvt.debug_message( 'l_vendor_name ' || l_vendor_name );

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 );
314:
315: wf_engine.SetItemAttrText( itemtype => p_itemtype,
316: itemkey => p_itemKey,
317: aname => 'SUPPLIER_SITE_CODE',

Line 319: dpp_utility_pvt.debug_message( 'l_vendor_site_code ' || l_vendor_site_code );

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 );
320:
321: wf_engine.SetItemAttrText( itemtype => p_itemtype,
322: itemkey => p_itemKey,
323: aname => 'SUPPLIER_CONTACT',

Line 326: dpp_utility_pvt.debug_message( 'l_contact_name ' || l_contact_name );

322: itemkey => p_itemKey,
323: aname => 'SUPPLIER_CONTACT',
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',

Line 332: dpp_utility_pvt.debug_message( 'l_contact_phone ' || l_contact_phone );

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 );
333:
334: /* wf_engine.SetItemAttrDate( itemtype => p_itemtype,
335: itemkey => p_itemKey,
336: aname => 'SUPPLIER_CONTACT_MAIL',

Line 338: dpp_utility_pvt.debug_message( 'l_contact_email ' || l_contact_email );

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 );
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,

Line 340: dpp_utility_pvt.debug_message( 'l_transaction_header_id is ' || l_transaction_header_id );

336: aname => 'SUPPLIER_CONTACT_MAIL',
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);

Line 350: dpp_utility_pvt.debug_message( 'l_ref_document_number is ' || l_ref_document_number );

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 );
351: wf_engine.SetItemAttrText( itemtype => p_itemtype,
352: itemkey => p_itemKey,
353: aname => 'REF_DOCUMENT_NUMBER',
354: avalue => l_ref_document_number);

Line 365: dpp_utility_pvt.debug_message( 'l_start_date is ' || l_start_date );

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 );
366: wf_engine.SetItemAttrText( itemtype => p_itemtype,
367: itemkey => p_itemKey,
368: aname => 'EFFECTIVE_START_DATE',
369: avalue => l_start_date);

Line 376: dpp_utility_pvt.debug_message( 'l_days_covered is ' || l_days_covered );

372: itemkey => p_itemKey,
373: aname => 'DAYS_COVERED',
374: avalue => l_days_covered);
375:
376: dpp_utility_pvt.debug_message( 'l_days_covered is ' || l_days_covered );
377:
378:
379: open lc_get_function_id(pc_func_name => 'DPP_TXNUPDPG');
380: fetch lc_get_function_id into l_function_id;