DBA Data[Home] [Help]

APPS.GMP_WPS_WRITER dependencies on FND_API

Line 1203: | p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input to

1199: | Return ATR quantity at org, item level using Item tree
1200: |
1201: | ARGUMENTS
1202: | p_api_version API Version of this procedure. Current version is 1.0
1203: | p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input to
1204: | determine whether to Initialize message list or not
1205: | x_return_status Returns the status to indicate success or failure of execution
1206: | x_msg_count Returns number of error message in the error message stack in
1207: | case of failure

Line 1266: x_return_status := fnd_api.g_ret_sts_success;

1262: p_transfer_subinventory_code := NULL;
1263: p_demand_source_type_id := gme_common_pvt.g_txn_source_type ;
1264: X_msg_data := NULL;
1265: x_msg_count := NULL;
1266: x_return_status := fnd_api.g_ret_sts_success;
1267: p_api_version_number := 1 ;
1268: p_init_msg_lst := fnd_api.g_false ;
1269: p_tree_mode := 1 ; -- for Reservations
1270: p_is_serial_control := FALSE;

Line 1268: p_init_msg_lst := fnd_api.g_false ;

1264: X_msg_data := NULL;
1265: x_msg_count := NULL;
1266: x_return_status := fnd_api.g_ret_sts_success;
1267: p_api_version_number := 1 ;
1268: p_init_msg_lst := fnd_api.g_false ;
1269: p_tree_mode := 1 ; -- for Reservations
1270: p_is_serial_control := FALSE;
1271:
1272: p_demand_source_header_id := -9999 ;

Line 1333: WHEN fnd_api.g_exc_error THEN

1329:
1330: RETURN x_atr ;
1331:
1332: EXCEPTION
1333: WHEN fnd_api.g_exc_error THEN
1334: x_return_status := fnd_api.g_ret_sts_error;
1335: fnd_msg_pub.count_and_get (p_count => x_msg_count
1336: ,p_data => x_msg_data);
1337: RETURN -1;

Line 1334: x_return_status := fnd_api.g_ret_sts_error;

1330: RETURN x_atr ;
1331:
1332: EXCEPTION
1333: WHEN fnd_api.g_exc_error THEN
1334: x_return_status := fnd_api.g_ret_sts_error;
1335: fnd_msg_pub.count_and_get (p_count => x_msg_count
1336: ,p_data => x_msg_data);
1337: RETURN -1;
1338: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1338: WHEN fnd_api.g_exc_unexpected_error THEN

1334: x_return_status := fnd_api.g_ret_sts_error;
1335: fnd_msg_pub.count_and_get (p_count => x_msg_count
1336: ,p_data => x_msg_data);
1337: RETURN -1;
1338: WHEN fnd_api.g_exc_unexpected_error THEN
1339: x_return_status := fnd_api.g_ret_sts_unexp_error;
1340: fnd_msg_pub.count_and_get (p_count => x_msg_count
1341: ,p_data => x_msg_data);
1342: RETURN -2;

Line 1339: x_return_status := fnd_api.g_ret_sts_unexp_error;

1335: fnd_msg_pub.count_and_get (p_count => x_msg_count
1336: ,p_data => x_msg_data);
1337: RETURN -1;
1338: WHEN fnd_api.g_exc_unexpected_error THEN
1339: x_return_status := fnd_api.g_ret_sts_unexp_error;
1340: fnd_msg_pub.count_and_get (p_count => x_msg_count
1341: ,p_data => x_msg_data);
1342: RETURN -2;
1343: WHEN OTHERS THEN

Line 1344: x_return_status := fnd_api.g_ret_sts_unexp_error;

1340: fnd_msg_pub.count_and_get (p_count => x_msg_count
1341: ,p_data => x_msg_data);
1342: RETURN -2;
1343: WHEN OTHERS THEN
1344: x_return_status := fnd_api.g_ret_sts_unexp_error;
1345: fnd_msg_pub.count_and_get (p_count => x_msg_count
1346: ,p_data => x_msg_data);
1347: RETURN -3;
1348: END get_wps_atr;

