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.OZF_REQUEST_STATUS_PVT dependencies on OZF_UTILITY_PVT

Line 66: ozf_utility_pvt.debug_message( l_api_name||': Start');

62: -- Standard begin of API savepoint
63: SAVEPOINT Event_Subscription_PVT;
64: -- Debug Message
65: IF G_DEBUG THEN
66: ozf_utility_pvt.debug_message( l_api_name||': Start');
67: END IF;
68:
69: l_parameter_list := p_event.getParameterList();
70: l_event_key := p_event.getEventKey();

Line 73: ozf_utility_pvt.debug_message( 'Event Key ' || l_event_key);

69: l_parameter_list := p_event.getParameterList();
70: l_event_key := p_event.getEventKey();
71:
72: IF G_DEBUG THEN
73: ozf_utility_pvt.debug_message( 'Event Key ' || l_event_key);
74: END IF;
75:
76: IF l_parameter_list IS NOT NULL THEN
77: i := l_parameter_list.FIRST;

Line 81: ozf_utility_pvt.debug_message( 'Parameter Name ' || l_parameter_list(i).getName());

77: i := l_parameter_list.FIRST;
78: WHILE ( i <= l_parameter_list.last) LOOP
79:
80: IF G_DEBUG THEN
81: ozf_utility_pvt.debug_message( 'Parameter Name ' || l_parameter_list(i).getName());
82: ozf_utility_pvt.debug_message( 'Parameter Value ' || l_parameter_list(i).getValue());
83: ozf_utility_pvt.debug_message( 'Parameter ' || i || ' of ' || l_parameter_list.last);
84: END IF;
85:

Line 82: ozf_utility_pvt.debug_message( 'Parameter Value ' || l_parameter_list(i).getValue());

78: WHILE ( i <= l_parameter_list.last) LOOP
79:
80: IF G_DEBUG THEN
81: ozf_utility_pvt.debug_message( 'Parameter Name ' || l_parameter_list(i).getName());
82: ozf_utility_pvt.debug_message( 'Parameter Value ' || l_parameter_list(i).getValue());
83: ozf_utility_pvt.debug_message( 'Parameter ' || i || ' of ' || l_parameter_list.last);
84: END IF;
85:
86: l_parameter_name := null;

Line 83: ozf_utility_pvt.debug_message( 'Parameter ' || i || ' of ' || l_parameter_list.last);

79:
80: IF G_DEBUG THEN
81: ozf_utility_pvt.debug_message( 'Parameter Name ' || l_parameter_list(i).getName());
82: ozf_utility_pvt.debug_message( 'Parameter Value ' || l_parameter_list(i).getValue());
83: ozf_utility_pvt.debug_message( 'Parameter ' || i || ' of ' || l_parameter_list.last);
84: END IF;
85:
86: l_parameter_name := null;
87: l_parameter_name := l_parameter_list(i).getName();

Line 112: ozf_utility_pvt.debug_message( 'Before call create_interaction. ');

