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 FND_API

Line 118: p_init_msg_list => FND_API.G_FALSE,

114:
115: -- Create_Interaction History
116: Create_Interaction (
117: p_api_version => l_api_version,
118: p_init_msg_list => FND_API.G_FALSE,
119: x_return_status => l_return_status,
120: x_msg_data => l_msg_data,
121: x_msg_count => l_msg_count,
122: p_approval_rec => l_approval_rec );

Line 124: IF l_return_status = FND_API.g_ret_sts_error THEN

120: x_msg_data => l_msg_data,
121: x_msg_count => l_msg_count,
122: p_approval_rec => l_approval_rec );
123:
124: IF l_return_status = FND_API.g_ret_sts_error THEN
125: RAISE FND_API.g_exc_error;
126: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
127: RAISE FND_API.g_exc_unexpected_error;
128: END IF;

Line 125: RAISE FND_API.g_exc_error;

121: x_msg_count => l_msg_count,
122: p_approval_rec => l_approval_rec );
123:
124: IF l_return_status = FND_API.g_ret_sts_error THEN
125: RAISE FND_API.g_exc_error;
126: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
127: RAISE FND_API.g_exc_unexpected_error;
128: END IF;
129:

Line 126: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

122: p_approval_rec => l_approval_rec );
123:
124: IF l_return_status = FND_API.g_ret_sts_error THEN
125: RAISE FND_API.g_exc_error;
126: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
127: RAISE FND_API.g_exc_unexpected_error;
128: END IF;
129:
130: -- Call api to send notification

Line 127: RAISE FND_API.g_exc_unexpected_error;

