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 1581: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

1642: l_serial_control_code NUMBER;
1643: l_revision_control_code NUMBER;
1644:
1645: l_status VARCHAR2(2000);
1646: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1647: l_msg_count NUMBER;
1648: l_msg_data VARCHAR2(240);
1649: l_message VARCHAR2(2000);
1650:

Line 1652: -- FND_API.G_MISS_NUM. kabalakr.

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

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

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

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

1653: l_header_id NUMBER; -- := FND_API.G_MISS_NUM;
1654:
1655: l_line_num NUMBER := 0;
1656: l_order_count NUMBER := 1;
1657: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1658:
1659: l_request_number VARCHAR2(30);
1660:
1661: l_trohdr_rec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;

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

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

Line 1678: l_header_id := FND_API.G_MISS_NUM;

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

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

1692: l_trohdr_rec.status_date := sysdate;
1693: l_trohdr_rec.date_required := p_date_required;
1694: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REQUISITION;
1695: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
1696: l_trohdr_rec.db_flag := FND_API.G_TRUE;
1697: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
1698:
1699: l_line_num := l_line_num + 1;
1700:

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

1748: l_trolin_tbl(l_order_count).task_id := p_task_id;
1749:
1750:
1751: l_trolin_tbl(l_order_count).header_id := l_trohdr_rec.header_id;
1752: l_trolin_tbl(l_order_count).line_id := FND_API.G_MISS_NUM;
1753:
1754: l_trolin_tbl(l_order_count).line_number := l_line_num;
1755: l_trolin_tbl(l_order_count).line_status := INV_GLOBALS.G_TO_STATUS_PREAPPROVED;
1756:

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

1755: l_trolin_tbl(l_order_count).line_status := INV_GLOBALS.G_TO_STATUS_PREAPPROVED;
1756:
1757: l_trolin_Tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
1758:
1759: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;
1760: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;
1761:
1762:
1763: Inv_Move_Order_Pub.Process_Move_order(

Line 1765: p_init_msg_list => FND_API.G_FALSE,

1761:
1762:
1763: Inv_Move_Order_Pub.Process_Move_order(
1764: p_api_version_number => 1.0,
1765: p_init_msg_list => FND_API.G_FALSE,
1766: p_return_values => FND_API.G_TRUE,
1767: p_commit => FND_API.G_FALSE,
1768: x_return_status => l_return_status,
1769: x_msg_count => l_msg_count,

Line 1766: p_return_values => FND_API.G_TRUE,

1762:
1763: Inv_Move_Order_Pub.Process_Move_order(
1764: p_api_version_number => 1.0,
1765: p_init_msg_list => FND_API.G_FALSE,
1766: p_return_values => FND_API.G_TRUE,
1767: p_commit => FND_API.G_FALSE,
1768: x_return_status => l_return_status,
1769: x_msg_count => l_msg_count,
1770: x_msg_data => l_msg_data,

Line 1767: p_commit => FND_API.G_FALSE,

1763: Inv_Move_Order_Pub.Process_Move_order(
1764: p_api_version_number => 1.0,
1765: p_init_msg_list => FND_API.G_FALSE,
1766: p_return_values => FND_API.G_TRUE,
1767: p_commit => FND_API.G_FALSE,
1768: x_return_status => l_return_status,
1769: x_msg_count => l_msg_count,
1770: x_msg_data => l_msg_data,
1771: p_trohdr_rec => l_trohdr_rec,

Line 1782: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1778: x_trolin_val_tbl => l_trolin_val_tbl
1779: );
1780:
1781:
1782: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1783: l_status := g_failed;
1784: x_request_number := NULL;
1785:
1786: ELSE

Line 1941: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2167: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 2608: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2604:
2605: IF (l_plan_id = -1 OR l_organization_id = -1) THEN
2606:
2607: -- We may need to populate appropriate error message here before return.
2608: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2609: END IF;
2610:
2611: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);
2612:

Line 2730: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2726:
2727: END LOOP;
2728:
2729: ELSE
2730: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2731: END IF;
2732:
2733: l_wait := FND_CONCURRENT.WAIT_FOR_REQUEST(l_child_request,
2734: g_check_request_time,

Line 2990: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

2986:
2987: IF (l_plan_id = -1 OR l_organization_id = -1) THEN
2988:
2989: -- We may need to populate appropriate error message here before return.
2990: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2991: END IF;
2992:
2993: OPEN group_cur;
2994: FETCH group_cur INTO l_group_id;