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.

[Home] [Help]

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 398: ozf_utility_pvt.debug_message( 'inside Notification ' || p_itemKey );

394: close lc_vendor_name;
395:
396:
397: if p_itemtype = 'OZFSPBEN' then
398: ozf_utility_pvt.debug_message( 'inside Notification ' || p_itemKey );
399: ozf_utility_pvt.debug_message( 'Phone number is ' || l_partner_cont_phone );
400:
401: wf_engine.SetItemAttrText( itemtype => p_itemtype,
402: itemkey => p_itemKey,

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

395:
396:
397: if p_itemtype = 'OZFSPBEN' then
398: ozf_utility_pvt.debug_message( 'inside Notification ' || p_itemKey );
399: ozf_utility_pvt.debug_message( 'Phone number is ' || l_partner_cont_phone );
400:
401: wf_engine.SetItemAttrText( itemtype => p_itemtype,
402: itemkey => p_itemKey,
403: aname => 'REQUEST_NUMBER',

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

565: );
566:
567:
568: if l_decline_code IS NOT NULL THEN
569: l_decline_meaning := OZF_Utility_PVT.get_lookup_meaning('OZF_SP_REQUEST_DECLINE_CODE',l_decline_code);
570: wf_engine.SetItemAttrText( itemtype => p_itemtype,
571: itemkey => p_itemKey,
572: aname => 'DECLINE_REASON',
573: avalue => l_decline_meaning);

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

727: );
728:
729:
730: if l_decline_code IS NOT NULL THEN
731: l_decline_meaning := OZF_Utility_PVT.get_lookup_meaning('OZF_SF_DECLINE_CODE',l_decline_code);
732: wf_engine.SetItemAttrText( itemtype => p_itemtype,
733: itemkey => p_itemKey,
734: aname => 'DECLINE_REASON',
735: avalue => l_decline_meaning);

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

732: wf_engine.SetItemAttrText( itemtype => p_itemtype,
733: itemkey => p_itemKey,
734: aname => 'DECLINE_REASON',
735: avalue => l_decline_meaning);
736: ozf_utility_pvt.debug_message( l_decline_meaning||': l_decline_meaning');
737:
738: END IF;
739:
740: if l_return_code IS NOT NULL AND l_return_code <> '' THEN

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

737:
738: END IF;
739:
740: if l_return_code IS NOT NULL AND l_return_code <> '' THEN
741: l_return_meaning := OZF_Utility_PVT.get_lookup_meaning('OZF_SF_RETURN_CODE',l_return_code);
742: wf_engine.SetItemAttrText( itemtype => p_itemtype,
743: itemkey => p_itemKey,
744: aname => 'RETURN_REASON',
745: avalue => l_return_code);

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

977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
978: END IF;
979: -- Debug Message
980: IF G_DEBUG THEN
981: ozf_utility_pvt.debug_message( l_api_name||': Start');
982: END IF;
983: --Initialize message list if p_init_msg_list is TRUE.
984: IF FND_API.To_Boolean (p_init_msg_list) THEN
985: FND_MSG_PUB.initialize;

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

1121:
1122: END IF;
1123:
1124: IF G_DEBUG THEN
1125: ozf_utility_pvt.debug_message( 'Before creating interaction ' || l_message_code);
1126: END IF;
1127:
1128: IF l_message_code IS NOT null THEN
1129: -- Create Interaction History

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

1140: x_return_status => l_return_status,
1141: x_msg_count => x_msg_count,
1142: x_msg_data => x_msg_data
1143: );
1144: ozf_utility_pvt.debug_message( 'after creating interaction ' || l_return_status);
1145: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;
1148:

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

1154: COMMIT WORK;
1155: END IF;
1156: -- Debug Message
1157: IF G_DEBUG THEN
1158: ozf_utility_pvt.debug_message( l_api_name||': End');
1159: END IF;
1160: --Standard call to get message count and if count=1, get the message
1161: FND_MSG_PUB.Count_And_Get (
1162: p_encoded => FND_API.G_FALSE,

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

1234:
1235: BEGIN
1236: -- Debug Message
1237: IF G_DEBUG THEN
1238: ozf_utility_pvt.debug_message( l_api_name||': Start');
1239: END IF;
1240: l_parameter_list := p_event.getParameterList();
1241: l_event_key := p_event.getEventKey();
1242:

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

1240: l_parameter_list := p_event.getParameterList();
1241: l_event_key := p_event.getEventKey();
1242:
1243: IF G_DEBUG THEN
1244: ozf_utility_pvt.debug_message( 'Event Key ' || l_event_key);
1245: END IF;
1246:
1247: IF l_parameter_list IS NOT NULL THEN
1248: i := l_parameter_list.FIRST;

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

1247: IF l_parameter_list IS NOT NULL THEN
1248: i := l_parameter_list.FIRST;
1249: WHILE ( i <= l_parameter_list.last) LOOP
1250: IF G_DEBUG THEN
1251: ozf_utility_pvt.debug_message( 'Parameter Name ' || l_parameter_list(i).getName());
1252: ozf_utility_pvt.debug_message( 'Parameter Value ' || l_parameter_list(i).getValue());
1253: ozf_utility_pvt.debug_message( 'Parameter ' || i || ' of ' || l_parameter_list.last);
1254: END IF;
1255: l_parameter_name := null;

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

1248: i := l_parameter_list.FIRST;
1249: WHILE ( i <= l_parameter_list.last) LOOP
1250: IF G_DEBUG THEN
1251: ozf_utility_pvt.debug_message( 'Parameter Name ' || l_parameter_list(i).getName());
1252: ozf_utility_pvt.debug_message( 'Parameter Value ' || l_parameter_list(i).getValue());
1253: ozf_utility_pvt.debug_message( 'Parameter ' || i || ' of ' || l_parameter_list.last);
1254: END IF;
1255: l_parameter_name := null;
1256: l_parameter_name := l_parameter_list(i).getName();

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

1249: WHILE ( i <= l_parameter_list.last) LOOP
1250: IF G_DEBUG THEN
1251: ozf_utility_pvt.debug_message( 'Parameter Name ' || l_parameter_list(i).getName());
1252: ozf_utility_pvt.debug_message( 'Parameter Value ' || l_parameter_list(i).getValue());
1253: ozf_utility_pvt.debug_message( 'Parameter ' || i || ' of ' || l_parameter_list.last);
1254: END IF;
1255: l_parameter_name := null;
1256: l_parameter_name := l_parameter_list(i).getName();
1257: IF l_parameter_name = 'OBJECT_ID' THEN

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

1263: END LOOP;
1264:
1265: -- Call api to send notification
1266: IF G_DEBUG THEN
1267: ozf_utility_pvt.debug_message( 'before calling api to send notification');
1268: END IF;
1269:
1270: OZF_APPROVAL_PVT.Send_SD_Notification(
1271: p_api_version => l_api_version,

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

1276: p_object_id => l_object_id,
1277: p_action_code => l_action_code);
1278:
1279: IF G_DEBUG THEN
1280: ozf_utility_pvt.debug_message( 'Return Status: '||l_return_status);
1281: END IF;
1282: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1283: RETURN 'ERROR';
1284: END IF;

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

1288: RETURN 'SUCCESS';
1289:
1290: -- Debug Message
1291: IF G_DEBUG THEN
1292: ozf_utility_pvt.debug_message( l_api_name||': End');
1293: END IF;
1294:
1295: EXCEPTION
1296: WHEN OTHERS THEN