DBA Data[Home] [Help]

APPS.RCV_DISTRIBUTIONS_S dependencies on FND_API

Line 57: l_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

53: X_valid_deliver_to_person BOOLEAN;
54: X_valid_subinventory BOOLEAN;
55:
56: --
57: l_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
58: l_code_combination_id PO_DISTRIBUTIONS.code_combination_id%TYPE;
59: --
60:
61: /* Bug 3816908 : Variable added */

Line 301: IF (l_status <> FND_API.G_RET_STS_SUCCESS) THEN

297: x_dest_subinv => x_deliver_to_sub,
298: x_rate => x_rate,
299: x_rate_date => x_rate_date);
300:
301: IF (l_status <> FND_API.G_RET_STS_SUCCESS) THEN
302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
303: END IF;
304: --
305:

Line 302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

298: x_rate => x_rate,
299: x_rate_date => x_rate_date);
300:
301: IF (l_status <> FND_API.G_RET_STS_SUCCESS) THEN
302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
303: END IF;
304: --
305:
306: X_destination_type_code := 'MULTIPLE';

Line 475: * FND_API.G_RET_STS_SUCCESS if no error occurs

471: * po_distribution_id is given, then return distribution information
472: * based on that distribution id.
473: * Returns:
474: * x_return_status:
475: * FND_API.G_RET_STS_SUCCESS if no error occurs
476: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs (e.g.,
477: * line_location_id does not exist in PO_LINE_LOCATIONS)
478: * x_kanban_card_number:
479: * Kanban Card Number. NULL if distribution does not contain kanban card info

Line 476: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs (e.g.,

472: * based on that distribution id.
473: * Returns:
474: * x_return_status:
475: * FND_API.G_RET_STS_SUCCESS if no error occurs
476: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs (e.g.,
477: * line_location_id does not exist in PO_LINE_LOCATIONS)
478: * x_kanban_card_number:
479: * Kanban Card Number. NULL if distribution does not contain kanban card info
480: * x_project_number:

Line 543: l_multi_distr VARCHAR2(1) := FND_API.G_FALSE;

539: l_wip_operation_seq_num PO_DISTRIBUTIONS.wip_operation_seq_num%TYPE;
540: l_wip_resource_seq_num PO_DISTRIBUTIONS.wip_resource_seq_num%TYPE;
541: l_to_organization_id PO_DISTRIBUTIONS.destination_organization_id%TYPE;
542:
543: l_multi_distr VARCHAR2(1) := FND_API.G_FALSE;
544: l_multiple_msg VARCHAR2(2000);
545:
546: l_progress VARCHAR2(3);
547:

Line 550: x_return_status := FND_API.G_RET_STS_SUCCESS;

546: l_progress VARCHAR2(3);
547:
548: BEGIN
549:
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551:
552: l_progress := '000';
553:
554: IF (p_line_location_id IS NULL) THEN

Line 586: l_multi_distr := FND_API.G_TRUE;

582: IF (l_num_distributions > 1) THEN
583:
584: l_progress := '010';
585:
586: l_multi_distr := FND_API.G_TRUE;
587:
588: FND_MESSAGE.set_name('PO', 'PO_MULTI_DEST_INFO');
589: l_multiple_msg := FND_MESSAGE.get;
590:

Line 621: IF (l_multi_distr = FND_API.G_FALSE) THEN

617: END IF;
618: END IF;
619: END IF;
620:
621: IF (l_multi_distr = FND_API.G_FALSE) THEN
622:
623: l_progress := '020';
624:
625: --SQL What: Retreive Distribution Information by distribution_id

Line 738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

734: END IF;
735:
736: EXCEPTION
737: WHEN OTHERS THEN
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
739: PO_MESSAGE_S.sql_error (l_api_name, l_progress, SQLCODE);
740: END get_misc_distr_info;
741:
742:

Line 752: * FND_API.G_RET_STS_SUCCESS if no error occurs

748: * Effects: get kanban card information from req line, project, task and
749: * charge account information from req distribution
750: * Returns:
751: * x_return_status:
752: * FND_API.G_RET_STS_SUCCESS if no error occurs
753: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs (e.g.,
754: * line_location_id does not exist in PO_LINE_LOCATIONS)
755: * x_kanban_card_number:
756: * Kanban Card Number. NULL if distribution does not contain kanban card info

Line 753: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs (e.g.,

749: * charge account information from req distribution
750: * Returns:
751: * x_return_status:
752: * FND_API.G_RET_STS_SUCCESS if no error occurs
753: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs (e.g.,
754: * line_location_id does not exist in PO_LINE_LOCATIONS)
755: * x_kanban_card_number:
756: * Kanban Card Number. NULL if distribution does not contain kanban card info
757: * x_project_number:

Line 785: x_return_status := FND_API.G_RET_STS_SUCCESS;

781: l_progress VARCHAR2(3) := '000';
782: x_project_id PO_REQ_DISTRIBUTIONS.project_id%type; -- bug 3867151
783: x_task_id PO_REQ_DISTRIBUTIONS.task_id%type; -- bug 3867151
784: BEGIN
785: x_return_status := FND_API.G_RET_STS_SUCCESS;
786:
787: IF (p_requisition_line_id IS NOT NULL) THEN
788: l_progress := '010';
789:

Line 881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

877: /* Bug 3867151 END */
878:
879: EXCEPTION
880: WHEN OTHERS THEN
881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
882: PO_MESSAGE_S.sql_error (l_api_name, l_progress, SQLCODE);
883: END get_misc_req_distr_info;
884:
885: --