DBA Data[Home] [Help]

APPS.CSP_EXCESS_PARTS_PVT dependencies on FND_API

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

59: ) IS
60:
61: l_api_version_number CONSTANT NUMBER := 1.0;
62: l_api_name CONSTANT VARCHAR2(30) := 'Create Excess Parts';
63: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
64: l_msg_count NUMBER;
65: l_msg_data VARCHAR2(2000);
66:
67: l_user_id NUMBER;

Line 473: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

469: , p_exception_set_id => l_exception_set_id
470: , x_return_status => l_Return_status
471: , x_msg_data => l_msg_data);
472:
473: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
474: RAISE FND_API.G_EXC_ERROR;
475: END IF;
476:
477: --ORGANIZATION Level

Line 474: RAISE FND_API.G_EXC_ERROR;

470: , x_return_status => l_Return_status
471: , x_msg_data => l_msg_data);
472:
473: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
474: RAISE FND_API.G_EXC_ERROR;
475: END IF;
476:
477: --ORGANIZATION Level
478: --if l_level = 1 then

Line 1531: , p_init_msg_lst => fnd_api.g_false

1527: , p_inventory_item_id => p_inventory_item_id
1528: , p_subinventory_code => p_subinventory_code
1529: , x_qoh => l_qoh
1530: , x_atr => l_atr
1531: , p_init_msg_lst => fnd_api.g_false
1532: , p_tree_mode => inv_quantity_tree_pvt.g_transaction_mode
1533: , p_is_revision_control => TRUE
1534: , p_is_lot_control => NULL
1535: , p_is_serial_control => NULL

Line 1568: , p_init_msg_lst => fnd_api.g_false

1564: , p_inventory_item_id => p_inventory_item_id
1565: , p_subinventory_code => p_subinventory_code
1566: , x_qoh => l_qoh
1567: , x_atr => l_atr
1568: , p_init_msg_lst => fnd_api.g_false
1569: , p_tree_mode => inv_quantity_tree_pvt.g_transaction_mode
1570: , p_is_revision_control => NULL
1571: , p_is_lot_control => NULL
1572: , p_is_serial_control => NULL

Line 2611: p_init_msg_list => fnd_api.g_true,

2607: end if; -- End of FND Logger If block
2608:
2609: JTY_TERR_SPARES_PVT.process_match_terr_spares (
2610: p_api_version_number => 1.0,
2611: p_init_msg_list => fnd_api.g_true,
2612: p_TerrServReq_Rec => l_sr_rec,
2613: p_Resource_Type => null,
2614: p_Role => null,
2615: p_plan_start_date => null,

Line 2778: x_return_status := FND_API.G_RET_STS_SUCCESS;

2774: l_sr_rec JTF_TERRITORY_PUB.JTF_Serv_Req_rec_type;
2775: x_return_rule_id number := null;
2776:
2777: begin
2778: x_return_status := FND_API.G_RET_STS_SUCCESS;
2779: -- Find Territory
2780: open c_address;
2781: fetch c_address into l_sr_rec.city,
2782: l_sr_rec.postal_code,

Line 2791: p_init_msg_list => fnd_api.g_true,

2787: close c_address;
2788:
2789: jty_terr_spares_pvt.process_match_terr_spares(
2790: p_api_version_number => 1.0,
2791: p_init_msg_list => fnd_api.g_true,
2792: p_terrservreq_rec => l_sr_rec,
2793: p_resource_type => null,
2794: p_role => null,
2795: p_plan_start_date => null,

Line 2834: x_return_status := FND_API.G_RET_STS_ERROR;

2830: fnd_msg_pub.add;
2831: fnd_msg_pub.count_and_get
2832: ( p_count => x_msg_count
2833: , p_data => x_msg_data);
2834: x_return_status := FND_API.G_RET_STS_ERROR;
2835: end if;
2836:
2837: end charges_return_routing;
2838: