DBA Data[Home] [Help]

APPS.QPR_DEAL_PVT dependencies on FND_API

Line 564: return_status:= FND_API.G_RET_STS_SUCCESS;

560: and instance_id = p_instance_id
561: and request_status in ('ACTIVE', 'CLOSED');
562: -- and request_status = 'ACTIVE';
563:
564: return_status:= FND_API.G_RET_STS_SUCCESS;
565: exception
566: when others then
567: return_status:= FND_API.G_RET_STS_ERROR;
568: end;

Line 567: return_status:= FND_API.G_RET_STS_ERROR;

563:
564: return_status:= FND_API.G_RET_STS_SUCCESS;
565: exception
566: when others then
567: return_status:= FND_API.G_RET_STS_ERROR;
568: end;
569:
570: procedure handle_request_event(p_quote_origin in number,
571: p_quote_header_id in number,

Line 597: return_status := FND_API.G_RET_STS_ERROR;

593: begin
594: savepoint handle_event;
595: if (p_request_header_id is null and p_response_header_id is null and
596: (p_quote_origin is null or p_quote_header_id is null)) then
597: return_status := FND_API.G_RET_STS_ERROR;
598: else
599: update_request(p_request_header_id, callback_status);
600:
601: if p_instance_id is null or p_quote_origin is null or

Line 614: return_status := FND_API.G_RET_STS_ERROR;

610: and req.request_header_id = nvl(p_request_header_id, req.request_header_id)
611: and res.response_header_id = nvl(p_response_header_id, res.response_header_id);
612: exception
613: when no_data_found then
614: return_status := FND_API.G_RET_STS_ERROR;
615: return;
616: end;
617: else
618: instance_id := p_instance_id;

Line 680: if l_ret <> FND_API.G_RET_STS_SUCCESS then

676: execute immediate l_api_call_st using
677: in quote_header_id, in l_resource_id, in callback_status,
678: out l_ret,out l_mesg_count, out l_mesg;
679: end if;
680: if l_ret <> FND_API.G_RET_STS_SUCCESS then
681: return_status := FND_API.G_RET_STS_ERROR;
682: p_err_msg := l_mesg;
683: rollback to handle_event;
684: else

Line 681: return_status := FND_API.G_RET_STS_ERROR;

677: in quote_header_id, in l_resource_id, in callback_status,
678: out l_ret,out l_mesg_count, out l_mesg;
679: end if;
680: if l_ret <> FND_API.G_RET_STS_SUCCESS then
681: return_status := FND_API.G_RET_STS_ERROR;
682: p_err_msg := l_mesg;
683: rollback to handle_event;
684: else
685: return_status := FND_API.G_RET_STS_SUCCESS;

Line 685: return_status := FND_API.G_RET_STS_SUCCESS;

681: return_status := FND_API.G_RET_STS_ERROR;
682: p_err_msg := l_mesg;
683: rollback to handle_event;
684: else
685: return_status := FND_API.G_RET_STS_SUCCESS;
686: end if;
687: end if;
688: exception
689: when others then

Line 690: return_status := FND_API.G_RET_STS_ERROR;

686: end if;
687: end if;
688: exception
689: when others then
690: return_status := FND_API.G_RET_STS_ERROR;
691: rollback to handle_event;
692: end handle_request_event;
693:
694: procedure update_request(p_request_header_id number,