APPS.PV_BATCH_ASSIGN_PUB dependencies on FND_API

Line 160: l_return_status := FND_API.G_RET_STS_SUCCESS ;

156: p_token1 => 'P_DATE_TIME',
157: p_token1_value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
158:
159:
160: l_return_status := FND_API.G_RET_STS_SUCCESS ;
161:
162: l_size := 0;
163: l_lead_id_tbl := JTF_NUMBER_TABLE();
164: l_lead_desc_tbl := JTF_VARCHAR2_TABLE_400();

Line 208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

204: Debug('l_resource_id = ' || l_resource_id);
205:
206: IF (lc_get_resource%NOTFOUND) THEN
207: CLOSE lc_get_resource;
208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;
210:
211: CLOSE lc_get_resource;
212:

Line 281: p_init_msg_list => FND_API.G_FALSE,

277: Debug('**********************************************************************');
278:
279: pv_opp_match_pub.Opportunity_Selection(
280: p_api_version => l_api_version_number,
281: p_init_msg_list => FND_API.G_FALSE,
282: p_commit => FND_API.G_FALSE,
283: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
284: p_entity_id => l_lead_id,
285: p_entity => 'LEAD',

Line 282: p_commit => FND_API.G_FALSE,

278:
279: pv_opp_match_pub.Opportunity_Selection(
280: p_api_version => l_api_version_number,
281: p_init_msg_list => FND_API.G_FALSE,
282: p_commit => FND_API.G_FALSE,
283: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
284: p_entity_id => l_lead_id,
285: p_entity => 'LEAD',
286: p_user_name => p_username,

Line 283: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

279: pv_opp_match_pub.Opportunity_Selection(
280: p_api_version => l_api_version_number,
281: p_init_msg_list => FND_API.G_FALSE,
282: p_commit => FND_API.G_FALSE,
283: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
284: p_entity_id => l_lead_id,
285: p_entity => 'LEAD',
286: p_user_name => p_username,
287: p_resource_id => l_resource_id,

Line 296: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS) THEN

292: x_msg_count => l_msg_count,
293: x_msg_data => l_msg_data
294: );
295:
296: IF (l_return_status <> fnd_api.G_RET_STS_SUCCESS) THEN
297:
298: IF l_msg_count > 0 THEN
299:
300: l_message := fnd_msg_pub.get(

Line 301: p_msg_index => fnd_msg_pub.g_first, p_encoded => FND_API.g_false

297:
298: IF l_msg_count > 0 THEN
299:
300: l_message := fnd_msg_pub.get(
301: p_msg_index => fnd_msg_pub.g_first, p_encoded => FND_API.g_false
302: );
303:
304: WHILE (l_message IS NOT NULL) LOOP
305: fnd_file.put_line(FND_FILE.LOG,substr(l_message,1,200));

Line 306: l_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);

302: );
303:
304: WHILE (l_message IS NOT NULL) LOOP
305: fnd_file.put_line(FND_FILE.LOG,substr(l_message,1,200));
306: l_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
307: END LOOP;
308:
309: END IF;
310:

Line 327: WHEN FND_API.G_EXC_ERROR THEN

323: RAISE l_auto_match_exec;
324: END IF;
325:
326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
328: ROLLBACK TO vendor_opp;
329:
330: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
331: p_msg_name => 'PV_NO_OPP_ASSIGN',

Line 414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

410: p_token1_value => TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS'));
411:
412: EXCEPTION
413:
414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
415: Set_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
416: p_msg_name => 'PV_NO_RESOURCE_FOUND');
417:
418: RETCODE := 2;