Line 1360: | p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input to

1356: | Return onhand quantity at org, item level using Item tree
1357: |
1358: | ARGUMENTS
1359: | p_api_version API Version of this procedure. Current version is 1.0
1360: | p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input to
1361: | determine whether to Initialize message list or not
1362: | x_return_status Returns the status to indicate success or failure of execution
1363: | x_msg_count Returns number of error message in the error message stack in
1364: | case of failure

Line 1440: ----- x_return_status := fnd_api.g_ret_sts_success;

1436: ----- p_transfer_subinventory_code := NULL;
1437: ----- p_demand_source_type_id := gme_common_pvt.g_txn_source_type ;
1438: ----- X_msg_data := NULL;
1439: ----- x_msg_count := NULL;
1440: ----- x_return_status := fnd_api.g_ret_sts_success;
1441: ----- p_api_version_number := 1 ;
1442: ----- p_init_msg_lst := fnd_api.g_false ;
1443:
1444: /* Transaction Mode will return on hand quantity and avaialble to transact

Line 1442: ----- p_init_msg_lst := fnd_api.g_false ;

1438: ----- X_msg_data := NULL;
1439: ----- x_msg_count := NULL;
1440: ----- x_return_status := fnd_api.g_ret_sts_success;
1441: ----- p_api_version_number := 1 ;
1442: ----- p_init_msg_lst := fnd_api.g_false ;
1443:
1444: /* Transaction Mode will return on hand quantity and avaialble to transact
1445: quantity, This onhand quantity does not consider the material statuses,
1446: If material status controlled on hand is required, then select on hand

Line 1532: WHEN fnd_api.g_exc_error THEN

1528:
1529: RETURN x_qoh ;
1530:
1531: EXCEPTION
1532: WHEN fnd_api.g_exc_error THEN
1533: x_return_status := fnd_api.g_ret_sts_error;
1534: fnd_msg_pub.count_and_get (p_count => x_msg_count
1535: ,p_data => x_msg_data);
1536: RETURN -1;

Line 1533: x_return_status := fnd_api.g_ret_sts_error;

1529: RETURN x_qoh ;
1530:
1531: EXCEPTION
1532: WHEN fnd_api.g_exc_error THEN
1533: x_return_status := fnd_api.g_ret_sts_error;
1534: fnd_msg_pub.count_and_get (p_count => x_msg_count
1535: ,p_data => x_msg_data);
1536: RETURN -1;
1537: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1537: WHEN fnd_api.g_exc_unexpected_error THEN

1533: x_return_status := fnd_api.g_ret_sts_error;
1534: fnd_msg_pub.count_and_get (p_count => x_msg_count
1535: ,p_data => x_msg_data);
1536: RETURN -1;
1537: WHEN fnd_api.g_exc_unexpected_error THEN
1538: x_return_status := fnd_api.g_ret_sts_unexp_error;
1539: fnd_msg_pub.count_and_get (p_count => x_msg_count
1540: ,p_data => x_msg_data);
1541: RETURN -2;

Line 1538: x_return_status := fnd_api.g_ret_sts_unexp_error;

1534: fnd_msg_pub.count_and_get (p_count => x_msg_count
1535: ,p_data => x_msg_data);
1536: RETURN -1;
1537: WHEN fnd_api.g_exc_unexpected_error THEN
1538: x_return_status := fnd_api.g_ret_sts_unexp_error;
1539: fnd_msg_pub.count_and_get (p_count => x_msg_count
1540: ,p_data => x_msg_data);
1541: RETURN -2;
1542: WHEN OTHERS THEN

Line 1543: x_return_status := fnd_api.g_ret_sts_unexp_error;

1539: fnd_msg_pub.count_and_get (p_count => x_msg_count
1540: ,p_data => x_msg_data);
1541: RETURN -2;
1542: WHEN OTHERS THEN
1543: x_return_status := fnd_api.g_ret_sts_unexp_error;
1544: fnd_msg_pub.count_and_get (p_count => x_msg_count
1545: ,p_data => x_msg_data);
1546: RETURN -3;
1547: END get_wps_onhand;