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 FND_LOG

Line 59: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': Start');

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

Line 66: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Event Key ' || l_event_key);

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

Line 73: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Parameter Name ' || l_parameter_list(i).getName());

69: IF l_parameter_list IS NOT NULL THEN
70: i := l_parameter_list.FIRST;
71: WHILE ( i <= l_parameter_list.last) LOOP
72:
73: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Parameter Name ' || l_parameter_list(i).getName());
74: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Parameter Value ' || l_parameter_list(i).getValue());
75: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Parameter ' || i || ' of ' || l_parameter_list.last);
76:
77: l_parameter_name := null;

Line 74: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Parameter Value ' || l_parameter_list(i).getValue());

70: i := l_parameter_list.FIRST;
71: WHILE ( i <= l_parameter_list.last) LOOP
72:
73: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Parameter Name ' || l_parameter_list(i).getName());
74: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Parameter Value ' || l_parameter_list(i).getValue());
75: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Parameter ' || i || ' of ' || l_parameter_list.last);
76:
77: l_parameter_name := null;
78: l_parameter_name := l_parameter_list(i).getName();

Line 75: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Parameter ' || i || ' of ' || l_parameter_list.last);

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

Line 121: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': End');

117: RETURN 'SUCCESS';
118:
119: -- Debug Message
120:
121: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, l_api_name||': End');
122:
123:
124: EXCEPTION
125: WHEN OTHERS THEN

Line 255: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

251:
252:
253: BEGIN
254:
255: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
257: 'dpp.plsql.DPP_REQUEST_STATUS_PVT.Set_Request_Message.start',
258: 'Item type:' || p_itemtype || 'Item key:' || p_itemkey || '. Entity id: ' ||
259: p_transaction_header_id || '. Status:' || p_status );

Line 256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

252:
253: BEGIN
254:
255: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
256: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
257: 'dpp.plsql.DPP_REQUEST_STATUS_PVT.Set_Request_Message.start',
258: 'Item type:' || p_itemtype || 'Item key:' || p_itemkey || '. Entity id: ' ||
259: p_transaction_header_id || '. Status:' || p_status );
260: end if;

Line 305: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'inside Notification ' || p_itemKey );

301: close lc_last_approver_name;
302:
303: if p_itemtype = 'DPPTXAPP' then
304:
305: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'inside Notification ' || p_itemKey );
306: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Phone number is ' || l_contact_phone );
307:
308:
309: wf_engine.SetItemAttrText( itemtype => p_itemtype,

Line 306: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Phone number is ' || l_contact_phone );

302:
303: if p_itemtype = 'DPPTXAPP' then
304:
305: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'inside Notification ' || p_itemKey );
306: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Phone number is ' || l_contact_phone );
307:
308:
309: wf_engine.SetItemAttrText( itemtype => p_itemtype,
310: itemkey => p_itemKey,

Line 314: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_vendor_name ' || l_vendor_name );

310: itemkey => p_itemKey,
311: aname => 'SUPPLIER_NAME',
312: avalue => l_vendor_name);
313:
314: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_vendor_name ' || l_vendor_name );
315:
316:
317: wf_engine.SetItemAttrText( itemtype => p_itemtype,
318: itemkey => p_itemKey,

Line 322: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_vendor_site_code ' || l_vendor_site_code );

318: itemkey => p_itemKey,
319: aname => 'SUPPLIER_SITE_CODE',
320: avalue => l_vendor_site_code);
321:
322: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_vendor_site_code ' || l_vendor_site_code );
323:
324: wf_engine.SetItemAttrText( itemtype => p_itemtype,
325: itemkey => p_itemKey,
326: aname => 'SUPPLIER_CONTACT',

Line 330: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_contact_name ' || l_contact_name );

326: aname => 'SUPPLIER_CONTACT',
327: avalue => l_contact_name
328: );
329:
330: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_contact_name ' || l_contact_name );
331:
332: wf_engine.SetItemAttrText( itemtype => p_itemtype,
333: itemkey => p_itemKey,
334: aname => 'SUPPLIER_CONTACT_PHONE',

Line 337: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_contact_phone ' || l_contact_phone );

333: itemkey => p_itemKey,
334: aname => 'SUPPLIER_CONTACT_PHONE',
335: avalue => l_contact_phone);
336:
337: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_contact_phone ' || l_contact_phone );
338:
339: /* wf_engine.SetItemAttrDate( itemtype => p_itemtype,
340: itemkey => p_itemKey,
341: aname => 'SUPPLIER_CONTACT_MAIL',

Line 344: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_contact_email ' || l_contact_email );

340: itemkey => p_itemKey,
341: aname => 'SUPPLIER_CONTACT_MAIL',
342: avalue => l_contact_email); */
343:
344: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_contact_email ' || l_contact_email );
345: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_transaction_header_id is ' || l_transaction_header_id );
346:
347: wf_engine.SetItemAttrText( itemtype => p_itemtype,
348: itemkey => p_itemKey,

Line 345: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_transaction_header_id is ' || l_transaction_header_id );

341: aname => 'SUPPLIER_CONTACT_MAIL',
342: avalue => l_contact_email); */
343:
344: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_contact_email ' || l_contact_email );
345: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_transaction_header_id is ' || l_transaction_header_id );
346:
347: wf_engine.SetItemAttrText( itemtype => p_itemtype,
348: itemkey => p_itemKey,
349: aname => 'TRANSACTION_HEADER_ID',

Line 357: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_ref_document_number is ' || l_ref_document_number );

353: itemkey => p_itemKey,
354: aname => 'TRANSACTION_NUMBER',
355: avalue => l_transaction_number);
356:
357: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_ref_document_number is ' || l_ref_document_number );
358:
359: wf_engine.SetItemAttrText( itemtype => p_itemtype,
360: itemkey => p_itemKey,
361: aname => 'REF_DOCUMENT_NUMBER',

Line 374: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_start_date is ' || l_start_date );

370: itemkey => p_itemKey,
371: aname => 'TRANSACTION_STATUS',
372: avalue => l_transaction_status);
373:
374: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_start_date is ' || l_start_date );
375:
376: wf_engine.SetItemAttrText( itemtype => p_itemtype,
377: itemkey => p_itemKey,
378: aname => 'EFFECTIVE_START_DATE',

Line 386: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_days_covered is ' || l_days_covered );

382: itemkey => p_itemKey,
383: aname => 'DAYS_COVERED',
384: avalue => l_days_covered);
385:
386: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'l_days_covered is ' || l_days_covered );
387:
388: open lc_get_function_id(pc_func_name => 'DPP_TXNUPDPG');
389: fetch lc_get_function_id into l_function_id;
390: close lc_get_function_id;

Line 433: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

429: avalue => l_decline_meaning);
430: END IF;
431:
432: end if;
433: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
434: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
435: 'dpp.plsql.DPP_REQUEST_STATUS_PVT.Set_Request_Message.end', 'Exiting');
436: end if;
437:

Line 434: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

430: END IF;
431:
432: end if;
433: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
434: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
435: 'dpp.plsql.DPP_REQUEST_STATUS_PVT.Set_Request_Message.end', 'Exiting');
436: end if;
437:
438: END;