108: l_approval_rec.object_id := l_object_id;
109: l_approval_rec.status_code := l_status;
110:
111: IF G_DEBUG THEN
112: ozf_utility_pvt.debug_message( 'Before call create_interaction. ');
113: END IF;
114:
115: -- Create_Interaction History
116: Create_Interaction (

Line 155: ozf_utility_pvt.debug_message( l_api_name||': End');

151: RETURN 'SUCCESS';
152:
153: -- Debug Message
154: IF G_DEBUG THEN
155: ozf_utility_pvt.debug_message( l_api_name||': End');
156: END IF;
157:
158: EXCEPTION
159: WHEN OTHERS THEN

Line 408: ozf_utility_pvt.debug_message( 'inside Notification ' || p_itemKey );

404: close lc_vendor_name;
405:
406: if p_itemtype = 'OZFSPBEN' then
407:
408: ozf_utility_pvt.debug_message( 'inside Notification ' || p_itemKey );
409: ozf_utility_pvt.debug_message( 'Phone number is ' || l_partner_cont_phone );
410:
411: wf_engine.SetItemAttrText( itemtype => p_itemtype,
412: itemkey => p_itemKey,

Line 409: ozf_utility_pvt.debug_message( 'Phone number is ' || l_partner_cont_phone );

405:
406: if p_itemtype = 'OZFSPBEN' then
407:
408: ozf_utility_pvt.debug_message( 'inside Notification ' || p_itemKey );
409: ozf_utility_pvt.debug_message( 'Phone number is ' || l_partner_cont_phone );
410:
411: wf_engine.SetItemAttrText( itemtype => p_itemtype,
412: itemkey => p_itemKey,
413: aname => 'REQUEST_NUMBER',

Line 590: l_decline_meaning := OZF_Utility_PVT.get_lookup_meaning('OZF_SP_REQUEST_DECLINE_CODE',l_decline_code);

586: avalue => l_partner_dtail_url);
587:
588:
589: IF l_decline_code IS NOT NULL THEN
590: l_decline_meaning := OZF_Utility_PVT.get_lookup_meaning('OZF_SP_REQUEST_DECLINE_CODE',l_decline_code);
591: wf_engine.SetItemAttrText( itemtype => p_itemtype,
592: itemkey => p_itemKey,
593: aname => 'DECLINE_REASON',
594: avalue => l_decline_meaning);

Line 743: l_decline_meaning := OZF_Utility_PVT.get_lookup_meaning('OZF_SF_DECLINE_CODE',l_decline_code);

739: aname => 'PARTNER_DTAIL_URL',
740: avalue => l_partner_dtail_url);
741:
742: IF l_decline_code IS NOT NULL THEN
743: l_decline_meaning := OZF_Utility_PVT.get_lookup_meaning('OZF_SF_DECLINE_CODE',l_decline_code);
744: wf_engine.SetItemAttrText( itemtype => p_itemtype,
745: itemkey => p_itemKey,
746: aname => 'DECLINE_REASON',
747: avalue => l_decline_meaning);

Line 748: ozf_utility_pvt.debug_message( l_decline_meaning||': l_decline_meaning');

744: wf_engine.SetItemAttrText( itemtype => p_itemtype,
745: itemkey => p_itemKey,
746: aname => 'DECLINE_REASON',
747: avalue => l_decline_meaning);
748: ozf_utility_pvt.debug_message( l_decline_meaning||': l_decline_meaning');
749: END IF;
750:
751: IF l_return_code IS NOT NULL AND l_return_code <> '' THEN
752: l_return_meaning := OZF_Utility_PVT.get_lookup_meaning('OZF_SF_RETURN_CODE',l_return_code);

Line 752: l_return_meaning := OZF_Utility_PVT.get_lookup_meaning('OZF_SF_RETURN_CODE',l_return_code);

748: ozf_utility_pvt.debug_message( l_decline_meaning||': l_decline_meaning');
749: END IF;
750:
751: IF l_return_code IS NOT NULL AND l_return_code <> '' THEN
752: l_return_meaning := OZF_Utility_PVT.get_lookup_meaning('OZF_SF_RETURN_CODE',l_return_code);
753: wf_engine.SetItemAttrText( itemtype => p_itemtype,
754: itemkey => p_itemKey,
755: aname => 'RETURN_REASON',
756: avalue => l_return_code);

Line 994: ozf_utility_pvt.debug_message( l_api_name||': Start');

990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
991: END IF;
992: -- Debug Message
993: IF G_DEBUG THEN
994: ozf_utility_pvt.debug_message( l_api_name||': Start');
995: END IF;
996: --Initialize message list if p_init_msg_list is TRUE.
997: IF FND_API.To_Boolean (p_init_msg_list) THEN
998: FND_MSG_PUB.initialize;

Line 1138: ozf_utility_pvt.debug_message( 'Before creating interaction ' || l_message_code);

1134:
1135: END IF;
1136:
1137: IF G_DEBUG THEN
1138: ozf_utility_pvt.debug_message( 'Before creating interaction ' || l_message_code);
1139: END IF;
1140:
1141: IF l_message_code IS NOT null THEN
1142: -- Create Interaction History

Line 1157: ozf_utility_pvt.debug_message( 'after creating interaction ' || l_return_status);

1153: x_return_status => l_return_status,
1154: x_msg_count => x_msg_count,
1155: x_msg_data => x_msg_data
1156: );
1157: ozf_utility_pvt.debug_message( 'after creating interaction ' || l_return_status);
1158: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1159: RAISE FND_API.G_EXC_ERROR;
1160: END IF;
1161:

Line 1171: ozf_utility_pvt.debug_message( l_api_name||': End');