123:
124: IF l_return_status = FND_API.g_ret_sts_error THEN
125: RAISE FND_API.g_exc_error;
126: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
127: RAISE FND_API.g_exc_unexpected_error;
128: END IF;
129:
130: -- Call api to send notification
131: OZF_APPROVAL_PVT.Send_Notification(

Line 133: p_init_msg_list => FND_API.G_FALSE,

129:
130: -- Call api to send notification
131: OZF_APPROVAL_PVT.Send_Notification(
132: p_api_version => l_api_version,
133: p_init_msg_list => FND_API.G_FALSE,
134: --p_validation_level => p_validation_level,
135: x_return_status => l_return_status,
136: x_msg_data => l_msg_data,
137: x_msg_count => l_msg_count,

Line 145: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

141: p_user_callback_api => l_user_callback_api,
142: p_approval_rec => l_approval_rec
143: );
144:
145: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
146: RETURN 'ERROR';
147: END IF;
148:
149: END IF;

Line 940: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

936: -- NOTES
937: ---------------------------------------------------------------------
938: PROCEDURE Create_Interaction (
939: p_api_version IN NUMBER
940: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
941: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
942: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
943:
944: ,x_return_status OUT NOCOPY VARCHAR2

Line 941: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

937: ---------------------------------------------------------------------
938: PROCEDURE Create_Interaction (
939: p_api_version IN NUMBER
940: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
941: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
942: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
943:
944: ,x_return_status OUT NOCOPY VARCHAR2
945: ,x_msg_data OUT NOCOPY VARCHAR2

Line 942: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

938: PROCEDURE Create_Interaction (
939: p_api_version IN NUMBER
940: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
941: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
942: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
943:
944: ,x_return_status OUT NOCOPY VARCHAR2
945: ,x_msg_data OUT NOCOPY VARCHAR2
946: ,x_msg_count OUT NOCOPY NUMBER

Line 984: IF NOT FND_API.Compatible_API_Call (

980: BEGIN
981: -- Standard begin of API savepoint
982: SAVEPOINT Create_Interaction_PVT;
983: -- Standard call to check for call compatibility.
984: IF NOT FND_API.Compatible_API_Call (
985: l_api_version,
986: p_api_version,
987: l_api_name,
988: G_PKG_NAME)

Line 990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

986: p_api_version,
987: l_api_name,
988: G_PKG_NAME)
989: THEN
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');

Line 997: IF FND_API.To_Boolean (p_init_msg_list) THEN

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;
999: END IF;
1000: -- Initialize API return status to sucess
1001: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1001: x_return_status := FND_API.G_RET_STS_SUCCESS;

997: IF FND_API.To_Boolean (p_init_msg_list) THEN
998: FND_MSG_PUB.initialize;
999: END IF;
1000: -- Initialize API return status to sucess
1001: x_return_status := FND_API.G_RET_STS_SUCCESS;
1002:
1003: -- Get Partner details
1004: OPEN csr_partner (p_approval_rec.object_id);
1005: FETCH csr_partner INTO l_partner_id,

Line 1158: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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:
1162: END IF;

Line 1159: RAISE FND_API.G_EXC_ERROR;

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:
1162: END IF;
1163:

Line 1166: IF FND_API.To_Boolean ( p_commit ) THEN

1162: END IF;
1163:
1164:
1165: --Standard check of commit
1166: IF FND_API.To_Boolean ( p_commit ) THEN
1167: COMMIT WORK;
1168: END IF;
1169: -- Debug Message
1170: IF G_DEBUG THEN

Line 1175: p_encoded => FND_API.G_FALSE,

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,
1176: p_count => x_msg_count,
1177: p_data => x_msg_data
1178: );
1179: EXCEPTION

Line 1180: WHEN FND_API.G_EXC_ERROR THEN

1176: p_count => x_msg_count,
1177: p_data => x_msg_data
1178: );
1179: EXCEPTION
1180: WHEN FND_API.G_EXC_ERROR THEN
1181: ROLLBACK TO Create_Interaction_PVT;
1182: x_return_status := FND_API.G_RET_STS_ERROR;
1183: -- Standard call to get message count and if count=1, get the message
1184: FND_MSG_PUB.Count_And_Get (

Line 1182: x_return_status := FND_API.G_RET_STS_ERROR;

1178: );
1179: EXCEPTION
1180: WHEN FND_API.G_EXC_ERROR THEN
1181: ROLLBACK TO Create_Interaction_PVT;
1182: x_return_status := FND_API.G_RET_STS_ERROR;
1183: -- Standard call to get message count and if count=1, get the message
1184: FND_MSG_PUB.Count_And_Get (
1185: p_encoded => FND_API.G_FALSE,
1186: p_count => x_msg_count,

Line 1185: p_encoded => FND_API.G_FALSE,

1181: ROLLBACK TO Create_Interaction_PVT;
1182: x_return_status := FND_API.G_RET_STS_ERROR;
1183: -- Standard call to get message count and if count=1, get the message
1184: FND_MSG_PUB.Count_And_Get (
1185: p_encoded => FND_API.G_FALSE,
1186: p_count => x_msg_count,
1187: p_data => x_msg_data
1188: );
1189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1185: p_encoded => FND_API.G_FALSE,
1186: p_count => x_msg_count,
1187: p_data => x_msg_data
1188: );
1189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1190: ROLLBACK TO Create_Interaction_PVT;
1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1192: -- Standard call to get message count and if count=1, get the message
1193: FND_MSG_PUB.Count_And_Get (

Line 1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1187: p_data => x_msg_data
1188: );
1189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1190: ROLLBACK TO Create_Interaction_PVT;
1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1192: -- Standard call to get message count and if count=1, get the message
1193: FND_MSG_PUB.Count_And_Get (
1194: p_encoded => FND_API.G_FALSE,
1195: p_count => x_msg_count,

Line 1194: p_encoded => FND_API.G_FALSE,

1190: ROLLBACK TO Create_Interaction_PVT;
1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1192: -- Standard call to get message count and if count=1, get the message
1193: FND_MSG_PUB.Count_And_Get (
1194: p_encoded => FND_API.G_FALSE,
1195: p_count => x_msg_count,
1196: p_data => x_msg_data
1197: );
1198: WHEN OTHERS THEN

Line 1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1196: p_data => x_msg_data
1197: );
1198: WHEN OTHERS THEN
1199: ROLLBACK TO Create_Interaction_PVT;
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1201: IF OZF_UNEXP_ERROR_ON
1202: THEN
1203: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1204: END IF;

Line 1207: p_encoded => FND_API.G_FALSE,

1203: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1204: END IF;
1205: -- Standard call to get message count and if count=1, get the message
1206: FND_MSG_PUB.Count_And_Get (
1207: p_encoded => FND_API.G_FALSE,
1208: p_count => x_msg_count,
1209: p_data => x_msg_data
1210: );
1211: --

Line 1285: p_init_msg_list => FND_API.G_FALSE,

1281: END IF;
1282:
1283: OZF_APPROVAL_PVT.Send_SD_Notification(
1284: p_api_version => l_api_version,
1285: p_init_msg_list => FND_API.G_FALSE,
1286: x_return_status => l_return_status,
1287: x_msg_data => l_msg_data,
1288: x_msg_count => l_msg_count,
1289: p_object_id => l_object_id,

Line 1295: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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;
1298:
1299: END IF;