DBA Data[Home] [Help]

APPS.QA_SOLUTION_DISPOSITION_PKG dependencies on FND_API

Line 236: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

232:
233: IF (l_plan_id = -1 OR l_organization_id = -1) THEN
234:
235: -- We may need to populate appropriate error message here before return.
236: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
238:
239: -- Update the Disposition Status to 'Pending'.
240: UPDATE_STATUS(l_plan_id,p_collection_id,p_occurrence);

Line 679: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

675:
676: IF (l_plan_id = -1 OR l_organization_id = -1) THEN
677:
678: -- We may need to populate appropriate error message here before return.
679: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
680: END IF;
681:
682: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
683:

Line 826: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

822:
823: END LOOP;
824:
825: ELSE
826: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
827: END IF;
828:
829: l_wait := FND_CONCURRENT.WAIT_FOR_REQUEST(l_child_request,
830: g_check_request_time,

Line 1127: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1123:
1124: IF (l_plan_id = -1 OR l_organization_id = -1) THEN
1125:
1126: -- We may need to populate appropriate error message here before return.
1127: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1128: END IF;
1129:
1130: -- Update the Dispostion Status to 'Pending'.
1131: UPDATE_STATUS(l_plan_id, p_collection_id, p_occurrence);

Line 1577: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1573:
1574: IF (l_plan_id = -1 OR l_organization_id = -1) THEN
1575:
1576: -- We may need to populate appropriate error message here before return.
1577: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1578: END IF;
1579:
1580: -- Update the Disposition Status to 'Pending'.
1581: UPDATE_STATUS(l_plan_id,p_collection_id,p_occurrence);

Line 1642: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1638: l_serial_control_code NUMBER;
1639: l_revision_control_code NUMBER;
1640:
1641: l_status VARCHAR2(2000);
1642: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1643: l_msg_count NUMBER;
1644: l_msg_data VARCHAR2(240);
1645: l_message VARCHAR2(2000);
1646:

Line 1648: -- FND_API.G_MISS_NUM. kabalakr.

1644: l_msg_data VARCHAR2(240);
1645: l_message VARCHAR2(2000);
1646:
1647: -- Bug 2698365. GSCC warning fix. Commented the usage of
1648: -- FND_API.G_MISS_NUM. kabalakr.
1649: l_header_id NUMBER; -- := FND_API.G_MISS_NUM;
1650:
1651: l_line_num NUMBER := 0;
1652: l_order_count NUMBER := 1;

Line 1649: l_header_id NUMBER; -- := FND_API.G_MISS_NUM;

1645: l_message VARCHAR2(2000);
1646:
1647: -- Bug 2698365. GSCC warning fix. Commented the usage of
1648: -- FND_API.G_MISS_NUM. kabalakr.
1649: l_header_id NUMBER; -- := FND_API.G_MISS_NUM;
1650:
1651: l_line_num NUMBER := 0;
1652: l_order_count NUMBER := 1;
1653: l_commit VARCHAR2(1) := FND_API.G_FALSE;

Line 1653: l_commit VARCHAR2(1) := FND_API.G_FALSE;

1649: l_header_id NUMBER; -- := FND_API.G_MISS_NUM;
1650:
1651: l_line_num NUMBER := 0;
1652: l_order_count NUMBER := 1;
1653: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1654:
1655: l_request_number VARCHAR2(30);
1656:
1657: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;

Line 1672: -- Bug 2698365. GSCC warning fix. Moved the usage of FND_API.G_MISS_NUM

1668: AND organization_id = p_organization_id;
1669:
1670: BEGIN
1671:
1672: -- Bug 2698365. GSCC warning fix. Moved the usage of FND_API.G_MISS_NUM
1673: -- to here. kabalakr.
1674: l_header_id := FND_API.G_MISS_NUM;
1675:
1676: -- populate Header WHO columns

Line 1674: l_header_id := FND_API.G_MISS_NUM;

1670: BEGIN
1671:
1672: -- Bug 2698365. GSCC warning fix. Moved the usage of FND_API.G_MISS_NUM
1673: -- to here. kabalakr.
1674: l_header_id := FND_API.G_MISS_NUM;
1675:
1676: -- populate Header WHO columns
1677: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;
1678: l_trohdr_rec.creation_date := sysdate;

Line 1692: l_trohdr_rec.db_flag := FND_API.G_TRUE;

1688: l_trohdr_rec.status_date := sysdate;
1689: l_trohdr_rec.date_required := p_date_required;
1690: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REQUISITION;
1691: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
1692: l_trohdr_rec.db_flag := FND_API.G_TRUE;
1693: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
1694:
1695: l_line_num := l_line_num + 1;
1696:

Line 1748: l_trolin_tbl(l_order_count).line_id := FND_API.G_MISS_NUM;

1744: l_trolin_tbl(l_order_count).task_id := p_task_id;
1745:
1746:
1747: l_trolin_tbl(l_order_count).header_id := l_trohdr_rec.header_id;
1748: l_trolin_tbl(l_order_count).line_id := FND_API.G_MISS_NUM;
1749:
1750: l_trolin_tbl(l_order_count).line_number := l_line_num;
1751: l_trolin_tbl(l_order_count).line_status := INV_GLOBALS.G_TO_STATUS_PREAPPROVED;
1752:

Line 1755: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;

1751: l_trolin_tbl(l_order_count).line_status := INV_GLOBALS.G_TO_STATUS_PREAPPROVED;
1752:
1753: l_trolin_Tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
1754:
1755: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;
1756: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;
1757:
1758:
1759: Inv_Move_Order_Pub.Process_Move_order(

Line 1761: p_init_msg_list => FND_API.G_FALSE,

1757:
1758:
1759: Inv_Move_Order_Pub.Process_Move_order(
1760: p_api_version_number => 1.0,
1761: p_init_msg_list => FND_API.G_FALSE,
1762: p_return_values => FND_API.G_TRUE,
1763: p_commit => FND_API.G_FALSE,
1764: x_return_status => l_return_status,
1765: x_msg_count => l_msg_count,

Line 1762: p_return_values => FND_API.G_TRUE,

1758:
1759: Inv_Move_Order_Pub.Process_Move_order(
1760: p_api_version_number => 1.0,
1761: p_init_msg_list => FND_API.G_FALSE,
1762: p_return_values => FND_API.G_TRUE,
1763: p_commit => FND_API.G_FALSE,
1764: x_return_status => l_return_status,
1765: x_msg_count => l_msg_count,
1766: x_msg_data => l_msg_data,

Line 1763: p_commit => FND_API.G_FALSE,

1759: Inv_Move_Order_Pub.Process_Move_order(
1760: p_api_version_number => 1.0,
1761: p_init_msg_list => FND_API.G_FALSE,
1762: p_return_values => FND_API.G_TRUE,
1763: p_commit => FND_API.G_FALSE,
1764: x_return_status => l_return_status,
1765: x_msg_count => l_msg_count,
1766: x_msg_data => l_msg_data,
1767: p_trohdr_rec => l_trohdr_rec,

Line 1778: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1774: x_trolin_val_tbl => l_trolin_val_tbl
1775: );
1776:
1777:
1778: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1779: l_status := g_failed;
1780: x_request_number := NULL;
1781:
1782: ELSE

Line 1937: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1933:
1934: IF (l_plan_id = -1 OR l_organization_id = -1) THEN
1935:
1936: -- We may need to populate appropriate error message here before return.
1937: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1938: END IF;
1939:
1940: IF p_transaction_date IS NULL THEN
1941: l_transaction_date := sysdate;

Line 2163: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2159:
2160: IF (l_plan_id = -1 OR l_organization_id = -1) THEN
2161:
2162: -- We may need to populate appropriate error message here before return.
2163: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2164: END IF;
2165:
2166: IF p_transaction_date IS NULL THEN
2167: l_transaction_date := sysdate;

Line 2601: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2597:
2598: IF (l_plan_id = -1 OR l_organization_id = -1) THEN
2599:
2600: -- We may need to populate appropriate error message here before return.
2601: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2602: END IF;
2603:
2604: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
2605:

Line 2714: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2710:
2711: END LOOP;
2712:
2713: ELSE
2714: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2715: END IF;
2716:
2717: l_wait := FND_CONCURRENT.WAIT_FOR_REQUEST(l_child_request,
2718: g_check_request_time,

Line 2974: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2970:
2971: IF (l_plan_id = -1 OR l_organization_id = -1) THEN
2972:
2973: -- We may need to populate appropriate error message here before return.
2974: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2975: END IF;
2976:
2977: OPEN group_cur;
2978: FETCH group_cur INTO l_group_id;