1167: COMMIT WORK;
1168: END IF;
1169: -- Debug Message
1170: IF G_DEBUG THEN
1171: ozf_utility_pvt.debug_message( l_api_name||': End');
1172: END IF;
1173: --Standard call to get message count and if count=1, get the message
1174: FND_MSG_PUB.Count_And_Get (
1175: p_encoded => FND_API.G_FALSE,

Line 1251: ozf_utility_pvt.debug_message( l_api_name||': Start');

1247:
1248: BEGIN
1249: -- Debug Message
1250: IF G_DEBUG THEN
1251: ozf_utility_pvt.debug_message( l_api_name||': Start');
1252: END IF;
1253: l_parameter_list := p_event.getParameterList();
1254: l_event_key := p_event.getEventKey();
1255:

Line 1257: ozf_utility_pvt.debug_message( 'Event Key ' || l_event_key);

1253: l_parameter_list := p_event.getParameterList();
1254: l_event_key := p_event.getEventKey();
1255:
1256: IF G_DEBUG THEN
1257: ozf_utility_pvt.debug_message( 'Event Key ' || l_event_key);
1258: END IF;
1259:
1260: IF l_parameter_list IS NOT NULL THEN
1261: i := l_parameter_list.FIRST;

Line 1264: ozf_utility_pvt.debug_message( 'Parameter Name ' || l_parameter_list(i).getName());

1260: IF l_parameter_list IS NOT NULL THEN
1261: i := l_parameter_list.FIRST;
1262: WHILE ( i <= l_parameter_list.last) LOOP
1263: IF G_DEBUG THEN
1264: ozf_utility_pvt.debug_message( 'Parameter Name ' || l_parameter_list(i).getName());
1265: ozf_utility_pvt.debug_message( 'Parameter Value ' || l_parameter_list(i).getValue());
1266: ozf_utility_pvt.debug_message( 'Parameter ' || i || ' of ' || l_parameter_list.last);
1267: END IF;
1268: l_parameter_name := null;

Line 1265: ozf_utility_pvt.debug_message( 'Parameter Value ' || l_parameter_list(i).getValue());

1261: i := l_parameter_list.FIRST;
1262: WHILE ( i <= l_parameter_list.last) LOOP
1263: IF G_DEBUG THEN
1264: ozf_utility_pvt.debug_message( 'Parameter Name ' || l_parameter_list(i).getName());
1265: ozf_utility_pvt.debug_message( 'Parameter Value ' || l_parameter_list(i).getValue());
1266: ozf_utility_pvt.debug_message( 'Parameter ' || i || ' of ' || l_parameter_list.last);
1267: END IF;
1268: l_parameter_name := null;
1269: l_parameter_name := l_parameter_list(i).getName();

Line 1266: ozf_utility_pvt.debug_message( 'Parameter ' || i || ' of ' || l_parameter_list.last);

1262: WHILE ( i <= l_parameter_list.last) LOOP
1263: IF G_DEBUG THEN
1264: ozf_utility_pvt.debug_message( 'Parameter Name ' || l_parameter_list(i).getName());
1265: ozf_utility_pvt.debug_message( 'Parameter Value ' || l_parameter_list(i).getValue());
1266: ozf_utility_pvt.debug_message( 'Parameter ' || i || ' of ' || l_parameter_list.last);
1267: END IF;
1268: l_parameter_name := null;
1269: l_parameter_name := l_parameter_list(i).getName();
1270: IF l_parameter_name = 'OBJECT_ID' THEN

Line 1280: ozf_utility_pvt.debug_message( 'before calling api to send notification');

1276: END LOOP;
1277:
1278: -- Call api to send notification
1279: IF G_DEBUG THEN
1280: ozf_utility_pvt.debug_message( 'before calling api to send notification');
1281: END IF;
1282:
1283: OZF_APPROVAL_PVT.Send_SD_Notification(
1284: p_api_version => l_api_version,

Line 1293: ozf_utility_pvt.debug_message( 'Return Status: '||l_return_status);

1289: p_object_id => l_object_id,
1290: p_action_code => l_action_code);
1291:
1292: IF G_DEBUG THEN
1293: ozf_utility_pvt.debug_message( 'Return Status: '||l_return_status);
1294: END IF;
1295: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1296: RETURN 'ERROR';
1297: END IF;

Line 1305: ozf_utility_pvt.debug_message( l_api_name||': End');

1301: RETURN 'SUCCESS';
1302:
1303: -- Debug Message
1304: IF G_DEBUG THEN
1305: ozf_utility_pvt.debug_message( l_api_name||': End');
1306: END IF;
1307:
1308: EXCEPTION
1309: WHEN OTHERS THEN